Please sql problem Select then INsert

[sun373]

I tried to select then insert but I got error in this line $row=mysql_fetch_array($result); . Anyone have any comment !!!

$sql="Select * form PC where CountryID='$CountryID' and PostalCodeID='$code'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$Myvalue =$row["CountryPostalCodeID"];

$sql="INSERT INTO AR (Postal) VALUES ('$code') where CountryPostalCodeID='$Myvalue' ";
$result=mysql_query($sql);
If($result)
{
echo "OK";
}

[justsomeone]

Give us another clue. What error did you get? 🙂

If you want to be able to use field names as array indices, I'd suggest using mysql_fetch_assoc() but I don't think that's actually your problem here. It may be that your select doesn't actually find anything, so there is no row for any fetech to return. That could generate an error at that line.

I would suggest adding

echo $mysql;

before you call mysql_query just to make sure that the query looks like what you expect.