I had to do:
$query_is = "INSERT INTO irs_query SELECT * FROM irs_rawdata WHERE EIN = '$fin' AND PNO LIKE '%blind%'";
$result_is = mysql_query($query_is);
$count = mysql_affected_rows();
if ($count)
{
echo "The record matched the criteria, we have added it to the \"irs_query\" table and deleted it from \"irs_rawdata\"!<br />";
}
else
{
echo "The record did't match the criteria, we have added it to the \"block\" table and deleted it from \"irs_query\"!<br />";
}
if you use the mysql_num_rows($...) with a insert select it does not like it at all and does not give you any helpful information to figure it out.
Sincerely,
Christopher
