SQL insert query problem ?

[developer]

Hello!

What might be wrong here please? It might be because "type" is a reserved word? In that case is there anything to do in the code, beacuse I would be very happy if I don't have to change that name in the database.

Happy for any help.

$Query2 = "INSERT INTO tabs(id, date, genre, type, artist, album, title, tab, clicks ) VALUES ('', '".$date."', '".$row['genre']."', '".$row['type']."', '".$row['artist']."', '".$row['album']."', '".$row['title']."', '".$row['tab']."', '0') ";

The error:

Error: You have an error in your SQL syntax near 'll never use them ' at line 1 in query: INSERT INTO tabs(id, date, genre, type, artist, album, title, tab, clicks ) VALUES ('', 'May 26, 2003', 'punk', 'lyrics', 'NOFX', '45 or 46 songs', 'all of me', 'All of me why not take all of me can .', '0')

[Sxooter]

You're not properly escaping data before sending it to the database. You need to

$field = addslashes($field)

your fields.

Then, on getting htem back, use stripslashes() to remove the slashes.

[developer]

Hello! 🙂

That doesn't help. 🙁

[kevinsequeira]

if id an autoincrement field in your table , then dont use ' ' to insert its value use 'NULL' or remove it from the query.

reg
kevin

[developer]

Works now.

Thanks for the help all.

[ade]

i am getting a similar problem

$link_id = mysql_connect("localhost","blah","blah2");
if (mysql_select_db("some_db",$link_id)) echo "your connected<br><br>" ;
else die ("Could not select database");

$query = "INSERT INTO users( name, organisation,
event, jpasses, jnames, ppasses, pnames, bpasses,
bnames, tpasses, tnames, address, email, other, isdn,
phone, additional)
VALUES ( $name, $organisation, $event, $jpases, $jnames,
$ppasses, $pnames, $bpasses, $bnames, $tpasses, $tnames,
$address, $email, $other, $isdn, $phone, $additional)";

$result = mysql_query($query) or die ("Query failed");

i get a query failed not too sure why

[tomhath]

You need to put quotes around all the variables containing strings. Look at how the original post did it.

[ade]

i still get a problem, comes up with the error when i put in the "" on the string variables
Parse error: parse error, unexpected T_VARIABLE in C:\Program Files\Apache Group\Apache2\htdocs\blah\somefile.php on line 8

and line 8 is the $query = INSERT into user......

$link_id = mysql_connect("localhost","blah","blah2");
if (mysql_select_db("some_db",$link_id)) echo "your connected<br><br>" ;
else die ("Could not select some_db database");

$query = 'INSERT INTO users ( id , name , organisation , event , jpasses , jnames , ppasses , pnames , bpasses , bnames , tpasses , tnames , address , email , other , isdn , phone , additional ) VALUES (\'null\,'\'$name\', \'$organisation\',\' $event\',\'$jpases\',\'$jnames\',\'$ppasses\', \'$pnames\',\'$bpasses\', \'$bnames\',\'$tpasses\',\'$tnames\', \'$address\',\'$email\',\'$other\',\'$isdn\',\'$phone\', \'$additional\');';

$result = mysql_query('$query') or die ("Query failed");

still comes up as query failed 🙁

[tomhath]

Too many quotes. Try something like this:

$query = "INSERT INTO users( name, organisation, 
event, jpasses, jnames, ppasses, pnames, bpasses, 
bnames, tpasses, tnames, address, email, other, isdn, 
phone, additional) 
VALUES ( '$name', '$organisation', '$event', '$jpases', '$jnames', 
'$ppasses', '$pnames', '$bpasses', '$bnames', '$tpasses', '$tnames', 
'$address', '$email', '$other', '$isdn', '$phone', '$additional')"; 

[stolzyboy]

what tomhath told you WILL work, but for future reference

use

$result = mysql_query('$query') or die ("Query failed");

instead of

$result = mysql_query('$query') or die (mysql_error());

for better mysql error reporting so it is easier to track your problems down

[ade]

problem solved myISAM database