Merhaba,
bir sql sorgusu oluşturduk bu oluşturdugumuz sql sorgusu phpmyadmin de sorunsuz bir şekilde çalışıyor ama ezsql ile denedigimizde hata veriyor sizce neden olabilr?
hata mesajı:
bir sql sorgusu oluşturduk bu oluşturdugumuz sql sorgusu phpmyadmin de sorunsuz bir şekilde çalışıyor ama ezsql ile denedigimizde hata veriyor sizce neden olabilr?
PHP:
echo $sorgu="select tbl.cid, tbl.ad, tbl.tutar, tbl.tahsilat, (tbl.tutar - tbl.tahsilat) as bakiye FROM (
SELECT tbl_toplam.cariid AS cid, tbl_cari.ad as ad, sum(tbl_toplam.stutar) AS tutar, sum(tbl_toplam.ttutar) AS tahsilat, (sum(tbl_toplam.stutar)-sum(tbl_toplam.ttutar)) as bakiye
FROM (
SELECT tbl_tahsilat.cariid AS cariid, tbl_tahsilat.tutar AS ttutar, 0 as stutar
FROM tbl_tahsilat
UNION
SELECT tbl_sozlesme.cariid AS cariid, 0 as ttutar , tbl_sozlesme.sozlesmetutari AS stutar
FROM tbl_sozlesme
)tbl_toplam LEFT OUTER JOIN tbl_cari ON tbl_toplam.cariid=tbl_cari.id GROUP BY tbl_toplam.cariid) tbl $kriter $kritersiralama $artanazalan";
$ezr->query_mysql($sorgu);
$ezr->display();hata mesajı:
PHP:
select tbl.cid, tbl.ad, tbl.tutar, tbl.tahsilat, (tbl.tutar - tbl.tahsilat) as bakiye FROM ( SELECT tbl_toplam.cariid AS cid, tbl_cari.ad as ad, sum(tbl_toplam.stutar) AS tutar, sum(tbl_toplam.ttutar) AS tahsilat, (sum(tbl_toplam.stutar)-sum(tbl_toplam.ttutar)) as bakiye FROM ( SELECT tbl_tahsilat.cariid AS cariid, tbl_tahsilat.tutar AS ttutar, (0) as stutar FROM tbl_tahsilat UNION SELECT tbl_sozlesme.cariid AS cariid, (0) as ttutar , tbl_sozlesme.sozlesmetutari AS stutar FROM tbl_sozlesme )tbl_toplam LEFT OUTER JOIN tbl_cari ON tbl_toplam.cariid=tbl_cari.id GROUP BY tbl_toplam.cariid) tbl
Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) FROM tbl_sozlesme)tbl_toplam LEFT OUTER JOIN tbl_cari ON tbl_top' at line 1 in /home/site/public_html/deha/ezsql/mysql/ez_sql_mysql.php on line 204
Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SELECT tbl_tahsilat.cariid AS cariid, tbl_tahsilat.tutar AS ttutar, (0) as stut' at line 1 in /home/ereklam/public_html/deha/ezsql/mysql/ez_sql_mysql.php on line 204