...
$query = "SELECT productid, name FROM product ORDER BY name";
$result = mysql_query($query);
for ($count=0; $count <= mysql_numrows($result); $count++)
{
$productid = mysql_result($result, $count, "productid");
$name = mysql_result($result, $count, "name");
echo "Product: $name ($productid)
}
...
?>