phpmyadmin

[creatorz]

wondering if any of you guys could help me out.

I'm having problems with my sql database. I made the data base and then made the table with three fields and it was created all was good but when I inputed data from my website(I set up a form using "formloom" and linked it too the database/table) I got an 1064 sql error message. I realized that I need to direct those three fields too the ones in the table and tried writing some insert code" insert into dbname.tablename('name':'email':'date')

but it didnt like that,hope you guys can help

[Ben Stones]

Could you paste the SQL error message(s) you get?

[creatorz]

here is the error message

Alert
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 'and email SET Please enter full name = 'justin', Please enter your E-mail Addres' at line 1
When executing:
INSERT INTO name and email SET Please enter full name = 'justin', Please enter your E-mail Address = 'brokenleg513@aim.com', please enter a date = '08-04-2009', = '69.114.5.120', = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.12) Gecko/2009070611 Firefox/3.0.12', = NOW()

[DavidAllen]

assuming your table is called USERS and the fields are name, email and date. Then the sql would be:

INSERT INTO USERS set name="Justin", email="Broke...", date=NOW()

hope this helps

[creatorz]

I altered the code you gave me but it gave me this error message



INSERT INTO 'name and mail' set name="Justin", email="Brokenleg513@aim.com", date=NOW()




SQL query: Documentation

SELECT *
FROM `name and email`
WHERE 1
INSERT INTO 'name and mail'
SET name = "Justin",
email = "Brokenleg513@aim.com",
date = NOW( ) LIMIT 0 ,
30

MySQL said: Documentation
#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 'INSERT INTO 'name and mail' set name="Justin", email="Brokenleg513@aim.com", dat' at line 3




I'm given the field names on the side and thats confusing me I think i'm support to fill in those fills instead of "justin" etc etc. Or is this process just for one single update. I hope you can help me clear some of this up

[Noel]

the set clause should not be part of an insert statement

The correct syntax for insert is (from memory)

INSERT INTO 'name and mail' (name,email,date) values ("Justin", "Brokenleg513@aim.com", NOW())