How can I fix this syntax error on my PHP MySQL query

Question

I have been trying to make a query in MYSQL, I am doing 2 things in 1 query. My host has a Limit to queries so I need to limit the amount of queries I am doing. When I did the query I get

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', (UPDATE users SET last_online=NOW() WHERE username='Welcome_234')' at line 1

I have put a semicolon ";" but it still doesn't work (This query worked in phpMyAdmin).

The code for the query is:

SELECT * FROM `users` WHERE username='Welcome_234',
UPDATE `users` SET last_online=NOW() WHERE username='Welcome_234'

I have tried many hours to figure out the problem and I still haven't found it.

Thats 2 seperate queries! How are you trying to execute them in your PHP — RiggsFolly
– RiggsFolly, Commented Aug 29, 2021 at 14:53

Bill Karwin · Accepted Answer · 2021-08-29 14:58:26Z

1

Most PHP interfaces to run MySQL queries don't support multiple queries per call. You must run them one query per call.

Your host's limit on queries can't be so low that the difference between one and two queries will break it. I would guess the limit is in place to prevent clients from running excessive loops that run thousands of queries. If it is so low that you can't run two queries, then get a different host.

answered Aug 29, 2021 at 14:58

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I fix this syntax error on my PHP MySQL query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related