agan2 ane mau nanya nih...
php ane error syntaxnya... ini nih gan
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 'call from hm2_history where '2010-6-1' + interval 0 day < date + interval 0 hour' at line 1
nah di .php nya gini gan...
$q = '' . 'select count(*) as call from hm2_history where ' . $datewhere . ' . $typewhere . ' . $ecwhere . ' and user_id = ' . $id;
$datewhere = '\'' . $frm['year_from'] . '-' . $frm['month_from'] . '-' . $frm['day_from'] . '\' + interval 0 day < date + interval ' . $settings['time_dif'] . ' hour and ' . '\'' . $frm['year_to'] . '-' . $frm['month_to'] . '-' . $frm['day_to'] . '\' + interval 1 day > date + interval ' . $settings['time_dif'] . ' hour ';
nah... salahnya dimana gan??? tolong bantuin ane ya agan2 master..
11th November 2011
[ASK] Kode PHP ke MySQL saya error...
