Select statement not working

dcjones

Hi all.

Can anyone see what I am doing wrong with this select statement;

"SELECT f_company_name, month(f_date), COUNT(f_baggage) as ct FROM found  GROUP BY MONTH (f_date) WHERE f_company_name = "yes" "

Piranha

You use " signs both for values around yes and for the whole string.

dcjones

Hi Piranha and many thanks for your reply.

I have played around with this for hours.

What I actualy have is a variable $company which I want to use for my filter on the SELECT query.

mysql_select_db($database_bag, $bag);
$query = "SELECT f_company_name, month(f_date), COUNT(f_baggage) as ct FROM bag  GROUP BY MONTH (f_date) "; 
$found = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_assoc($found)) {
    $f_month[] = $row['month(f_date)'];
    $f_count[] = $row['ct'];
}

The results of this query are used in a jpGraph which works fine until I place a WHERE statement in the query.

Can you please advise me.

Piranha

Ok, a quick help, but you have to look in the manual as well. First thing (that I didn't spot before) is that you don't have the parts of the query in the right order. Search the manual and you will find out what order they should be. Second thing is that if you use " sign for the string you should use ' signs for the variables inside.