I'm not positive on this, but I think I catch your drift.
when you get the results of your query...
place 1 = $results[2]
place 2 = $results[0]
place 5 = $results[4]
Later,
Jerry Lake
Interface Engineering Technician
-----Original Message-----
From: Matthew Delmarter [mailto:[EMAIL 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 want record 3
details here
Place 2 - show details for record 1 //I specifically want record 1
details here
Place 5 - show details for record 5 //I specifically want record 5
details here
What I meant by 'random' was that it's not in the order returned 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 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 user_id, fullname from
table");
$j=0;
while ($row[$j] = mysql_fetch_array ($result)) {
$j++;
}
mysql_free_result ($result);
srand ((float)microtime()*1000000);
shuffle ($row);
//do output stuff with array
?>
-----Original Message-----
From: Matthew Delmarter [mailto:[EMAIL PROTECTED]]
Sent: September 26, 2001 12:01 PM
To: PHP Mailing List
Subject: [PHP] display query results at random
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 record 3
Place 2 - show details for record 1
Place 5 - show details for record 5
How do I do this?
I know how to loop thru a mysql result - but what if want to display
things in a random order around the page? I could have multiple select
statements - but this would increase the load on the server and is
unnecessary as all the data was returned from the query - it's just a
matter of knowing how to get it!
Can anyone help?
I am sorry if the question is confusing, but I can't think of a better
way to explain it at the moment (i'm tired)...
Matthew
--
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]
--
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]
