Re: [PHP] display query results at random

2001-09-26 Thread Steve Werby
Matthew Delmarter [EMAIL PROTECTED] wrote: How do I return a specific record from a db outside of the query? Let's say I select * from table (using mysql_fetch_object) and get 5 results. I want to display the 5 results in different / random places on the page. Place 1 - show details for

RE: [PHP] display query results at random

2001-09-26 Thread Jerry Lake
PROTECTED]] Sent: Tuesday, September 25, 2001 9:15 PM To: [EMAIL PROTECTED] Cc: PHP Mailing List Subject: RE: [PHP] display query results at random Hi Lawrence, Thanks for your reply. I should clarify that I want to control where I output the result. Place 1 - show details for record 3 //I specifically

RE: [PHP] display query results at random

2001-09-25 Thread Lawrence . Sheed
Return into an array, then loop through the array or shuffle it (easier)?. Note if you have nulls in DB, you will have to do something different. n'est pas? e.g. (untested) mysql_fetch_array ?php mysql_connect ($host, $user, $password); $result = mysql_db_query (database,select

RE: [PHP] display query results at random

2001-09-25 Thread Matthew Delmarter
PROTECTED] Subject: RE: [PHP] display query results at random Return into an array, then loop through the array or shuffle it (easier)?. Note if you have nulls in DB, you will have to do something different. n'est pas? e.g. (untested) mysql_fetch_array ?php mysql_connect ($host

RE: [PHP] display query results at random

2001-09-25 Thread Philip Olson
by the mysql query. Matthew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 3:56 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PHP] display query results at random Return into an array, then loop