Mysql count rows function

Question

I have created a simple function which takes user id and show total no. of post by the user id

function totalpost($user_id){
$sql = 'SELECT * FROM posts WHERE u_id='.$user_id;
$total = mysql_num_rows(mysql_query($sql)) or die(mysql_errno());
return $total;

}

Its working fine, but when 0 record found, it not returns anything.

I want to return 0 if there are no record found

Please help

Your Common Sense · Accepted Answer · 2010-06-18 13:25:44Z

3

function totalpost($user_id){
  $sql = 'SELECT count(*) FROM posts WHERE u_id='.intval($user_id);
  $res = mysql_query($sql)) or trigger_error(mysql_error().$sql);
  $row = mysql_fetch_row($res);
  return $row[0];
}

not because you need 0, but because you have to always use count() instead of selectiong all users posts which can be big load of data.

answered Jun 18, 2010 at 13:25

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

Comments

Justin Ethier · Accepted Answer · 2010-06-18 13:24:52Z

2

Try this query:

SELECT COUNT(*) FROM posts WHERE u_id=xx

By using the COUNT function you will guarantee a 0 will be returned even if no rows match the WHERE clause.

answered Jun 18, 2010 at 13:24

Justin Ethier

135k53 gold badges235 silver badges291 bronze badges

Collectives™ on Stack Overflow

Mysql count rows function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related