Where do I add the WHERE Statement in the SQL?

whobutsb

I have this SQL Statement:

$query = "SELECT food_quality, COUNT(food_quality) as cnt FROM surveyData GROUP BY food_quality";

But I want to filter the results even further with a variable that is passed from the previous page. Here is the statement I want to add:

WHERE `bizID`='$imagenum'

I'm unfamilar with the formatting SQL queries and the couple of places I tried gave me error messages.

Thanks for the help!

Piranha

I suggest that you do a few SQL tutorials to learn the basics about SQL. And look in the manual to find answers. Without that you will get in trouble a lot.

But I will still help you out with this query:

$query = "SELECT food_quality, COUNT(food_quality) as cnt FROM surveyData WHERE `bizID`='$imagenum' GROUP BY food_quality";

You should check out [man]mysql_real_escape_string[/man] to avoid database injection.

whobutsb

I already tried placing the WHERE statement in that place but retrieved no values😕

This is how i'am assigning the variable $imagenum

$imagenum = $HTTP_GET_VARS['key'];

Its really odd that it isn't grabbing that variable to filter the results.

Piranha

First that way is a pretty old way to grab a variable. Use $GET and $POST instead. Does it output something when you echo the variable? Does the query work if you print it and then use it in another program, like phpmyadmin for mysql?

whobutsb

I have overlooked something. I have two .php files one is called results.php and it is getting passed a variable that indicates the business unit. Then I have another .php file called chartdata.php (This is the one I have been working on, and is embedded in results.php), this file is not getting passed the variable so it is just turning up blank results for that reason.

I guess my question now is how do pass that variable to the chartdata file? Would a Superglobal work or is that only for the same .php document.

BTW I really appreciate your help and your patience.

Piranha

I'm sorry, but I can't help you with that question. I think that some setting in php.ini can be changed to allow it, or you can use a global. But I don't know for sure, so it is better that I won't say anything.