I can't get sql query to work in Codeigniter. How to write sql query correctly?

Question

CodeIgniter

I can’t figure out how to correctly set a sql query, if I just throw a query in phpmyadmin in sql, then everything is good, and if it doesn’t work through the function
, they have their own builder and I can’t figure it out so it only outputs the number 1))

Answer 1

Well, well... you're trying to fit two queries into one, and db->query only executes one query at a time.
Either create a stored procedure, or use transactions, or increment your rank when parsing the fetch result.