I have a status table which can hold the values sold or selling, I want to do a count of how many items are currently selling and produce an integer as a result.
EX:
Items Selling: 3
Here is the start of my query:
Code: Select all
$result = mysql_query("SELECT bookmark, COUNT(*) as ??? FROM status WHERE status='selling' ");
echo "Items Selling: ???";