Ad:

PHP Discussion Thread
Unsolved
Views: 642

Nov 7th, 2008

problem with count and displaying result

Expand Post »

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 Syntax (Toggle Plain Text)
<?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 ;
 
?>
<?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 ;

?>

Last edited by peter_budo; Nov 8th, 2008 at 6:58 pm. Reason: Correcting tags, please use [code] not <code>

Similar Threads

PHP MYSQL Paging Problem in PHP
Problem of abruptly termination... in C++
pagination not displaying results in PHP
How to export data from mysql into fields in excell in PHP
simple cash register (pos) problem - please help!! in VB.NET

castlelaker

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

Permalink

Nov 8th, 2008

Re: problem with count and displaying result

hello..see this:

PHP Syntax (Toggle Plain Text)
$query="SELECT count(*) as c FROM stats WHERE BirthCountry = country";
 
//Perform the SQL query against the database
 
$result=mysql_query($query);
$row=mysql_fetch_array($result);
echo $row['c'];
$query="SELECT count(*) as c FROM stats WHERE BirthCountry = country";

//Perform the SQL query against the database

$result=mysql_query($query);
$row=mysql_fetch_array($result);
echo $row['c'];

i don't know the query for counting no.of clients...but the above is the correct syntax...if this is not correct,post your table structure..
thank you.

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Nov 9th, 2008

Re: problem with count and displaying result

Click to Expand / Collapse Quote originally posted by Shanti Chepuru ...

hello..see this:
PHP Syntax (Toggle Plain Text)
$query="SELECT count(*) as c FROM stats WHERE BirthCountry ='country'";
 
//Perform the SQL query against the database
 
$result=mysql_query($query);
$row=mysql_fetch_array($result);
echo $row['c'];
$query="SELECT count(*) as c FROM stats WHERE BirthCountry ='country'"; //Perform the SQL query against the database $result=mysql_query($query); $row=mysql_fetch_array($result); echo $row['c'];
i don't know the query for counting no.of clients...but the above is the correct syntax...if this is not correct,post your table structure..
thank you.

Thanks
This work fine if you put single quotes around 'country'.
If you dont no result is displayed
Thanks again
Castlelaker

castlelaker

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

Permalink

Nov 11th, 2008

Re: problem with count and displaying result

Click to Expand / Collapse Quote originally posted by castlelaker ...

Thanks
This work fine if you put single quotes around 'country'.
If you dont no result is displayed
Thanks again
Castlelaker

This should be the correct statement I suppose:

php Syntax (Toggle Plain Text)
$query="SELECT count(*) FROM stats WHERE BirthCountry = ".$country." ;";
$query="SELECT count(*) FROM stats WHERE BirthCountry = ".$country." ;";

Regards.

Last edited by peter_budo; Nov 12th, 2008 at 5:22 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

sasankasekhar

Reputation Points: 10

Solved Threads: 3

Newbie Poster

Offline

24 posts
since Jan 2007

Permalink

Nov 11th, 2008

Re: problem with count and displaying result

PHP Syntax (Toggle Plain Text)

 
$query="SELECT count(*) as c FROM stats WHERE BirthCountry ='$country'";

jyothi chundi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: anti spam contact form

Next Thread in PHP Forum Timeline: Semi-automated email script

DaniWeb Message

Cancel Changes

User Name
Password