Simple MySQL Insert error.

[Jake]

I dont know why this isn't working, i've checked all of the field names from the database. And even copied and pasted from other Inserts, but its not working:

 

$myfirm=mysql_query("SELECT * FROM firms WHERE fID={$_GET['ID']}",$c);
$mf=mysql_fetch_array($myfirm);

$warfirm=mysql_query("SELECT * FROM firms WHERE fID={$_GET['WID']}",$c);
$wf=mysql_fetch_array($warfirm);

mysql_query("INSERT INTO firmwars VALUES('', '{$my['fID']}', '{$my['fNAME']}', '{$wf['fID']}', '{$wf['fNAME']}', '0')",$c);

 

It is for my gangs mod.

I get not error, it just simply doesn't happen.

[UCC]

Re: Simple MySQL Insert error.

I'm only familiar with 2.0 code but here are some questions that could lead to something.

Did you intend to not use any MF query variables?

What is the $my array?

[spellbyte ®]

Re: Simple MySQL Insert error.

$myfirm=mysql_query("SELECT * FROM firms WHERE fID={$_GET['ID']}",$c);

$mf=mysql_fetch_array($myfirm);

$warfirm=mysql_query("SELECT * FROM firms WHERE fID={$_GET['WID']}",$c);

$wf=mysql_fetch_array($warfirm);

mysql_query("INSERT INTO firmwars VALUES('', '{$mf['fID']}', '{$mf['fNAME']}', '{$wf['fID']}', '{$wf['fNAME']}', '0')",$c);

[Jake]

Re: Simple MySQL Insert error.

I have tried that, and it still does not work.