I want to update data where a condition should be met with WHERE, then it also should compair a condition in another table. I’m not quite sure if I expained the problem clearly.
UPDATE new_project SET brown =’NULL’, blue = ‘#137DD8′ WHERE id=’$_GET[id]’ AND WHERE EXISTS (SELECT exist FROM materials WHERE material_id = ‘$_GET[id]’)
This is what comes to my mind but I know it won’t work
New contributor
TAK is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.