[SOLVED] Won't insert into database

[div]

I'm trying to insert information into the database, here's no error message coming up but it isn't inserting. I've checked, double-checked and triple-checked the numbers, everything is lined up right but it just won't work.

 

mysql_query("insert into transactions (playerid,toid,fromid,amount,for) values ('$sid','1','$sid','5000','Created')");

 

 

All the code before and after it is working properly, and the values are all valid. It's all but identical to another INSERT command right below it, which is working 100% fine. Help!  ???

[Mchl]

Do

echo "insert into transactions (playerid,toid,fromid,amount,for) values ('$sid','1','$sid','5000','Created')";

to see if its formed all right.

 

Do

if (!mysql_query("insert into transactions (playerid,toid,fromid,amount,for) values ('$sid','1','$sid','5000','Created')")) {
  echo mysql_error();
}

to check for mysql errors.

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

[div]

Ahh, of course!

 

Changed 'for' to 'info' in the database and script, and it is now working perfectly.

 

Thanks a million!