Miscellany
public php v1 · immutable $result = mysql_query("SELECT DISTINCT category FROM shopProduct", $connection); while ($cid = mysql_fetch_array($result)) { $result = mysql_query("SELECT name FROM shopCategory WHERE cid = '".$cid['category']."'"); $row = mysql_fetch_assoc($result); $category = $row['name']; echo '<h2>',$category, '</h2>'; }