Strats Posted July 12, 2009 Posted July 12, 2009 I have a small error on my streets, jail time. When someone should go to jail they do not. I get this : QUERY ERROR: Unknown column 'jailtime' in 'field list' Query was UPDATE `users` SET `jailtime` = `jail_time` + '', `jailreason` = 'Pulled up by a Policeman' WHERE `userid` = '1' I know this means there is no jailtime in my database. But I am confused at to where it should be. I never deleted anything that I know of. Quote
Miniman Posted July 12, 2009 Posted July 12, 2009 Re: Streets Error $db->query("UPDATE `users` SET `jail_time` = `jail_time` + timer here. `jailreason` = 'Pulled up by a Policeman' WHERE `userid` = '1'"); You had: jailtime = jail_time + blah :) Quote
Strats Posted July 12, 2009 Author Posted July 12, 2009 Re: Streets Error Yea I could see on the user database jail lol I was unsure thanks Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.