Why does this return Resource id #2? [duplicate]

by

Because you get a mysql ressource when you do a mysql_query().

Use something like mysql_fetch_assoc() to get the next row. It returns an array with the column names as indices. In your case it’s probably COUNT(*).

Here’s a fix and some minor improvements of your snippet:

$rt = mysql_query("SELECT COUNT(*) FROM persons") or die(mysql_error());
$row = mysql_fetch_row($rt);
if($row)
    echo "<h1>Number:</h1>" . $row[0];

If you need to get all rows of the resultset use this snippet:

while($row = mysql_fetch_assoc($rt)) {
    var_dump($row);
}

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Using PHP data in MySQL [closed]
  4. Save the data into a database and return another value from database using PHP
  5. Checking the availability of rooms
  6. How to properly set up a PDO connection
  7. Commands out of sync; you can’t run this command now
  8. Getting raw SQL query string from PDO prepared statements
  9. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  10. Get table column names in MySQL?
  11. MySQL Prepared statements with a variable size variable list
  12. How to resolve ambiguous column names when retrieving results?
  13. Loading .sql files from within PHP
  14. PDO with INSERT INTO through prepared statements [closed]
  15. Use bound parameter multiple times
  16. MySQL “NOT IN” query 3 tables
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. PHP: multiple SQL queries in one mysql_query statement
  19. Doing a while / loop to get 10 random results
  20. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  21. Simple PHP SQL login troubleshooting
  22. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  23. MySql PHP select count of distinct values from comma separated data (tags)
  24. How to SELECT DEFAULT value of a field
  25. Laravel Eloquent get results grouped by days
  26. Do I have to use mysql_real_escape_string if I bind parameters?
  27. SELECT row by DATEPART()
  28. UNION syntax in Cakephp
  29. How do i search from serialize field in mysql database?
  30. PDO and MySQL ‘between’

Leave a Comment