mysql query doesn't work

brux_

hi everyone,

i have a problem related to a MySql code in PHP:

i have the following query:

$query4="SELECT MAX(PSM_ID) AS no_semaines FROM T_PLN_JOUR_PJR WHERE (PAN_ID < 2004 ) GROUP BY PAN_ID HAVING COUNT (*) >= 365 ;";
$result4=mysql_query($query4);

where PSM_ID represents the number of the week in a year( going from 1 to 52 or 53) and PAN_ID represents the year's number(e.g :2002, 2003...)

when i verify the result it gives me nothing and by applying mysql_fetch_array it gives "invalid argument"

if i go directly in my database an i verify the query it works perfectly

can anyone tell me where do I make a mistake?

thanks

brux'

brux_

hi there

actuallly now it works; it was smth about spaces:

the thing i have wrote was:

SELECT MAX( PSM_ID ) AS no_semaines FROM T_PLN_JOUR_PJR WHERE (PAN_ID < 2004) GROUP BY PAN_ID HAVING COUNT( * ) >=365;

and the good one is:
SELECT MAX(PSM_ID) AS no_semaines FROM T_PLN_JOUR_PJR WHERE (PAN_ID < 2004 ) GROUP BY PAN_ID HAVING COUNT (*)>=365;|

thanks anyway

BlueMeteor

Originally posted by brux'
hi there

actuallly now it works; it was smth about spaces:

the thing i have wrote was:

SELECT MAX( PSM_ID ) AS no_semaines FROM T_PLN_JOUR_PJR WHERE (PAN_ID < 2004) GROUP BY PAN_ID HAVING COUNT( * ) >=365;

and the good one is:
SELECT MAX(PSM_ID) AS no_semaines FROM T_PLN_JOUR_PJR WHERE (PAN_ID < 2004 ) GROUP BY PAN_ID HAVING COUNT (*)>=365;|

thanks anyway

For spaces??? incredible......

Ur Mysql 's version?

brux_

really, this is the only thing i have changed;

the fact was that when i've done copy-paste from php file to mysql command line it worked;

when i have tried to print the query and copy-paste the query from the output window into mysql command line it blocked;

i don't really know the reason why it works but now it does

anyway, the mysql version is :MySQL 4.0.13

brux'

PS. i don't know how to close this thread; so if you do, please either tell me, either close it....10x

Ravenous

At the bottom of the thread there is a link titled "Mark this thread resolved." Just click on that bad-boy.