PHP Count SQL gives no result [duplicate]

Question

I want to Count a number of elements in a MySQL Table with the PHP element count, but when i try to give out the result it print 'Resource id #5' which is of course the id for succeeded MYSQL srcipts. If I type it in the SQL console it says I have got Syntax Error (#1064). Thats my code:

<?php
$dbhost = >>hostname<<;
$dbuser = >>user<<;
$dbpass = >>password<<;
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('Could not connect: ' . mysql_error());
}
mysql_select_db(>>database to be selected<<)
or die ("Database couldn´t be found");

echo mysql_query('SELECT COUNT(*) FROM table'); ?>

Which mysql_fetch_ do i have to use?

Thanks for any effords and a happy new year

Tim

did you checked this, stackoverflow.com/questions/6907751/… — Sugam
– Sugam, Commented Jan 1, 2016 at 16:56
The mysql_query returns a resource object ( as stated in the error ) and cannot be printed directly. You need to access the records in the appropriate manner — Professor Abronsius
– Professor Abronsius, Commented Jan 1, 2016 at 17:03
Also, definitely worth reading for security reasons: mysql - Why shouldn't I use mysql_* functions in PHP? — Brandon White
– Brandon White, Commented Jan 1, 2016 at 17:08

Barmar · Accepted Answer · 2016-01-01 17:19:46Z

2

You have to fetch the result from the query.

$result = mysql_query('SELECT COUNT(*) AS count FROM table');
$row = mysql_fetch_assoc($result);
echo $row['count'];

You should also convert from the mysql extension to PDO or mysqli, but the basic structure is the same -- after performing a query you have to fetch the results as a separate step.

answered Jan 1, 2016 at 17:19

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Vahlbrock Over a year ago

Thanks, that worked. I will probably write the website finished first and rewrite it for PDO or mysqli afterwards.

devpro · Accepted Answer · 2016-01-01 19:03:02Z

0

If you just looking for:

Which mysql_fetch_ do i have to use?

Than you can try these:

mysql_fetch_assoc();
mysql_fetch_array();
mysql_fetch_object();

Side note: Also remember what Mr. Barmar said about the **PDO or mysqli_* **

answered Jan 1, 2016 at 19:03

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Collectives™ on Stack Overflow

PHP Count SQL gives no result [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related