Counting Rows In Mysql

This Page Contains information about Counting Rows In Mysql By jayos.2010 in category MYSQL with 1 Replies. [2298], Last Updated: Sun Jul 05, 2020

jayos.2010

Sat Aug 22, 2009

1 Comments

291 Visits

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

Web Hosting Support

Sat Aug 22, 2009

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

https://www.webune.com/forums/counting-rows-in-mysql.html

Find Last Entry In Mysql Database

Counting Rows In Mysql

Related Pages