Can anyone help me with this query? Is it possible to do something like this? I am very new to SQL.

I have an SQL query for a PHP API that includes calculations for fields like current_device, is_online, and expire_in. Should I handle these calculations in the PHP backend, or is it acceptable to perform them within the SQL query? Which is better?

Buonasera, sto imparando php e l’estrazione dei dati dal database sql.
Vorrei ricavare tramite l’id di una categoria, la visualizzazione del contenuto di quella categoria.

i have written two queries for two data, which will fetch data from two databases and show the output as data of the database, but it is taking one and for another it is showing Undefined property: stdClass::$totals,
need to solve this

I’ve been asked to create a table in a DB, its been about 15 years since I’ve had to touch SQL so I’m a little lost.

I want to show similar posts on the post page using this code:

$sql = “SELECT * FROM ORDERS”;
$result = $connection->query($sql);