SQL error in database error thingy help!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Mythic Fr0st
Forum Contributor
Posts: 137
Joined: Sat Dec 02, 2006 3:23 am
Contact:

SQL error in database error thingy help!

Post by Mythic Fr0st »

I keep getting this error, not sure why though o_O

Error: 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 ''Gaming_Ink@yahoo.com.au)' at line 3

any idea's, my SQL syntax at PHP admin is good I think?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Post your query. I would suspect it has something to do with not using quotes around a string in your query. And please use descriptive titles when posting. It is one of our rules here. On a side note, what tutorial are you using for your project? Or are you using a book or some other teaching method?
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
Mythic Fr0st
Forum Contributor
Posts: 137
Joined: Sat Dec 02, 2006 3:23 am
Contact:

ok

Post by Mythic Fr0st »

Umm, whats a query :) where is it?, and this is the tutorial (php)

http://www.w3schools.com/php/php_mysql_insert.asp
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

I would suggest you start with a book for your learning, rather than the w3schools examples. They are decent examples, but not very good for learning from.

A query is a database call. Basically when you want to SELECT, INSERT, DELETE or UPDATE something in the database you would issue a query to the database then handle the response from the database server. But for now, you really should be taking baby steps. You may be moving too fast at the moment.
hrubos
Forum Contributor
Posts: 172
Joined: Sat Oct 07, 2006 3:44 pm

Post by hrubos »

You should learn from basic example or you should try to learning by doing small project. While you are dong, u have problem, u can post here and somebody help you.

I give y idea because I am too newbie in Php and I understand how diffcult for beginner but nothing diffcult if you try ur best

Have nice!!!
Post Reply