Re: [PHP] list table by date
You can sort in descending order in your sql statement
select * from messagem where flag-1 order by date desc
Seung-woo Nam
Augusto Cesar Castoldi wrote:
>
> I have a little mysql question. I'm using php to list a table from mysql.
>
> I'm doing: $result=mysql_query("select * from messagem where flag=1 order
> by
> date");
>
> But The first list of the "mysql_fetch_row($result)" is the first date. I
> want to start printing by the last date.
>
> But I want to know if I can do this by the mysql_query. I don't want this:
>
> $i = mysql_numrows($result);
> while ($i >= 0) {
> print mysql_result($result, $i, 'date')."";
> }
>
> regards,
>
> Augusto Cesar Castoldi
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] (Absolute beginner) .PHP3 and .HTM
Change the extension of hello3.htm to php3. The second one doesn't work because the web server only runs the php enginge when the file has a php extension (it depends on the server setting but usually just .php should work fine). PHP code can be embedded within HTML so basically you don't have to do everything in PHP like in your first script. Seung-woo Nam [EMAIL PROTECTED] wrote: > > My configuration: Win98 / Xitami / PHP3 / MySQL > PHP is installed in the path of Xitami. > > path xitami\cgi-bin\HELLO2.PHP3 > "http://localhost/cgi-bin/hello2.php3" It works! > > My bloody newbie question: > Where must I put HELLO3.HTM so that it can be run from the localhost > "http://localhost/hello3.htm" doesn't work! > > HELLO2.PHP3 > print"\n\n"; > echo "hello2"; > print"\n\n"; > ?> > > HELLO3.HTM > PHP Test > > "; ?> > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] How do i include ASP script into PHP...??!
ASP scripts require .asp extension and PHP scripts require .php extension. That's how a webserver invokes the right interpreter for the script. I suppose you could use ASP pages and PHP pages on the same server if you have something like MS IIS with php or Apache on *NIX with php and chillisoft asp interpreter but mixing both scripts on a same page is just pushing it. Maybe you could configure the webserver the way that it invokes both interpreters whenever it sees .php or .asp extensions but why on earth would you even want to try that kind of stuff? Seung-woo Nam Joe Truong wrote: > > How can i include ASP scripts into PHP files or is it posible? > thanxz > -Joe > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] baffled :<:
You didn't really say that in your initial post :-) So, what you mean is that the db line is not what you actually have in your script? The what do you really have? Just by looking at the script you posted, the reason it doesn't work certainly seems to be the invalid database handler. If you have a function that returns a handler, the syntax would be something like: include "connect.inc"; $db = db_connect(); This is assuming you have a function called db_connect() that returns a database handler in your 'connect.inc' file. Seung-woo Nam Peter Houchin wrote: > > yes i know it was mearly there to show i had it in my script as i said in my initial >post i could get info from the db, just not in the while loop > > -Original Message- > From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 17, 2001 4:08 PM > To: Peter Houchin > Cc: Php-General@Lists. Php. Net > Subject: Re: [PHP] baffled :<:< > > > $db = include"connect.inc"; > > includes do not return anything useful, so this is a bogus statement. > > > $foo = "SELECT * FROM 6pci WHERE card='$card' ORDER BY card"; > > > > $result = mysql_query($foo,$db); > > An include certainly cannot return a database handle. Included files > operate in the same variable scope as the script doing the inclusion. So > simply set $db in your connect.inc file and it will automatically be > available to you after the include. > > -Rasmus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Javascript mailing list
How about newsgroups instead? comp.lang.javascript seems to be pretty active. Seung-woo Nam "Boget, Chris" wrote: > > A bit OT, yes, but I don't want to ask an > inappropriate question here (not that this > isn't an inappropriate question :p). > Can someone recommend a good Javascript > mailing list? > > Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySQL data
Hi: The easiest way to do it is using mysqldump. mysqldump creates a file that contains SQL statements to reconstruct a database, which you can easily execute on the other database. It will create tables with same names and all the records will be copied, too. Seung-woo Nam Augusto Cesar Castoldi wrote: > > This question has not much with PHP, but I work with PHP... > > Can I get the data from a table in MySQL and copy/transfer all data to > other database to a table with the same name? > > regards, > > Augusto Cesar Castoldi > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] PHP Polls in popup window
Hi: You can use JavaScript for a popup window. Look up for window.open() function. You can pass the result to that output from PHP script. Seung-woo Nam Mohamedou wrote: > > Hello all, > > I have integrated a simple text based poll script in my homepage. > But I want get the survey results in a popup window, if somebody votes. > > How can I make that? > > Moh > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Buggy Java GUI? (just a tad OT)
Hi: If you don't have plenty of ram on your machine, forget about running Forte. Java applications that use swing look nice but they use a lot of systems resources. It's not a bug, per se, but whenever your systems runs out of physical memory and start writing stuff on the virtual memory, that's what you get. I have 224MB on my machine and Forte is still slow. Seung-woo Nam Plutarck wrote: > > I've been toying around with Java to possibly interface with PHP, but I have > a question about it. > > Is it just me, or is the GUI in most standalone java applications remarkably > (and annoyingly) buggy? > > I downloaded Forte for Java by Sun, and after the 45 second loading time I > noticed that if you click around the menus or move your cursor too fast, a > menu will become temporarily "burned" into the frame of the page. Same if > you hover on one button till a message comes up, then switch over to another > button, a portion of the original message will still be shown. > > Same goes for Limewire and other 100% java apps I've tried. > > I was just wondering if it's just my machine, or because I use the windows98 > VM, or if everyone experiences the same thing. > > I'm guessing the horrendous starting load time is native to java, but at > least it runs ok once you get the thing to start. > > -- > Plutarck > Should be working on something... > ...but forgot what it was. > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] __ $8/mo php hosting on 24/7, OC3+ web server ___
Jeffrey Greer wrote: > > I'm not trying to provide the level of service of a large isp or even > get 100 customers. I would just like to pay for my half of the web > portal. I thought $8/mo for my service would be a good value for php > programmers who do not need a high level of security. > > Would you say $8/mo is not a good value for the level of service I > will provide? > > Web hosting is not my main business. I'm a software developer. > Well, then what's that all about 'hosting your business' thing on your website? And I wonder how will you possibly garantee the uptime you talk about on the site? $8 is a cheap price only if you can actually provide certain level of service. Seung-woo Nam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] ezpublish install
http://developer.ez.no/filemanager/list/1/ There are installation doc files near the bottom of the page. Seung-woo Nam Peter Van Dijck wrote: > > Hi, > I think I finally found a cms that does most of what I want it to: > ezpublish ( http://developer.ez.no/article/archive/4/ ) > I'm trying to install it, I'm on a apache server, and having some problems. > > Where can I find help to install this? I've checked the entire website, > there's no answers to my questions on the forum there... > > Thanks for any tips > Peter > > ~~ > http://liga1.com: building multiple language/culture websites -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
