count number of row from mysql database


function total_count($countfield, $tb, $where=”, $orderby=”, $limit=”)
{
$row[] = ”;
if($where == ”)
{
$where = “1=1”;
}
$sql = mysql_query(“select sum($countfield) as total from {$tb} where {$where} {$orderby} {$limit}”);
while($re = mysql_fetch_array($sql))
{
$total = $re[‘total’];
}
echo $total;
//return $total;
}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s