Could someone please tell me what I did wrong?

[tvollmer]

Here is a script I have started working on.
My web host uses PHP 4.2.2 and MySql 3.23.51

<?

// Database Variables

$server = "localhost";
$database = "tsdbase";
$username = "frank";
$password = "chicken";
$table = "names";

// Connect to Database

$db = mysql_connect($server,$username,$password,$database);

$res = mysql_query("SELECT * FROM $table", $db);

$data = mysql_fetch_array($res);

?>

When I run the script, I get the following error :

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource"

What am I doing wrong?
All I want to do is to open a database and display a table to the browser.

Todd

[Spookster]

<?

// Database Variables

$server = "localhost";
$database = "tsdbase";
$username = "frank";
$password = "chicken";
$table = "names";

// Connect to Database

$dbcnx = @mysql_connect($server,$username,$password) or die ("Database Connection Error");

$dbhandle = mysql_select_db($database, $dbcnx);

$res = mysql_query("SELECT * FROM '$table'", $dbhandle);

$data = mysql_fetch_array($res);

?>

[tvollmer]

That made it work!

Thank you!

Todd

[Spookster]

You're welcome. :cool: