marvelous_mogli

It's an SQL-2000 complaint query :-) I suspect there should be some issue with the MySQL Client libraries.

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 '' at line 1

The same query works in SQLYog.

$SQL = "update order_master set order_status = '2', order_state_date_change = now() where order_id = 18"; $rs_update = mysql_query($SQL);

Can someone help?

Hi, There are a few UPDATE statements which are not executing or executing erronously with mysql_query(). When tried using SQLYog or other client applications the queries works fine. Environment 1: MySQL: 4.1.9-max PHP: 4.3.10 Client API version: 3.23.49 Environment 2: MySQL: 4.1.21 PHP: 4.4.4 Client API version: 4.1.21 Query 1: update order_master set order_status = '2', order_state_date_change = now() where order_id = 18 Error: 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 '' at line 1 Query 2: Trying to increment a field by 1 but it increments by 3

register_globals = Off It's off. Also, there are no variables of the name mypage

Hi, I've a peice of PHP script to track the movement between pages. On x.php I'm creating a session variable named 'mypage' and assigning it the $_SERVER['SCRIPT_URI'] This peice of code is present in almost every page except signin.php The value remains fine on all pages. But, when I access signin.php the session variable's value is getting changed to spacer.gif What could be causing this? Is there a known problem? BTW, Rewrite engine is on. There are url re-writing rules active. But none of them have anything to do with spacer.gif Any help?

Hello All, I'm executing a project that needs integration with Windows ActiveDirectory Services. The client has around 5000 employees. Is it wise to go with PHP do develop a collaborative k-base for this company? Or is it going to be a kill? Any ideas, experiences? Please help.