How To Count Number Of Rows In A Mysql Query Get Total Count Rows

This Page Contains information about How To Count Number Of Rows In A Mysql Query Get Total Count Rows By wallpaperama in category MySQL with 3 Replies. [889], Last Updated: Tue Feb 07, 2023

wallpaperama

Mon Feb 18, 2008

3 Comments

10440 Visits

lets say you want to get the total number of queries in a mysql database.

for example, i have a forums and i want to know how many replies the topic number 455 has recieved, i can use this:

$sql = "SELECT COUNT(reply) WHERE topic='455'"
$row = mysql_fetch_row($result);
$count = $row[0];

TEMPLATE:

$sql = "SELECT COUNT (field) WHERE field='$velue'"
$result = mysql_query($sql ,$db);
$row = mysql_fetch_row($result);
$count = $row[0];

emmypro

Tue Jan 10, 2012

nice one...needed that

flander

Mon Jul 28, 2008

really good, i will try it

wallpaperama

Mon Feb 18, 2008

this is anoter one i use

$db = mysql_connect("HOSTNAME", "USERNAME", "PASSWORD");
mysql_select_db("DATABASE_NAME",$db);

$sql2 = "select count(id) from ".$db_prefix."wallpaper WHERE status = '".$_GET['show']."'";
$result2 = mysql_query($sql2 ,$db);
$row2 = mysql_fetch_row($result2);
$num_of_items = $row2[0];

$start_reply = ($page_num * $replies_per_page);
$total_pages = ceil($reply_numbs/$items_per_page);

https://www.wallpaperama.com/forums/how-to-count-number-of-rows-in-a-mysql-query-get-total-count-rows-t5774.html

MySQL INSERT Query How To Add Data To Database Table

How To Count Number Of Rows In A Mysql Query Get Total Count Rows

TEMPLATE:

Related Pages