Random SELECT SQL list
| From: | Eduardo Vizcarra | Date: | Thu, 17 May 2007 04:40:17 +0000 |
| Subject: | Random SELECT SQL list | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-255042@lists.php.net to get a copy of this message | ||
Hi
I would like to know if a SELECT SQL query list of records can be unsorted.
SELECT statement retrieves a list of records from a certain table starting
from record # 1 till record #N and when publishing the records, this is how
it is presented, in a sequential way, is there any way to not present them
in a sequential way ? e.g. if a user accesses a web page then he will see
record #3 and then #7 and so on, another user accesses the same web page and
he might see record #8 and then record#2..... etc
any experience on how to do this ?
Regards
Eduardo