Help Needed INSERT INTO

[trobarge]

After weeks of trying because I can not see why it is not working. Here is the code

$qry="SELECT (dm_id, mpm_id, sfi_id, hit_id, am_id, nc_id, spm_id, ds_id, s4t_id, d2c_id, ts_id, tr_id, ts25_id, tg_id, wbi_id, tp_id, tops_id) VALUES (\"$dm_id\", \"$mpm_id\", \"$sfi_id\", \"$hit_id\", \"$am_id\", \"$nc_id\", \"$spm_id\", \"$ds_id\", \"$s4t_id\", \"$d2c_id\", \"$ts_id\", \"$tr_id\", \"$ts25_id\", \"$tg_id\", \"$wbi_id\", \"$tp_id\", \"$tops_id\") FROM ews_programs WHERE $referrer_id = ews_programs.af_id";
$result=mysql_query($qry, $db);
while ($myrow=mysql_fetch_row($result)) $diff=$myrow[0];

$qry="INSERT INTO ews_programs af_id dm_id, mpm_id, sfi_id, hit_id, am_id, nc_id, spm_id, ds_id, s4t_id, d2c_id, ts_id, tr_id, ts25_id, tg_id, wbi_id, tp_id, tops_id) VALUES (\"$af_id\"\"$dm_id\", \"$mpm_id\", \"$sfi_id\", \"$hit_id\", \"$am_id\", \"$nc_id\", \"$spm_id\", \"$ds_id\", \"$s4t_id\", \"$d2c_id\", \"$ts_id\", \"$tr_id\", \"$ts25_id\", \"$tg_id\", \"$wbi_id\", \"$tp_id\", \"$tops_id\")";
$result=mysql_query($qry, $db);

What I am trying to do is copy the record of the person referring the new person to the new person. The af_id is created by sql, $referrer_id is already preset from a cookie.

[laserlight]

Please post your PHP code in [php][/php] forum bbcode tags. You should also state how does your code not work.

[trobarge]

What am I missing here. I SELECT all the fields and add a VALUE to them but when I try to INSERT INTO the data base not thing happens. I even tried ECHO one of the fields to see if the variable was there. which it was not. I also echo the $referrer_id and it returned the correct value. It did enter the $af_id but that was it. Please excuse me this is my first PHP project and have reviewed several different books to find the correct code and if I read is right this should work but it does not.

[php code]
$qry="SELECT (dm_id, mpm_id, sfi_id, hit_id, am_id, nc_id, spm_id, ds_id, s4t_id, d2c_id, ts_id, tr_id, ts25_id, tg_id, wbi_id, tp_id, tops_id) VALUES (\"$dm_id\", \"$mpm_id\", \"$sfi_id\", \"$hit_id\", \"$am_id\", \"$nc_id\", \"$spm_id\", \"$ds_id\", \"$s4t_id\", \"$d2c_id\", \"$ts_id\", \"$tr_id\", \"$ts25_id\", \"$tg_id\", \"$wbi_id\", \"$tp_id\", \"$tops_id\") FROM ews_programs WHERE $referrer_id = ews_programs.af_id";
$result=mysql_query($qry, $db);

$qry="INSERT INTO ews_programs af_id dm_id, mpm_id, sfi_id, hit_id, am_id, nc_id, spm_id, ds_id, s4t_id, d2c_id, ts_id, tr_id, ts25_id, tg_id, wbi_id, tp_id, tops_id) VALUES (\"$af_id\"\"$dm_id\", \"$mpm_id\", \"$sfi_id\", \"$hit_id\", \"$am_id\", \"$nc_id\", \"$spm_id\", \"$ds_id\", \"$s4t_id\", \"$d2c_id\", \"$ts_id\", \"$tr_id\", \"$ts25_id\", \"$tg_id\", \"$wbi_id\", \"$tp_id\", \"$tops_id\")";
$result=mysql_query($qry, $db);
[/php code]

Thanks
trobarge

[JVassie]

But you didnt check your post to make sure the tags actually worked?

the tags dont code in them, merely PHP.

Also, do the queries come that way round in the code?

[webdevelope]

do you print the error msg? that'll help find out the problem.