[SOLVED] Query Help

[ballouta]

Hello

 

i have this query:

SELECT * FROM `links` where `event` ='smthg'

 

i tried to get a count value in the same query but it was wrong:

SELECT COUNT(*) AS MD, * FROM `links` where `event` ='smthg'

 

what is the correct query?

 

Thank you

[Ken2k7]

SELECT *, COUNT(*) AS `MD` FROM `links` WHERE `event` = 'smthg';

[ballouta]

I got this error:

 

#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

[ballouta]

thanks I googled for the error I got and i have to add group by:

 

http://dev.mysql.com/doc/refman/5.1/en/counting-rows.html