SELECT Count php/sql

Question

I am trying to store a mysql value into a php variable. I have the following query which I know works. However, I the value for $count is always 0. Can someone explain what I need to do to get the count value? The count should be the count of x's w here name_x=.$id.

$query = "SELECT COUNT(name_x) FROM Status where name_x=.$id.";
$result = mysql_query($query);
$count = $result;

You want to retrieve the results using mysql_result on $result. See: php.net/manual/en/function.mysql-result.php — rjz
– rjz, Commented Mar 3, 2012 at 5:10
the problem is in COUNT(x).. just use COUNT(*). Also I believe id is INT... — Fahim Parkar
– Fahim Parkar, Commented Mar 3, 2012 at 5:13
@rjz: when I try to set $count = mysql_result($result,0), I don't get back any values for count. — Johanne Smith
– Johanne Smith, Commented Mar 3, 2012 at 5:26

user319198 · Accepted Answer · 2012-03-03 05:18:16Z

1

Is first letter in table name is really capital. Please check it first.

or Try :

    $query = "SELECT COUNT(*) as totalno FROM Status where name_x=".$id;
    $result = mysql_query($query);
    while($data=mysql_fetch_array($result)){
    $count = $data['totalno'];
    }
echo $count;

answered Mar 3, 2012 at 5:18

user319198

Sign up to request clarification or add additional context in comments.

3 Comments

Johanne Smith Over a year ago

Yes, the first label in the table is really capital. I tried your suggestion to no avail and I even tried the following and it gave the error EXPECTS PARAMETER 1 TO BE RESOURCE, BOOLEAN GIVEN:$query = "SELECT name_x FROM Status where name_x=.$id."; $result = mysql_query($query); $count = mysql_num_rows($result);

user319198 Over a year ago

EXPECTS PARAMETER 1 TO BE RESOURCE, BOOLEAN GIVEN: I am sure query is not ok. check fields & table name and make sure u are connected to correct database.

Johanne Smith Over a year ago

Thank you Teez, I saw the error, I had the .$id in quotes. Sorry for all of the confusion!

Aaron W. · Accepted Answer · 2012-03-03 05:14:44Z

1

$query = "SELECT COUNT(*) FROM `Status` where `name_x`= $id";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$count = $row[0];

answered Mar 3, 2012 at 5:14

Aaron W.

9,2952 gold badges36 silver badges47 bronze badges

Comments

Riskhan · Accepted Answer · 2012-03-03 05:19:08Z

0

please try it

$query = "SELECT COUNT(*) FROM Status where name_x=$id";
$result = mysql_query($query);
$count = mysql_result($result, 0);

edited Mar 3, 2012 at 5:19

answered Mar 3, 2012 at 5:09

Riskhan

4,48014 gold badges55 silver badges79 bronze badges

1 Comment

Johanne Smith Over a year ago

When I try the Select command in mysql, I get back a result; however, in the php file, I don't get anything back. I have used the * and that doesn't solve the problem either.

CFL_Jeff · Accepted Answer · 2012-03-03 05:46:21Z

0

You are missing single quotes around $id. Should be name_x = '" . $id . "'";

answered Mar 3, 2012 at 5:46

CFL_Jeff

2,7596 gold badges34 silver badges53 bronze badges

Collectives™ on Stack Overflow

SELECT Count php/sql

4 Answers 4

3 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related