PHP - Simple Sql Count Question

Looke on the PHP manual for the "count" function and it has confused me.

it seems to count arrays more than anything.

i have a small site and i wanted to display how many items are contained within a Database table.

for example i want it to count the amount of users are in the user table.

and i then need to echo that amount + 100.

Can someone help me with the code.

i have already included a database connect script within the header of the page with includes etc.

Help would be appreciated. but i would like to know how the code works else i will never learn. 

I'm trying to work out a count of how many of what assets are in a certain location:
there should be 13 different categories (asset types) in a location and i want the individual count of each category. here's what i have - which seems to give me a total count of all assets and locations together plus one asset description and one location.....
almost right.

Code: [Select]
$con = mysql_connect('localhost','root','');
  if(! $con) die(mysql_error());
mysql_select_db("test",$con);
$result = mysql_query("SELECT DISTINCT COUNT(`Asset Description`) AS TOTALAD, LOCATION, `Asset Description` AS AD FROM master WHERE LOCATION like 'NC%'");



while($row = mysql_fetch_array($result))
  {
  echo $row["LOCATION"];
   echo "<br />";
  echo $row["TOTALAD"];
   echo "<br />";
  echo $row["AD"];
  echo "<br />";
  }
mysql_close($con);

I have a field in my MySQL DB that holds numbers separated by a comma (example: 1, 3, 45, 137, 87). I simply want to get a count of how many numbers are in there. (Using my example the result would be 5). I'm sure this is a simple question but I don't know how. I'm able to extract the numbers but I can't get the count to read anything other than 1. Can anyone help?

Hi All,
The following code works but for some reason it is leaving 1 result off of each page when displaying results from DB. I assume there is something wrong with the count but I cannot find the problem.

Thank you for any help.

Code: [Select]

<?php   
         
$page = $_GET['page'];

$result2 = mysql_query("SELECT * FROM vendors WHERE vendor_type_id = '$vdrt' AND active ='Yes' ORDER BY RAND()");
$total_results = mysql_num_rows($result2); 
   
if (empty($total_results)) {echo "Sorry, but we do not have any results for that search at this time. <br/><br/><a href='index.php'>Please try your search again</a>";} 

else {
 
$total_pages = ceil($total_results / $results_limit); // $results_limit is set to 7 in config file
if (empty($page)) 
    { 
        $page = "1"; 
    } 
$offset = ($page - 1) * $results_limit;
 
$result = mysql_query("SELECT * FROM vendors WHERE vendor_type_id = '$vdrt' AND active ='Yes' LIMIT $offset, $results_limit") or die ("$DatabaseError"); 
 
$row = mysql_fetch_assoc($result);
$vendor_type_id = $row['vendor_type_id'];
$num = mysql_numrows($result); 
  if ($num == 0) : 
  print "<br><br><p>Sorry, no vendors could be found.</p><br><br>"; 
  
  elseif ($num > 0) :

echo "Page - "; 
if ($page != 1) 
{ 
echo "<a href=$PHP_SELF?city=Orlando&state=FL&vdrt=$vendor_type_id&page=1><< First</a>&nbsp;&nbsp;&nbsp;"; 
$prevpage = $page - 1; 
} 
        if ($page == $total_pages) 
            { 
                  $to = $total_pages; 
            } 
        elseif ($page == $total_pages-1) 
            { 
                  $to = $page+1; 
            } 
        elseif ($page == $total_pages-2) 
            { 
                  $to = $page+2; 
            } 
        else 
            { 
                  $to = $page+3; 
            } 
        if ($page == 1 || $page == 2 || $page == 3) 
            { 
                  $from = 1; 
            } 
        else 
            { 
                  $from = $page-3; 
            } 
             
for ($i = $from; $i <= $to; $i++) 

    { 
    if ($i == $total_results) $to=$total_results; 
    if ($i != $page) 
        { 
        echo "<a href=$PHP_SELF?city=Orlando&state=FL&vdrt=$vendor_type_id&showold=yes&page=$i>$i</a>"; 
        } 
    else 
        { 
        echo "<b><span class='current-page'>[$i]</span></b>";

        } 
    if ($i != $total_pages) 
        echo "&nbsp;"; 
    } 
if ($page != $total_pages) 
{ 
$nextpage = $page + 1; 

echo "&nbsp;&nbsp;&nbsp;<a href=$PHP_SELF?city=Orlando&state=FL&vdrt=$vendor_type_id&page=$total_pages>Last >></a>";
}
 if ($num == 0)  { echo "<br><br>";} else {echo "<br><br>";}

    $i = 0; 
    while ($i < $num) : 

        while ($row = mysql_fetch_assoc($result)) {
            $vdrid = $row['vendor_id'];
$vendor_name = $row['vendor_name'];
$vendor_name_enc = urlencode($row['vendor_name']);
$vendor_city = $row['vendor_city'];
            $vendor_state = $row['vendor_state'];
$vendor_phone = $row['vendor_phone'];
$vendor_overview = $row['vendor_overview'];

// Trim overview
if(strlen($vendor_overview) > 385) {$trimed_vendor_overview = substr($vendor_overview,0,385) . "...";
} else {
$trimed_vendor_overview = $vendor_overview;
}

            echo "<strong><a href='listing.php?$vendor_name_enc-$vendor_city-$vendor_state-&vdrid=$vdrid'>$vendor_name</a> </strong> - $vendor_city, $vendor_state $vendor_phone<br/>";           
echo "$trimed_vendor_overview<br/><br/>";
        }


        $i++; 
    endwhile; 

  endif;
  

}

?>

I need to add a condition to a while() statement I have. It should run when $counter is less than the number of records in  my $products array which has 5 products. I set  $counter  and  $product_no to 0.
I need to use the count() function to get the number of records.  Does that make sense? Do ya'll need more info. Any help is Greatly appreciated. Ive referenced and searched but cant figure out how to incorporate it. Im still learning. 
Peace,
Skrappy