How do i “echo” a “Resource id #6” from a MySql response in PHP?

by

You need to use a fetch function. for example:

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

However, i wouldnt use the mysql functions unless absolutely necessary. the mysql extension is NOT recommended for use in new projects. Instead you should use PDO with PDO_mysql or mysqli.

More Related Contents:

  1. Php mysql tabs don’t output [closed]
  2. Update Mysql except when field not null
  3. How can I prevent SQL injection in PHP?
  4. UTF-8 all the way through
  5. SQL injection that gets around mysql_real_escape_string()
  6. Can I mix MySQL APIs in PHP?
  7. jQuery Validate remote method usage to check if username already exists
  8. MySQL query to get column names?
  9. PDO get the last ID inserted
  10. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  11. Insert/update helper function using PDO
  12. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  13. Best way to check if mysql_query returned any results?
  14. mysql_fetch_array return only one row
  15. Insert multiple rows with PDO prepared statements
  16. a better approach than storing mysql password in plain text in config file?
  17. mysql query result in php variable
  18. mysql_real_escape_string is undefined
  19. Unknown database error in PHP but it exists in PHPMyAdmin
  20. Can I blindly replace all mysql_ functions with mysqli_?
  21. How do detect that transaction has already been started?
  22. return multiple response data in one response
  23. CakePHP Database connection “Mysql” is missing, or could not be created
  24. MySQL Alter Table Add Field Before or After a field already present
  25. mysql error ‘TYPE=MyISAM’
  26. Storing datetime as UTC in PHP/MySQL
  27. PHP prepared statements and transactions in a loop [duplicate]
  28. using mysql_close()
  29. Using PDO Prepared Statement and Incrementing a column value
  30. Displaying BLOB image from Mysql database into dynamic div in html

Leave a Comment