Darnel

Thanks for the advice, ill know in the future

Thanks Jessica, I didn't know about mysql restricted keywords. Its working now.

Yes it is, but I changed count to show and removed quotes as suggested but nothing happened.

Thanks, Iv'e changed the name and removed quotes. But still getting error. $sql3= " UPDATE ".PROJECT_TO ." SET to_user =" ."CONCAT_WS(',','".$post['name']."', to_user)," ." show = show +1 " ." WHERE project_to_id = ".$project_id." "; This line causes the error (...syntax to use near 'show = show +1 WHERE project_to_id = 2' at line 1)) ." show = show +1 " What am I missing?

Database error: Invalid SQL: UPDATE project_to_user SET to_user =CONCAT_WS(',','demo1', to_user), count = 'count +1' WHERE project_to_id = '1 ' MySQL Error: 1064 (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 'count = 'count +1' WHERE project_to_id = '1 '' at line 1) Session halted.

Hi, I've been trying to find the syntax error with no luck. Keep getting error 1064. I'm not used to this format so not sure what goes where. Its driving me crazy :'( can any one point me in the right direction? $sql3= " UPDATE ".PROJECT_TO ." SET to_user =" ."CONCAT_WS(',','".$post['name']."', to_user)," ." count = 'count +1' " ." WHERE project_to_id = '".$project_id." '"; Thanks :-\

Hi, I have this code but would like to modify it to be able to insert a new data in the next field if the current one is not empty. global $db; $sql= " UPDATE ".Project ." SET " ." name_1 = '".$user_id."' " ." WHERE project_id = '".$project_id." '"; $db->query($sql); So for example if field "name_1" is occupied I would like to add the same $user_id to "name_2". I've been trying to use CASE WHEN name_1 = '0' but can't seem to get the syntax right and keep getting Mysql errors. Any help appreciated, thanks

Hi, really need some advice on Paypal API. I'm not sure which API to use. All I need is for Paypal to take payments from a users owed money wallet (a field in a Mysql table) preferably every month or so. Also the user would need to sign a agreement for this? Any help is appreciated. Thanks

Hi, I have a page that uses jquery to load content (different content appears after clicking link). It was working fine but now after clicking the link it loads for about 30-40 seconds, but still loads every time. I've been using Firebug on Firefox but it shows (200 OK 32.95s) and no errors. Has anyone ever had something like this happen? any ideas what it might be or how I can test it? All other pages load normal its just this one. Thanks