parse error

[novice_php]

hi, i need some help. im trying to create a script for my home page that will show random images, using the shuffle function. but im getting an error message. i get an output it its reading the aray in the order.

Warning: shuffle() expects parameter 1 to be array, resource given in c:\program files\apache group\Apache\htdocs\Prt1

i think this is the section of code which is not working corectly

		$query = "select * From products" ;
		$results = mysql_query($query)
		or die(mysql_error());

	shuffle($results);

	for ($i=0; $i <4; $i++) 
{
  		$row = mysql_fetch_array($results);
		extract ($row);
		$dvd_title=$row['product_name'];
}

[Shrike]

The error message pretty much says it all, $results is a MySQL resource. You'd need to fetch each row into an array and then use shuffle(). ORDER BY RAND() in the SQL should have the same effect.

Note: since your using an associative array using shuffle() directly might give unexpected results. Check the [MAN]shuffle[/MAN] docs for more information.