Problem with MySQL Query.

[wxdqz]

I am writing a script to compare two mysql tables. In the script I am writing a query to insert data where field matches value.

example:

$query = "INSERT INTO table ( $field ) values ( $val ) where $FIELD = $VALUE"
mysql_query( $query, $link );

I am just trying to BS the syntax and am just beggining to learn MySQL. I guess the question is how to I execute a MySQL command to find a specific row and insert data.

Thanks,
Adam