Do..While (Loop)

[Anon]

Can someone tell me how I do the following, I want to go through my database and any products that match a specific genre I want them to be printed on screen one after another.

I know you will use a do while statement however, the one I've used only brings back one record. Here is the code I am using:

while ($row = mysql_fetch_array($sql_result)){
$product_id = $row["product_id"];
$type = $row["type"];
$genre = $row["genre"];
$title = $row["title"];
$picture = $row["picture"];
$description = $row["description"];
$audio = $row["audio"];
$availability = $row["availability"];
$price = $row["price"];
}

[Anon]

You need to print inside the while loop:

while ($row = mysql_fetch_array($sql_result)){
$product_id = $row["product_id"];
$type = $row["type"];
$genre = $row["genre"];
$title = $row["title"];
$picture = $row["picture"];
$description = $row["description"];
$audio = $row["audio"];
$availability = $row["availability"];
$price = $row["price"];

print "whatever you want $product_id $type, etc";
}

Diego

[Anon]

Again another query with this, yes this works and it prints straight away but what I want to call $genre later on down the page.

Here it only prints out the first item, how do I go about doing this?