im trying use the update select statement, but i want it to update a certain id, i tried the below and it doesnt work:
$sql = "UPDATE $table_name SET contact_name='$contact_name' WHERE job_id='$job_id'";
are you receiving any error, try using mysql_error() after your query to see what the problem is
have you double checked the column names?