mysql database display info separately

[Pain]

Hi there.

 

I have this simple code which displays 5 results. How can i grab each element separately instead of displaying all the results at once.

 

Thanks:)

 

 

<?php
$query = mysql_query("SELECT product_name, product_price FROM products WHERE product_type = 'laptop' LIMIT 5");
$numrows = mysql_num_rows($query);

if ($numrows != 0)
{
while ($row = mysql_fetch_assoc($query))
{
	$product_name = $row['product_name'];
	$product_price = $row['product_price'];
	echo $product_name . '<br />';
	echo $product_price . '<br /><br />';
}
}
?>

[litebearer]

something like...

 

if ($numrows != 0){
$i=0;
while ($row = mysql_fetch_assoc($query)){
	/* store results in an array */
	$mydata[$i] = $row['product_name'] . "<br />" . $row['product_price'] . '<br />';
	$i = $i + 1;
}
}
/* display each array element separately */

[Pain]

Thank you for your quick response. Your method worked for me:)