Same code different pages, works in one but not the other

[panosa73]

Hi guys,
I have the same line of code, one in /public_html/profile/index.php and one in /public_html/admin/index.php. It checks the session and updates the db with the new time.

  $sqlRegUser =   "UPDATE `tbl_user` SET `fld_session` =  '". time() ."' WHERE `user_id` = '". $_SESSION['ses_user']['user_id'] ."' LIMIT 1 ;";

Everything is the same but for some reason it doesn't work in the admin dir. I set error traps and got no errors. The update seems to be successful but it's not.

Any ideas?
Thanks,
Panos.

[woodeye]

Have you tried displaying the result of $sqlRegUser ? Sometimes the query doesn't come together the way I'd expect it to. I'm just wondering if there's a difference in the user_id between the two pages.

[panosa73]

Yes I did. I did an echo, took the output string, insert it in phpMyAdmin's query and it executed perfectly. That's why it doesn't make sense to me.
Thanks.

[bradgrafelman]

How are you executing queries? Have you checked the appropriate error function (e.g. [man]mysql_error/man if using the mysql library)?

Does it never work, or only fail sometimes? Are you logging PHP errors and have error_reporting set to E_ALL?