Why Does My MySQL Query Result Show 'Resource id #6' in PHP?

How to Print the Result of a MySQL Query Using PHP

You're experiencing an issue where the result of a MySQL query is being displayed as "Resource id #6" instead of the intended value. To resolve this, you need to utilize a fetch function.

$result = mysql_query(sprintf("SELECT TIMEDIFF(NOW(), '%s') as time_delta", $row['fecha']));
if ($result) {
    $data = mysql_fetch_assoc($result);
    echo $data['time_delta'];
}

This code will fetch the first row of the result and extract the 'time_delta' field value. However, it's important to note that the mysql functions are deprecated and not recommended for new projects. Instead, you should use PDO with PDO_mysql or mysqli.

The above is the detailed content of Why Does My MySQL Query Result Show 'Resource id #6' in PHP?. For more information, please follow other related articles on the PHP Chinese website!