[SOLVED] Counting Down Using Table Entry Number

[sintax63]

I am trying to set up a "Only XX To Go!" on my web page counting down from the number 101 against the number of entries in my table. For instance, I currently have 7 entries in my table so I would like it to say "Only 94 To Go!"

 

Would anyone be able to help me out or point me in the right direction for this?

 

Thanks in advance,

Abraham

[fenway]

Well, the number 101 is arbitrary -- so you know it -- a COUNT(*) will give you other #.

[sintax63]

I figured this out yesterday shortly after Fenway gave me that tip:

 

$count 	= mysql_result(mysql_query("SELECT COUNT(*) FROM field"),0);
$total 	= 101;
$number	= $total - $count;

 

... and then in my HTML:

 

Only <?php echo "$number"; ?> To Go!