mysql error

Supplied argument is not a valid MySQL result resource

please help if possible

kind regards
sie

Hi Sie,

There may be a problem within your query. Post a snippet of the code/query so that we can troubleshoot further...

-Abi

or more specifically, at what point do you experience this error message?

here is the error

Warning: Supplied argument is not a valid MySQL result resource in C:\apache\htdocs\mywork\displaydb.php on line 34

here is my code

<head><title>Retrieving data from a database</title></head>
<body>

<?php
$Host = "localhost";
$User = "";
$Password = "";
$DBName = "newagejam";
$TableName = "tblGigDates";

$Link = mysql_connect ($Host, $User, $password);

$Query = "SELECT * from $TableName";
$Result = mysql_db_query ($DBName,
$Query, $Link);

//create a table.
print ("<table border=1 width=\"75%\"
cellspacing=2 cellpadding=2
align=center>\n");

print ("<tr align=center valign=top>\n");

print ("<td align=center valign=top>Name</td>\n");

print ("<td align=center valign=top>Email Address</td>\n");

print ("<td align=center valign=top>Comments</td>\n");

print ("</tr>\n");

//fetch the results from the database.

while ($Row = mysql_fetch_array ($Result)) {

print ("<tr align=center valign=top>\n");
print ("<td align=center valign=top>$Row[theDate]
$Row[location]</td>\n");

print ("<td align=center valign=top>
$Row[venue]</td>\n");

print ("<td align=center valign=top>$Row[postcode]</td>\n");
print ("</tr>\n");
}

mysql_close ($Link);
print ("</table>\n");
?>
</body>

thank you for your help
kind regards
sie

Make sure your database, table and columns names match the database exactly.

If you want to see your error
whrap your while block with this:

if ($result) {

.... your while block {


}

} else {
echo "<br>" . mysql_errno().": ".mysql_error()."<br>";
}