And which database are you using?? (hint - mysql_select_db() might be a good
idea ...)
> -Original Message-
> From: Phil Powell [mailto:[EMAIL PROTECTED]]
> > Anyone know why this is happening? I have mySQL on Win2000
> Server with IIS
> > and PHP:
>>
--
PHP General Mailing List (http:/
Are you actually checking that the query result is valid?
$conn = mysql_connect('localhost', "xxx", "yyy") or die('Could not connect
to db');
$result = mysql_query('select * from blah', $conn);
if ($result)
{
echo "Number of rows: " . mysql_num_rows($result);
if (mysql_num_rows($result) > 0)
You query is incorrect. Try doing the same query from the MySQL clent.
|-> -Original Message-
|-> From: Phil Powell [mailto:[EMAIL PROTECTED]]
|-> Sent: Thursday, January 09, 2003 7:46 PM
|-> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
|-> Subject: [PHP] mysql_num_rows() error
|->
|->
|->
Well, those error normaly appear when you've got something wrong in your sql
statement. Make sure there is some information stored in your database,
empty tables are sometimes troublesome.
What do you use $link for?
$sql = "select USUARIO from docente where USUARIO = '$usuario'";
$result =
Omar Campos wrote:
> I get the next warning:
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
> resource in /home/olimpiad/public_html/base/alta1.php on line 34
This usually means that the SQL query failed. You can check the value
returned by mysql_query to see if this
Hi Nick,
> I am new to php and that the folowing error:
> Warning: mysql_num_rows(): supplied argument
> is not a valid MySQL result resource in
> /home/tbonestu/public_html/smallimages.php
>
> i dont know what i am doing wrong here is the code:
>
> @ $db = mysql_pconnect(connect info);
Alo
>> I am new to php and that the folowing error: Warning:
mysql_num_rows():
>> supplied argument is not a valid MySQL result resource in
>> /home/tbonestu/public_html/smallimages.php
>>
>> i dont know what i am doing wrong here is the code:
>>
>> @ $db = mysql_pconnect(connect info);
>>
>> m
> I am new to php and that the folowing error: Warning:
mysql_num_rows():
> supplied argument is not a valid MySQL result resource in
> /home/tbonestu/public_html/smallimages.php
>
> i dont know what i am doing wrong here is the code:
>
> @ $db = mysql_pconnect(connect info);
>
> mysql_select
Hi,
Sunday, September 23, 2001, 3:25:02 PM, you wrote:
NV> I am new to php and that the folowing error: Warning: mysql_num_rows():
NV> supplied argument is not a valid MySQL result resource in
NV> /home/tbonestu/public_html/smallimages.php
NV> i dont know what i am doing wrong here is the code:
9 matches
Mail list logo