PDA

View Full Version : Any php/mysql people around that can help me?


Wicked Anime Kid
March 27th, 2004, 12:41 AM
Ok i installed a mod on my website but it won't work cause of an SQL querry error:(

Here's the error:

General Error

Error updating users/employed table!

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'as t1, phpbb_users as t2 SET t1.last_paid = '1080376827', t2.user_poi' at line 2

UPDATE phpbb_employed as t1, phpbb_users as t2 SET t1.last_paid = '1080376827', t2.user_points = t2.user_points + t1.job_pay WHERE (1080376827 - t1.last_paid) > t1.job_length AND t1.user_id = '2' AND t2.user_id = t1.user_id

Line : 148
File : /data/members/paid/d/-/d-nation.org/htdocs/www/jobs.php

Can anyone help me out with this?