On Saturday 02 August 2003 11:48, Lee Templeton wrote:
> The first row retrieved from the results list works and returns the row
> with Resource id #3 prefixed to the prinouts. After the first row all
> futher retrievals fail.
The variable $results is stressed by being forced to do two different
I'm trying to do a full text search to a MySQL database and have a problem
being able to read the results:
here is my code:
---
$query = "SELECT name,title,branch,section_one,section_two,MATCH
(section_header,section_one,section_two,section_footer) AGAINST
('".$searchCriter
://www.phparch.com/
> -Original Message-
> From: Addison Ellis [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 20, 2003 2:30 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] not a valid MySQL result resource
>
> hello and thank you for your time.
> can you
hello and thank you for your time.
can you tell me why the below: i think this whole section is
line 22 because whatever i change in these first four lines still has
the error message point to line 22.
$cobj = mysql_db_query($dbname,"select * from category where
id=$category"); //line 22
$cro
Message---
From: Wilmar Perez
Date: Friday, September 06, 2002 09:57:48
To: php-db mailing list
Subject: [PHP-DB] not a valid MySQL result
Hello guys
This is my first posting to the list, even though I've had some experience
with C++, these are my first steps with php and mysql.
lumn to be called or leave
the "as somenewcolname" part off if you don't care what the column name is.
This should help.
Jim
---Original Message---
From: Wilmar Perez
Date: Friday, September 06, 2002 12:16:28
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] not a vali
Hi guys
Thanks for your help. Peter was right I had an error in the sentence, I
worked it out but still the same error came up. The mysql_error() function
doesn't return any thing.
Any idea?
Thanks a lot.
>Hi
>Couple of points, you probably have an SQL error,
>I use
>echo $query;
>echo
erez [mailto:[EMAIL PROTECTED]]
Sent: 06 September 2002 16:51
To: php-db mailing list
Subject: [PHP-DB] not a valid MySQL result
Hello guys
This is my first posting to the list, even though I've had some experience
with C++, these are my first steps with php and mysql.
Well, the thing is tha
Hello,
It's always good practice to put some error detection in your code, i.e.
$result = mysql_query($query)
or die(mysql_error());
I think your problem is the mysql does not like your query, but you are not
catching it until PHP tries to figure out the number of rows returned by the
query.
Hello guys
This is my first posting to the list, even though I've had some experience
with C++, these are my first steps with php and mysql.
Well, the thing is that I'm getting the following message:
Warning: Supplied argument is not a valid MySQL result resource
in /var/www/bva/new/main/cole
e: [PHP-DB] Not a valid MySQL result resource
> //.../... first part of the code is to connect to the right DB on a MySQL
> server. It works fine
> //This code to show the query. It runs well under MySQL and gives 1 result
:
> $query="SELECT Login, Password FROM `user` WHER
I'd check for mysql_num_rows( $result_query) > 0 as well.
It's entirely possible the user mis-typed the login or password values.
Miles
At 07:26 PM 11/8/01 -0600, Paul DuBois wrote:
>At 2:04 AM +0100 11/9/01, MPropre wrote:
>>>//.../... first part of the code is to connect to the right DB on a My
> //.../... first part of the code is to connect to the right DB on a MySQL
> server. It works fine
> //This code to show the query. It runs well under MySQL and gives 1 result :
> $query="SELECT Login, Password FROM `user` WHERE user.login=''$login'' and
> user.password=''$password''";
> //This
At 2:04 AM +0100 11/9/01, MPropre wrote:
>//.../... first part of the code is to connect to the right DB on a MySQL
>server. It works fine
>
>
>//This code to show the query. It runs well under MySQL and gives 1 result :
> $query="SELECT Login, Password FROM `user` WHERE user.login=''$login'' and
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
15 matches
Mail list logo
