I want to count the amount of pilots in the database and echo them into a field. How do I add this to my query and echo it?
<? include 'db.php'; $query_pilots = "SELECT * FROM user_profile"); $pilots = mysql_query($query_pilot) or die(mysql_error()); $row_pilots = mysql_fetch_assoc($pilots); ?>
The field name in the database for the pilots is “UserName”
Other echo's in my table include
<?php echo $row_pilots['Email']; ?>for the pilots email address
Any help would be much appreciated