Is it possible to read the results of a query that finds multiple rows into an array. At the moment, I have this
$quotenumsql = "SELECT `quote` FROM `quotes`";
$quotenumqry = mysql_query($quotenumsql) or die(mysql_error());
$numquotes = mysql_num_rows($quotenumqry);
$quoteary = mysql_fetch_array($quotenumqry, MYSQL_NUM);
$quotearysize = count($quoteary);
//get quote
$quotenumber = rand(0, $numquotes-1);
$quote = $quoteary[$quotenumber];
But when I echo $quotearysize, it returns 1, instead of the 15 rows in the database. I know the SQL is correct because I check it with phpmyadmin and 15 rows were returned. I just need to get these 15 rows into an array, with 1 row per array value.