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

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