Counting Rows In Mysql

RegisterLogin

Webune Forums » MYSQL » Counting Rows In Mysql

Counting Rows In Mysql
Post Description: Counting Rows In Mysql
Tags: Counting, Rows, In, Mysql
This Post Was Posted On Aug 22, 2009 By jayos.2010 #1509

Counting Rows In Mysql by jayos.2010

i have a problem in my script

i have some users who signed up and i want to be able to update this other table with how many users i have that are signed in. so i want to count those rows only

Leave Your Comments

Related Pages: [Add Your Website]

Post New Topic

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

Web Hosting Support

#1941 1

you can use count, for example i use this code in php:

PHP CODE:

$sql2 = "select count(id) from users";
$result2 = mysql_query($sql2 ,$db);
$row = mysql_fetch_row($result2);
$UserCount= $row[0];
echo"number of users: $UserCount<br>";

Aug 22, 2009 Reply Report abuse