Any ideas why this does not work?
I get "Warning: Argument #2 to array_diff() is not an array " back
thanks
<?php
$alljobs = mysql_db_query("cad_design_db", "SELECT b.bpcs_num, b.model_year, b.program_name, c.comp_name FROM bpcs b, customers c where b.cust_id = c.cust_id order by comp_name");
$asnjobs = mysql_db_query("cad_design_db", "SELECT a.bpcs_num, b.model_year, b.program_name, c.comp_name FROM bpcs_assn a, bpcs b, customers c WHERE a.bpcs_num = b.bpcs_num and b.cust_id = c.cust_id and a.cadsource_id = 6");
//list out assigned jobs
while($asnjobs_arry = mysql_fetch_array($asnjobs))
{
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</tr>\n", "<input type=\"checkbox\" name=bpcs[] value=$asnjobs_arry[bpcs_num] checked>", $asnjobs_arry["bpcs_num"], $asnjobs_arry["comp_name"], $asnjobs_arry["model_year"], $asnjobs_arry["program_name"]);
}
$alljobs_arry = mysql_fetch_array($alljobs);
$asnjobs_array = mysql_fetch_array($asnjobs);
// separate the assigned jos. So they do not get listed twice
//list out unassigned jobs
while($unasnjobs_arry = array_diff($alljobs_arry, $asnjobs_array))
{
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</tr>\n", "<input type=\"checkbox\" name=bpcs[] value=$unasnjobs_arry[bpcs_num]>", $unasnjobs_arry["bpcs_num"], $unasnjobs_arry["comp_name"], $unasnjobs_arry["model_year"], $unasnjobs_arry["program_name"]);
}
?>
