$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)) { foreach ($line["id"] as $col_value) { print ""; } foreach ($line["title"] as $col_value) { print "$col_value"; } foreach ($line["basis_ingr"] as $col_value) { print "( $col_value )"; }