Kamis, 25 Juli 2013

PHP Indonesia - Facebook: master-master, minta bantuannya y.. ane pny php s...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
master-master, minta bantuannya y.. ane pny php s...
Jul 26th 2013, 03:43, by 黄天文

黄天文 3:43am Jul 26
master-master, minta bantuannya y..

ane pny php seperti dibawah:

$tmpQuery = "SELECT IFNULL(`item`.`CurrentBalance`,0) - IFNULL((SELECT SUM(`oltransactiondetail`.`Quantity`) FROM `oltransactiondetail` INNER JOIN `oltransaction` ON `oltransactiondetail`.`OLTransaction` = `oltransaction`.`Id` WHERE `oltransactiondetail`.`Item` = `item`.`Id` AND `oltransaction`.`Status` = 3),0) AS CurrentBalance FROM `item` WHERE `item`.`Id` = '".$current['Item']."'";
$tmpExecute = mysql_query($tmpQuery);
$scalar = mysql_fetch_array($tmpExecute);

ketika $tmpQuery di echo keluar dan dijalankan langsung ke MySQL hasilnya adalah -4..
tetapi ketika lewat mysql_query sama mysql_fetch_array di php, hasilnya jadi 20..
apakah ada yang pernah ketemu seperti gini? mohon sarannya..

sbg informasi :
- Engine : InnoDB
- sebelum execute query ada BEGIN (memakai Mysql Transaction)

黄天文 3:45am Jul 26
"tetapi ketika lewat mysql_query sama mysql_fetch_array di php, hasilnya jadi 20.."

ini di dapatkan dgn Echo var_dump($scalar);

黄天文 3:56am Jul 26
mohon bantuan sebesar-besarnya..
sudah 4 hari cari kasus ini.. :(

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar