how to count number of rows in a mysql query get total count rows

RegisterLogin

Webune Forums » MYSQL » how to count number of rows in a mysql query get total count rows

how to count number of rows in a mysql query get total count rows
Post Description: how to count number of rows in a mysql query get total count rows
Tags: how, to, count, number, of, rows, in, a, mysql, , query, get, total, count, rows
This Post Was Posted On Feb 29, 2008 By web hosting #1492

how to count number of rows in a mysql query get total count rows by web hosting

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];

Leave Your Comments

Related Pages: [Add Your Website]

Post New Topic

Counting Rows In Mysql

hostman

#1930 1

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);

Feb 18, 2008 Reply Report abuse