curious mysql problem

wxdqz

New Member
Hi,

I'm trying to run a query on a database, selecting data from 3 tables.

When I start mysql manually and type the query, it works fine and says:

"mysql> select redirect.redirectnr, redirect.pakketid, redirect.betalingswijze, domein.domein, klant.klantnr, klant.debiteurnummer from redirect, domein, klant where domein.domeinnr = redirect.domeinnr and klant.klantnr = domein.klantnr and redirect.naarbestmate = 0 and domein.status = '009';
Empty set (0.00 sec)"

No prob. exactly what I expected.

But when I execute it in php, it says:

<?php

$res1 = mysql_query("select redirect.redirectnr, redirect.pakketid, redirect.betalingswijze, domein.domein, klant.klantnr, klant.debiteurnummer from redirect, domein, klant where domein.domeinnr = redirect.domeinnr and klant.klantnr = domein.klantnr and redirect.naarbestmate = 0 and domein.status = '009'");



if(!$res1){
echo "no result from redirects: ".mysql_error();
exit();
}

?>


And my browser says:

no result from redirects: Unknown table 'redirect' in where clause


Is this a bug in php? Am I doing something wrong?

I've never expierenced this problem before, and everything seems fine.
 
Back
Top