mysql syntax error in insert into table query?

Question

I am trying to insert data to a table  and keep getting a syntax error ....
[look for the current manual for your version of mysql ....bla bla blas ... near line 1]
I have echoed the values are variables and they print out fine before this statement.
this is day number 2 trying to find the error? any help with this would be welcome

'mysql_query("INSERT INTO 'giacones' 
(catagory,itemname,discription,price,itemnumber) 
VALUES 
($catagory,$itemname,$discription,$price,$itemnumber)")
or die(mysql_error());

Ratchetr · Accepted Answer

You don't want to use 's around your table name. You can use ` (back tick):
`giacones` or in most cases you don't need to use anything around the table names.

You DO need to use 's around your values, for any value that is a string type (numbers don't need them).

So you would want: ( '$catagory' , '$itemname' ,...

gripp · Answer

Create table: create table verify (identification int no longer nul auto_increment generally happening key, digital mail varchar(50)) verify whether consultation includes value or no longer. <?Hypertext Preprocessor if($_SESSION['digital mail']!='') { $digital mail=$_SESSION['digital mail']; } if(isset($_POST['post'])) { mysql_connect('localhost','root','') or die(mysql_error()); mysql_select_db('db') or die(mysql_error()); $q=mysql_query("insert into verify values('','".$digital mail."')") or die(mysql_error()); if($q) { echo'Values are inserted'; } else { echo'Values at the instant are not inserted'; } } ?>

Trending News

mysql syntax error in insert into table query?

2 Answers