PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
1. You didn't say what the problem was.
2. Your query is missing some commas.
3. It's also insecure because it's using stuff from $_POST without validating/sanitizing it.
Please do keep in mind that $_POST right off the bat already contains extra field values than what you are searching for. You should refine your output and as stated sanitize the data. After every SET insertion you need a comma.
Sorry I should've made it clear, it basiclly is not updating I have added the commas now it's not giving me any errors message but at the same time its NOT Updating.
I prefer to checkeach step of the way by inserting the following line after if($_POST['submit']) {:
echo 'Check Data: ' . $job_id;
That way, you are ensuring that your form is actually passing some information. If that shows the data you were expecting then its a problem with your query.
By the way, if it was me, id split the update query into three separate queries, one for each table. Its less messy.
Its funny you've said that about spliting the queries theboyholty, that's exactly what I have just done and it seems to be ok now all tables are updating fine. I'm fairly sure I could've done this in one query but its just wasting so time. Thanks for repying