How can I debug why simplest MySQL query returns false?

by

An obligatory update: as mysql ext is no more, here are answers for two remaining MySQL APIs which I written on my site based on the experience from answering 1000s questions on Stack Overflow:

In short, for mysqi the following line have to be added before mysqli_connect() call:

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

while for PDO the proper error mode have to be set, for example

$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

As of the old mysql ext,

To get an error from mysql_query() you have to use mysql_error() function.
So always run all your queries this way, at least until you develop a more advanced query handler:

$query = "SELECT * FROM 'users'";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);

the problem with your current query is 'users' part. Single quotes have to be used to delimit strings while for the identifiers you have to use backticks:

SELECT * FROM `users`

In order to see these errors during development, add these lines at the top of your code to be sure you can see every error occurred

ini_set('display_errors',1);
error_reporting(E_ALL);

on the production server, however, the value on the first line should be changed from 1 to 0

More Related Contents:

  1. Laravel – only a zero is saved to the database
  2. storing user_id in session variable
  3. mysqli or die, does it have to die?
  4. Convert from MySQL datetime to another format with PHP
  5. MySQL vs MySQLi when using PHP [closed]
  6. How do I set ORDER BY params using prepared PDO statement?
  7. Passing an array to a query using a WHERE clause
  8. How can I store and retrieve images from a MySQL database using PHP?
  9. PHP/MySQL Insert null values
  10. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  11. PHP file cannot enter some part of code
  12. Laravel: PDOException: could not find driver
  13. Can you add an if statement in ORDER BY?
  14. PDO Connection Test
  15. Grouping WHERE clauses in Codeigniter
  16. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  17. MySQL (or PHP?) group results by field data
  18. SELECT COUNT() vs mysql_num_rows();
  19. Store procedures in phpMyAdmin
  20. Check if a row exists using old mysql_* API
  21. Unique IPs in a voting system
  22. MySQL get a random value between two values
  23. php password_verify() hash and pass won’t match
  24. MySQL query using an array [duplicate]
  25. PHP mySQL – Insert new record into table with auto-increment on primary key
  26. Using MySQL’s TIMESTAMP vs storing timestamps directly
  27. how to execute mysql command DELIMITER
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. PDO and MySQL ‘between’
  30. PHP add up two time variables

Leave a Comment