Setting variable equal to count of a field in database table

Question

For the query below, I would like to set a variable called $totalcount equal to the count of all loginids in table called login. How can I do this?

Thanks in advance,

John

$sqlStrcount = "SELECT loginid FROM login";

Mads Lee Jensen · Accepted Answer · 2010-10-21 09:57:23Z

1

$sqlQueryStr = "SELECT loginid FROM login";
$sqlQuery = mysql_query($sqlQueryStr);

$totalCount = mysql_num_rows($sqlQuery);

If you only need to count your records in login use this instead for performance reasons.

$sqlQueryStr = "SELECT COUNT(loginid) as totalCount FROM login";
$sqlQuery = mysql_query($sqlQueryStr);

$row = mysql_fetch_assoc($sqlQuery);
$totalCount = $row['totalCount'];

answered Oct 21, 2010 at 9:57

Mads Lee Jensen

4,6585 gold badges38 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Setting variable equal to count of a field in database table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related