really need help in counting entered name in mysql for php

[kinesh18]

hi everyone.i really need help on how to count a field from mysql.its my first time doing it just a little sample will help..tanx2...

[thebadbad]

Count a field? Like .. 1?

Elaborate.

[unknown1]

Here is an example

 

//select info from database
$sql = "SELECT * FROM tableName  some condition ";
// error if you have a problem
$resultSet = mysql_query($sql) or die (mysql_error());

// Check if info exists in database
if(mysql_num_rows($resultSet) > 0) {

// if selected info exists
while($row = mysql_fetch_array($resultSet))
{
echo "$row[fieldName]";
}

 

Hope it helps

[unknown1]

or you may want something like

 

$totalCount = "SELECT COUNT(*) as 'Total' FROM tabeName";
$lCount = mysql_query($totalCount) or die(mysql_error());
$rowCount = mysql_fetch_object($lCount);