while ($r=mysql_fetch_assoc($fields)) { $tmpInsert = "INSERT INTO `invTemp` SET `RefNumber` = '$r[RefNumber]', `Created` = '$r[TimeCreated]' "; echo "$tmpInsert
"; $fields = mysql_query( $tmpInsert ) or die( "$tmpInsert
" . mysql_error()); }