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.
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.