$query = "SELECT id,title, basis_ingr FROM cocktail"; $result = mysql_query($query) or die("Error"); print "

\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print ""; print " $line["title"]"; print "( $line["basis_ingr"] )"; } mysql_free_result($result); mysql_close($link); ?>