I'm using the following to count how many records are in a table: <BR><BR>"SELECT COUNT(*) FROM facts_tips WHERE type = 'country'" <BR><BR>Now, here's the dumb question.. How do you display the results???? <BR><BR>I want this script to count the number of particular records in a table, then use that value later on in the script.<BR><BR>Ex: Const Records = (?????)<BR><BR>Any help would be appreciated. I know there is a simple answer to this.. I just don't know what it is... Hopes this makes sense..<BR><BR>THANKS!!!!