Invalid field name in table?

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I have a table with a field name of name. Isn't this a reserved word. The problem is I can't get the team_id to insert into eto_rpoints_lkup. Everything else inserts correctly except for team_id.

My php editor I use has the word highlighted.

mmm.

Here is my code.

Darn, Sentinal is blocking me. I'll try and attach a txt later.

http://www.eto-league.com/MatchList.txt

Posted: Fri Dec 15, 2006 7:46 pm

In the code you referred us to you have team_id commented out as a hidden field.

I've also had bad luck sticking comments in the middle of an echo that's concatenated. You would really want to move any commented fields outside of the echo area -- I'm not saying it can't work the way you have it but it really puts your brain parser to the test if you know what I mean.

You also might want to echo out the post variables after you read them in and see if you have loaded them as you expected. Finally, I don't know if MYSQL treats name as reserved but I know that Nuke uses $name as a variable name throughout. I had a custom module where I was using $name at one point and I had to go back and change it to keep from conflicting with Nuke's "reserved" variable. I would recommend prefixing it or using some variant. No sense tempting fate.

And I DO see the mysql error echoes. Congrats on that!

Posted: Fri Dec 15, 2006 10:28 pm

Neither way worked about the comments with team_id.

I even added the team_id to the rows being displayed to make sure I am getting the correct one.

123 is the correct team_id for the 3rd Infantry.

I don't see how else to $_POST them, I've always done it this way.