MySQL Forums
Forum List  »  PHP

multi-table query error...
Posted by: Fabio Vaona
Date: November 17, 2005 05:53AM

Hi All!
This is a strange problem... I don't know how to solve it.
I usually write PHP/mysql code on my localhost machine then upload on the server the scripts.

This run on my local machine, but give me an error on the server...

Could someone check it?

$nnn =
mysql_num_rows(
mysql_query(
"select qid from db_qw_db
where active='1'
and internalstatus='1'
and status='0'
and EXISTS (
select qsaid from db_qw_site_addr
where db_qw_site_addr.address like '%".$province_ricerca[$prov]."%'
and db_qw_site_addr.qid = db_qw_db.qid )
"));

This run with no problem on my localhost machine, but, on the server return the classic "Warning: mysql_num_rows(): supplied argument is not a valid MySQL...."

please, help!
regards
Fabio

Options: ReplyQuote


Subject
Written By
Posted
multi-table query error...
November 17, 2005 05:53AM
November 17, 2005 08:20AM
November 17, 2005 10:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.