Code: Select all
$sql="SELECT key_field, field1, field2, field3 FROM mytable WHERE random = 1 ORDER BY RAND() LIMIT 8";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);
I want to store each field like:
$key_fld1 = returned record 1 key_field
$key_fld2 = returned record 2 key_field...
etc...
$key_fld8 = returned record 8 key_field
$fld_1 = returned record 1 field1
$fld_2 = returned record 2 field1...
etc...
Also, with the query above, are these 8 unique or is it possible that it will result in duplicate records?
If it can repeat, I need to find out how to make it pick 8 unique records.
Thank you.