I want to print out the number of records in a MySQL table in my PHP/HTML page.
The SQL is SELECT count(*) from tablename but how do I then get that into a PHP variable. I am used to looping through rows, but inthis case there is 1 row and what would the field name be?
