Insert Problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
BigAbe
Forum Commoner
Posts: 66
Joined: Fri Mar 31, 2006 7:41 pm

Insert Problem

Post by BigAbe »

Aloha sweet board!

It's been a really long day, and I'm just looking for a little board debugging love right now...

Code: Select all

INSERT INTO users (userUID, userSCTID, userFirstName, userDateCreated, userCreatedIP, userLastLogin) VALUES ('jnovotny', '11223344',Jared', NOW(), '198.199.136.65', NOW())
gives me
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 '', NOW(), '198.199.136.65', NOW())' at line 1
My brain is hurting right now, and I can't debug anything in this state. So I'm gonna go for a walk, but in the meantime, if anyone can offer help, I'd be greatful!

Mahalo!

-- Abe --
paladaxar
Forum Commoner
Posts: 85
Joined: Fri Jun 18, 2004 11:50 pm

Post by paladaxar »

You're missing a single quote before the word Jared.
BigAbe
Forum Commoner
Posts: 66
Joined: Fri Mar 31, 2006 7:41 pm

Post by BigAbe »

paladaxar wrote:You're missing a single quote before the word Jared.
Thanks a million. I feel so bad for being so lazy, but you've made my day! (Ok, not my day, but hour - how's that sound?)

Mahalo nui!

-- Abe --
Post Reply