SQL QUERY NOT WORKING HELP HELP!!

[newb]

SELECT *,from_unixtime(date,'%Y-%m%-%d') as date1 FROM items WHERE disabled != 1 GROUP BY cat_id WHERE date1 = DATE_SUB(curdate(), INTERVAL 1 DAY)  ORDER BY date desc

 

not working? why?

[msaz87]

Are you getting any kind of error? Is it just not producing any results?

 

One way to check it would be to echo the query to check if everything is feeding into it right:

 

$query = "SELECT *,from_unixtime(date,'%Y-%m%-%d') as date1 FROM items WHERE disabled != 1 GROUP BY cat_id WHERE date1 = DATE_SUB(curdate(), INTERVAL 1 DAY)  ORDER BY date desc";

[Maq]

How is it not working?

[fenway]

not working? why?

First, don't use all caps.

 

Second, try actually checking the error.

 

Third, consult the refman for proper select syntax -- you can't put the where clause after GROUP BY.