Using Insert Into...Select with a join

[Anon]

I am trying to insert data from two different tables into an existing table using the code below. No errors are generated but nothing gets put into the third table "staffrecord". Any help would be appreciated. Thanks much.

[Anon]

for some reason the code did copy - here it is;<form action="add_staff_record.php" method="post">
Do you want to add this staff to the staff record table?<br>
Yes<input type="radio" value="yes" name="add"><br>
No <input type="radio" value="no" name="nonadd"><br>
Staff ID: <input type="text" name="id" size="10">
<input type="submit" name="stage">
</form>
<?php
extract($HTTP_POST_VARS);
mysql_connect('localhost');
mysql_select_db('employee');
mysql_query("INSERT INTO staffrecord(ID,due_in,reqrmnt)SELECT profile.ID AS ID,requirements.duein AS duein,requirements.requirement AS requirement FROM profile INNER JOIN requirements ON profile.position=requirements.position WHERE ID ='$id'") or die ("Error: ".mysql_error());
print("$id");
?>

[Anon]

Looks like it should work. The first thing I would check is whether $id contains what you expect to match in the database. Try changing the "print" to something like this and make sure there aren't extra blanks or something like that messing up the match. DO something similar to see exactly what's in the database. Also make sure "position" columns in profile and requirements will match perfectly.

echo "<BR>---" . $id . "---<BR>";