2 replies to this topic

[mycqual]

I am having a problem running a query in in php.  When I execute the
query directly against the mysql server it works perfectly but when
executed in PHP it returns no results.
The query is:
SELECT * FROM db1 JOIN db2.field ON db1.table1.custid =
db2.table1.custid  WHERE db1.table1.field2 != "$var";

PHP code:
$query = "SELECT * FROM db1 JOIN db2.field ON db1.table1.custid =
db2.table1.custid  WHERE db1.table1.field2 != '$var' ";
$result = mysql_db_query ("db1", $query);

I don't understand why this query won't return the same result set
when executed in php as when executed directly on the mysql server.

[Temple]

It might be because mysql_db_query is deprecated as of PHP 4.0.6.

Try using mysql_query instead.

[lampchaitanya]

use mysql_query()