php/mysql connection??

del753

Hi, this is my code just to see the connection working, which it isnt!, i was just trying to output my table show to a page to test it out, any ideas whats wrong? thanks

<?php

$db = mysql_connect("mysqlxxx", "xxx", "xxx")
or die("Couldn't connect to the database.");
mysql_select_db("xxx")
or die("Couldn't select the database");

echo"<p>Tables in the DB</p>";

$result = mysql_query(""SELECT name FROM show", $db);

while($row = mysql_fetch_row($result))
{
echo "<OPTION>$row[0]</OPTION>";
}
?>

devinemke

[man]mysql_error[/man]

laserlight

mysql_error() might give a more comprehensive report of the error, when debugging.
""SELECT name FROM show" should result in a parse error in PHP.

<?php
$db = mysql_connect("mysqlxxx", "xxx", "xxx")
	OR die(mysql_error());
mysql_select_db("xxx")
	OR die(mysql_error());

$result = mysql_query("SELECT `name` FROM `show`")
	OR die(mysql_error());

echo mysql_num_rows($result) . " rows were returned:<br />\n";
while ($row = mysql_fetch_assoc($result))
{
	echo $row['name'] . "<br />\n";
}
?>