RE: [PHP] Random not working?

2003-03-01 Thread Rich Gray
> Hi All, > > I'm trying to get a random record each time this script runs; > Only it's giving me everytime the first record back.. No random at all.. > > // generate and execute query > $query = "SELECT stedenid, naamstad, stadomschrijvk FROM steden > ORDER BY RAND() LIMIT 1"; > $result = mysql_qu

[PHP] Re: [PHP-DB] RE: [PHP] Random not working?

2003-03-01 Thread Frank Keessen
March 02, 2003 2:36 AM Subject: [PHP-DB] RE: [PHP] Random not working? > > Hi All, > > > > I'm trying to get a random record each time this script runs; > > Only it's giving me everytime the first record back.. No random at all.. > > > > // gene

[PHP] RE: [PHP-DB] RE: [PHP] Random not working?

2003-03-01 Thread Dennis Cole
You might try getting the random number before the query. -Original Message- From: Rich Gray [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 8:37 PM To: Frank Keessen; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] RE: [PHP] Random not working? > Hi All, > > I