Random Record Problem

[timsharpe]

I am using the following to get a random record, but it comes back with query is empty why?

$query = mysql_query("SELECT * FROM autos WHERE category = autos ORDER BY RAND() LIMIT 0,1 ");

what am I doing wrong?

[superwormy]

That query shouldn't even work... you need to put strings in 'single quotes'

$query = mysql_query("SELECT * FROM autos WHERE category = 'autos' ORDER BY RAND() LIMIT 0,1 ");

Do this when running queries to test with:

$result = mysql_query ("SELECT * FROM table") or die (mysql_error());

[timsharpe]

$result = mysql_query ("SELECT * FROM autos") or die (mysql_error());

while ($row = mysql_fetch_array($result)) {
$array = $row['category'];
}



$random_quote = $array['rand(0, count($array)'];

echo "$random_quote";

?>

The above code somehow works but only shows an "a" when there is more in the record, how do I fix this?

[superwormy]

Why do you need this?

$random_quote = $array['rand(0, count($array)'];

Just do this:

$result = mysql_query ("SELECT fieldname FROM tablename ORDER BY RAND() LIMIT 1") or die (mysql_error());

$array = mysql_fetch_array ($result);

print ($array['fieldname']);

[superwormy]

And if you want to loop through a result set showing more than one...

$result = mysql_query ("SELECT fieldname FROM tablename ORDER BY RAND() ");

while ($array = mysql_fetch_array ($result)) {

print ($array['fieldname'] . "<br />");

}