supplied argument is not a valid MySQL result resource

[Burton Figg]

Before I get in trouble, I have searched extensively for this one, in the
PHP Docs, online etc.

I have a simple page:

<?php

$un="jim";
$pw="jim";
$db="localhost" ;

$link = mysql_connect($ db,$un,$pw) or die("Could not connect: " .
mysql_error());

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;
$num= mysql_numrows($ op);

?>

When I run the page I keep getting this error:

Warning: mysql_numrows() : supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache
Group\Apache2\h tdocs\eib\php\i temadd2.php on line 34

I can't work out why?

The code looks fine to me.

Thanks

Jim
http://jimpix.co.uk

[Geoff Berrow]

I noticed that Message-ID: <br*********@ti tan.btinternet. com> from
Burton Figg contained the following:

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";

What have you tried?
Does this query work in phpMyadmin?
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Pedro Graca]

Burton Figg wrote:

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;
Try
$op = mysql_query($sq l2) or die(mysql_error () . ' in ' . $sql2);

$num= mysql_numrows($ op);
Shouldn't this be
$num = mysql_num_rows( $op);
## _____________^_ _________

<quote src="http://pt2.php.net/manual/en/function.mysql-num-rows.php">
.. For downward compatibility mysql_numrows() can also be used.
This is deprecated however.
</quote>

When I run the page I keep getting this error:

Warning: mysql_numrows() : supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache
Group\Apache2\h tdocs\eib\php\i temadd2.php on line 34

I can't work out why?

The code looks fine to me.

It looks fine to me too :)
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[CJ Llewellyn]

On Sat, 13 Dec 2003 21:42:29 +0000, Burton Figg wrote:

Before I get in trouble, I have searched extensively for this one, in the
PHP Docs, online etc.

I have a simple page:

<?php

$un="jim";
$pw="jim";
$db="localhost" ;

$link = mysql_connect($ db,$un,$pw) or die("Could not connect: " .
mysql_error());

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;
$num= mysql_numrows($ op);

?>

When I run the page I keep getting this error:

Warning: mysql_numrows() : supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache
Group\Apache2\h tdocs\eib\php\i temadd2.php on line 34

I can't work out why?

mysql_select_db ;)

[Pedro Graca]

CJ Llewellyn wrote:

On Sat, 13 Dec 2003 21:42:29 +0000, Burton Figg wrote:

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;

mysql_select_db ;)

No need for that.

select <fields> from database.table ...

You can specify the database in the query string; you can even (luckily)
mix different databases in the same query:

select u.name, x.quantity from db1.tb1 u, db2.tb2 x where u.id=x.id
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Andy Hassall]

On Sat, 13 Dec 2003 21:42:29 +0000 (UTC), "Burton Figg" <so*****@somewh ere.com>
wrote:

Before I get in trouble, I have searched extensively for this one, in the
PHP Docs, online etc.
Really? The first few pages on Google web and groups searches come up with the
answer.
$link = mysql_connect($ db,$un,$pw) or die("Could not connect: " .
mysql_error()) ;
Here you correctly check for a possible error and stop the script going any
further.
$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;
Here you haven't bothered...
$num= mysql_numrows($ op);
... resulting in you passing 'false' to mysql_numrows.
When I run the page I keep getting this error:
Warning, actually, you skipped passed the point at which you got an error
(mysql_query) because you didn't check for it
Warning: mysql_numrows() : supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache
Group\Apache2\ htdocs\eib\php\ itemadd2.php on line 34

--
Andy Hassall (an**@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[CJ Llewellyn]

On Sat, 13 Dec 2003 22:18:56 +0000, Pedro Graca wrote:

CJ Llewellyn wrote:

On Sat, 13 Dec 2003 21:42:29 +0000, Burton Figg wrote:

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;

mysql_select_db ;)

No need for that.

Call me fussy, but I like to know I've got access to the database before I
try to use it :)

[Pedro Graca]

CJ Llewellyn wrote:

On Sat, 13 Dec 2003 22:18:56 +0000, Pedro Graca wrote:

CJ Llewellyn wrote:

mysql_select_db ;)

No need for that.

Call me fussy, but I like to know I've got access to the database before I
try to use it :)

fussy!

call me fussy too :)

mysql_select_db () or die();
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Jedi121]

"Burton Figg" a écrit le 13/12/2003 :

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;
$num= mysql_numrows($ op);

Are you sure a table name containing a dot is OK? I won't risk it
myself. Cause 'eib.book' can be translated by MySQL as field book form
table eib...

What does this select returns directly in phpmyadmin or equivalent ?

--
Have you read the manual?
http://www.php.net/manual/en/

[Walter Mitty]

Jedi121 <je*********@fr ee.fr.Removethi s> brightened my day with his
incisive wit when in news:mesnews.70 1d7d3c.cb834ecb .367.2689
@free.fr.Remove this he conjectured that:

"Burton Figg" a écrit le 13/12/2003 :

$sql2 = "SELECT * FROM eib.book ORDER BY bookid";
$op = mysql_query($sq l2) ;
$num= mysql_numrows($ op);

Are you sure a table name containing a dot is OK? I won't risk it
myself. Cause 'eib.book' can be translated by MySQL as field book form
table eib...

eh? The table name doesn't have a dot in it. He's merely using fully
qualified column names in form "tablename<dot> columnName" isn't he?