Combining 2 Queries with OR operator

Question

I'm trying to insert something to a table and also delete at the same time so my query is like this $query = mysqli_query($connect,"SELECT * FROM inventory_item WHERE status = 'Unserviceable' OR DELETE * FROM inventory_item WHERE status = 'Available") or die ("Error: Could not fetch rows!"); $count = 0;

I wanted to insert datas with Unserviceable status and at the same time delete datas with Available status but its not working. I'm not really familiar with queries and just starting out.

There’s no insert statement and why would you want to do them at the same time? They cannot be combined like this. OR is for logical conditions. — Sami Kuhmonen, Nov 27 '18 at 17:42
This looks like two separate queries. The OR is not valid syntax. — devlin carnate, Nov 27 '18 at 17:43
@SamiKuhmonen the insert statement is in another page. How do I update the tables and delete something at the same time? — Riiic, Nov 27 '18 at 17:45

score 1 · Answer 1 · answered Nov 27 '18 at 17:47

This is not valid SQL syntax.

If you want to issue two queries, one to INSERT and one to DELETE, then you can send them as two separate calls to mysqli_query(). There appears to be an alternate function mysqli_multi_query() that allows multiple statements to be included which you can read about here.

Finally, if you want the two separate queries to execute as a single unit (that is, if one of them fails then neither is executed) then you should research the subject of database transactions, which allow you to execute multiple queries and commit or roll back the entire set of queries as a unit.

Combining 2 Queries with OR operator

1 Answers1