Warning: Supplied argument is not a valid MySQL result resource in

[Gordanzy]

Ok. Im practically tearing my hair out now!! Just kidding. But im nearly there !!

I get the message in the subject line with this code. Problem seems to lie at the line starting with $numresult or $result.

--- display.php ----
?>
@ $db = mysql_pconnect("localhost", "user", "password");

if (!$db)
{
echo "Error: Could not connect database";
exit;
}

mysql_select_db("database1");
$query = "select * from contacts";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo "<p>Number of books found: ".$num_results."</p>";

for ($i=0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "<p><strong>".($i+1).". Name: ";
echo stripslashes($row["name"]);
echo "</strong><br>Tel Nol: ";
echo stripslashes($row["telno"]);
echo "</p>";
}
?>
</html>

--- addname.php ---

This just adds a name and tel no to the db.

This appears to complete properly so there is eomething in the database. I know this by the mysql_affected_rows() returns a value.

It looks like the $result variable isnt getting a value but my code looks good and I have cross referenced it with a book. HELP !!

[mrmufin]

Try it like this:

// Build the query:
$query = "SELECT * FROM contact";

// Try for a result:
$result = mysql_query($query);

// Make sure you actually get a result:
if($result) {
// loop through the result set, where $row
// represents each record. We'll skip all the
// formatting shtuff fer now:
while($row = mysql_fetch_array($row)) {
echo $row["name"] . "<br />";
echo $row["phone"] . "<br />";
// etc....
}
}

Lemme know if this works...

[Gordanzy]

Hi Mr Muffin

. Thanks for the extra code but still no luck. Same result. If I was to take out the $num_results line then the page would just return nothing.

If the statement is left in - it supplies me with the Warning arguement that I stated in the original subject line.

Any other ideas ?

[dannys]

try adding in the following just after the mysql_query() line

printf('Last MySQL Error was: (%s) - "%s"',mysql_errorno(),mysql_error());

That should print the last (if any) error reported by Mysql - which will tell you if there's anything up with the query or connection.

[nationwide]

Sorry to butt in with my limited knowledge but the very start of your code is ?>, shouldnt it start with <?

Hey, if I'm talking out of my hat, slap my wrists

[dannys]

Originally posted by nationwide
Sorry to butt in with my limited knowledge but the very start of your code is ?>, shouldnt it start with <?

Hey, if I'm talking out of my hat, slap my wrists

Good Point, most likely a typo though because if it was like that in the .php file, the browser would output all of the PHP code, which doesn't seem to be happening here.

[siwis]

firstly I'd suggest you ditch the pconnect routine in favor of a simple mysql_connect.

Here's my take on it. The query looks fine and yet it is failing. So you need to know why it is failing. obviously, one f the elements of your query is innaccurate or incomplete.

Personally, I prefer to use CAPS ON for sql commands (SELECT WHERE etc) and make all field names lowercase as it makes the sql's easier to reead (but that is an aside.

try my modified version (I've ommited one of the checks, but you can always put it back in later.

$dbhost = 'localhost';
$dbusername = 'user';
$dbpw = 'password';
$dbname = 'database1';

$db = mysql_connect($dbhost , $dbusername , $dbpw);
@mysql_select_db("$dbname",$db);

$query = "SELECT * FROM contacts";
$result = mysql_query("$query", $db);
$num_results = mysql_num_rows($result);
echo "<p>Number of books found: ".$num_results."</p>";

Before you proceed, make absolutely certain that your CaPS aRe CoRrecT for table names, paswords etc.

[undertow]

Good call, but as dannys said, it's probably a typo.

An even better way is to disable short tags and only use <?php for openings. I'm not sure if this is actually a problem, but the heading for XML files usually looks like <?xml version="1.0"?> which may or may not confuse the PHP parser when trying to output XML pages (which I'm sure buttloads of you are doing already :rolleyes: ).

Originally posted by nationwide
Sorry to butt in with my limited knowledge but the very start of your code is ?>, shouldnt it start with <?

Hey, if I'm talking out of my hat, slap my wrists