<?php $sql = "SELECT COUNT(*) AS Total FROM products"; $query = mysql_query($sql); $data=mysql_fetch_array($query); echo $data['Total']; ?>
You could throw some code around it to make it output:
Currently carrying XXXX products
<!-- Product Count --> <center> <font style="font-family: Verdana; font-size: 12px; font-weight: bold; text-align: center;"> Currently carrying <font style="background-color: #CCCCCC;"> <?php $sql = "SELECT COUNT(*) AS Total FROM products"; $query = mysql_query($sql); $data=mysql_fetch_array($query); echo $data['Total']; ?> </font> titles </font> </center> <!-- Product Count -->









