Help
Spent HOURS on this and cannot see the problem.
It will display the country but not the number of clients that are within that country???
<?php
//Retrieve the "count" for the number of people in the specified country
$country= $_POST['totalbycountry'];
//Connect to the server...$connect will contain the connection object
$connect = mysql_connect("localhost:3636", "root","");
//Connect to the relevant Database
$db=mysql_select_db("census",$connect);
//Set up the SQL statement in a variable with a WHERE clause
$query="SELECT count(*) FROM stats WHERE BirthCountry = country";
//Perform the SQL query against the database
$result=mysql_query($query);
echo "The total number of people who were born in " .$country ;
?>