phranque
msg:4495718 | 11:34 am on Sep 16, 2012 (gmt 0) |
welcome to WebmasterWorld, vaayaaedu!
i think using VALUES (plural) requires a comma-separated list of values.
|
brotherhood of LAN
msg:4495727 | 12:00 pm on Sep 16, 2012 (gmt 0) |
Welcomes to the forums
desc is a reserved word [dev.mysql.com] in MySQL, so that will throw an error.
You can still use it but should enclose it in backticks. It's generally considered good practice to avoid naming columns as reserved words, or get in the habit of using backticks for all column names.
So this should work:
$query = "INSERT INTO requirement (`desc`) VALUES ('test1') ";
|
phranque
msg:4495729 | 12:03 pm on Sep 16, 2012 (gmt 0) |
oops - i didn't even "see" that!
|
brotherhood of LAN
msg:4496012 | 9:35 pm on Sep 16, 2012 (gmt 0) |
Yep it's something that people rarely encounter imo, it's not like it's worth memorising the list.
This one has me going for a while, but should have been obvious
SELECT * FROM acc_soc AS as INNER JOIN ......
|
|
