Can you explain this? GROUP

flash99

Hi, I came across this strage problem and thought to share it with you!

I have created an HTML form so that a user can enter data into the mySQL database. I have a very simple table with 3 columns )id, group, card). The SQL query in my PHP code was as follows:

$sqlreceive = "INSERT INTO $table1 (group,card) VALUES ('$POST[group]',$POST[card])";

$resultreceive = @($sqlreceive) or die("Sorry, could not complete query!");

From this code I kept getting the message "Sorry, could not complete query!". After trying many changes it didn't work until I changed the name of the field group to somethihg else. After I did this everything worked as normal.

Does anybody know why does this happen? Does this mean we cant use group in the database?

Thanks!

localhost

Try this

$sqlreceive = "INSERT INTO $table1 (group,card) VALUES ('".$_POST['group']."','".$_POST['card']."')"; 

$resultreceive = @mysql_query($sqlreceive) or die("Sorry, could not complete query!");

flash99

No that didn't work! I had the same error!

Is group a reserved word or something, because as I explained b4 that I changed the name and it worked perfect, when I change it back I get the error!!

localhost

oh i didnt noticed that you are using group as a field name
group is a mysql function

nemonoman

you can probably get around this by using an complete, explicit column name eg

table1.column1

or in your case table1.group

This is why MySQL allowed you to use the name 'group' for a column. As part of 'table1.group' it should process OK. Using the more typical shorthand (NOT explicitly stating the table.) the column name group is confused w. GROUP, as others have pointed out.

Interesting that GROUP causes mysql to burp, but 'timestamp' is a perfectly OK name for a MySQL column.

arelgee

I had to redo a half dozen Paradox tables when I started using SQL queries on them because I had used a slash in the column names ie. Price/Share and had a column for the Float of a company's stock and a Sector and Group
I am working on a PHP/MYSQL editor and that might be a good thing to add, a sort of spellchecker for reserved words. It would save a lot of grief.
If anyone else has any ideas, let me know.
arelgee aka larry grant arelgee@are-l-gee.com