Returning all results

[freelance84]

Hello, new to this forum, my name's, John.

 

I have a database in MySQL with one field, 'answers'.

 

$query = "SELECT * FROM m$selected";

$result = mysql_query($query);

if (!$result) die ("Database access failed: " . mysql_error());

 

$rows = mysql_result($result,0);

 

echo ($rows);

 

The above PHP script when added after a radio button form prints the 1st entry in the database.

How do I get it to return all the results?

$rows = mysql_result($result,0);  Is there a value I can replace the '0' with which means all? I tried star but it didn't work.

 

The book I'm learning from only tells me how to return individual rows, and some of the php libraries seem a bit daunting at the moment as I'm only a beginner

[freelance84]

The reason I want all the results to be returned is so I can use the shuffle() function to get a random result from the table

[ignace]

The reason I want all the results to be returned is so I can use the shuffle() function to get a random result from the table

 

SELECT * FROM m$selected ORDER BY rand() LIMIT 1