Re: [PHP-DB] Random select -- Where am I going wrong?

2004-07-05 Thread Alvaro Zuniga
See Below On Sun, 2004-07-04 at 05:54, Ronald "The Newbie" Allen wrote: > Here is my code I keep on getting a Resource id #2 ..whatever that > meansany help would be appreciated! > > > > > > Top Frame > > > > alink="#ff"> > > > $db_host = '##; > $db_user = '##

Re: [PHP-DB] Random select -- Where am I going wrong?

2004-07-04 Thread Larry E . Ullman
Here is my code I keep on getting a Resource id #2 ..whatever that meansany help would be appreciated! $music = mysql_query ("Select * from $db_table ORDER BY RAND() Limit 1"); if(!$music) die("Query Failed."); while($row = mysql_fetch_row($music)) print "$music"; } This is because

[PHP-DB] Random select -- Where am I going wrong?

2004-07-04 Thread Ronald \"The Newbie\" Allen
Here is my code I keep on getting a Resource id #2 ..whatever that meansany help would be appreciated! Top Frame -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] random select

2002-12-17 Thread Bruce Levick
thankyou that seemed to work well. - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 9:32 PM Subject: Re: [PHP-DB] random select > On Tuesday 17 December 2002 18:46, Bruce Levick wrote: >

Re: [PHP-DB] random select

2002-12-17 Thread Jason Wong
On Tuesday 17 December 2002 18:46, Bruce Levick wrote: > Bruce Levick - VivamotionI was curious as to what is the best way to select > a random row from a table in my database. > > I have currently five rows and will be expanding on that as well. I have > tried this code. > > ##

[PHP-DB] random select

2002-12-17 Thread Bruce Levick
Bruce Levick - VivamotionI was curious as to what is the best way to select a random row from a table in my database. I have currently five rows and will be expanding on that as well. I have tried this code. //retrieve rando