[SOLVED] error in mysql sytanx

[Looktrne]

I cant see the error in this syntax?

 

mysql_query("INSERT INTO brain (mail, is)

VALUES ('$email[0]', '1')")or die(mysql_error()); 

[MasterACE14]

this part right here...

'$email[0]'

 

it needs to be $email['0'] . However, I believe that will conflict with the other comma's

 

you can do it this way...

<?php
$email = $email['0']

mysql_query("INSERT INTO brain (mail, is)
VALUES ('$email', '1')")or die(mysql_error()); 

 

that will work.

[Looktrne]

I changed it to this

 

mysql_query("INSERT INTO brain (mail, is)

VALUES ('$ie', '1')")or die(mysql_error()); 

 

still getting error message:

 

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 'is) VALUES ('[email protected]', '1')' at line 1

[br0ken]

The word 'is' a reserved word in MySQL and cannot be used as a table column or name as it is always interpeted as MySQL keyword like SELECT or IF or NOT etc. Recreate the table changing that column name and the query should run fine.

[Looktrne]

wow you are the best..

 

[br0ken]

Anytime mate. When the thread is solved could you please click the 'Topic Solved' link at the bottom. It just speeds up finding threads that still  need solving making the forum better and more productive for everyone