$query = "SELECT count(*) problem(easy?)

[kikki]

Hi guys,
I need help in counting the rates from mysql. Any help would be appreciated.

There is a table called: rates, vote_for is a row to whom the votes goes to and votez is a row where are the votes.

Now I'm trying to count all the 'cool' named votes from selected user.
(I'm sorry if I'm not very clear enough..)

$query = "SELECT count(*) AS countrates FROM rates WHERE vote_for = '$getpicture_owner' 
( SELECT '$getpicture_owner' FROM rates WHERE votez = 'cool' ) ";

this code is bringing some line errors(the line where I try to select the row).. 🙁

thanks in advance

[Frederick]

You can not use a simple query inside of a count query. The count query only retrieves a count of the results and not any arrays.

[kikki]

Originally posted by Frederick
You can not use a simple query inside of a count query. The count query only retrieves a count of the results and not any arrays.

Thanks, I know my counting is wrong thatswhy it didn't work, I need some help on counting specific votes from selected user, vote_for row hold all the members names and $getpicture_owner got the member name assigned, so what I'm trying to do is to see how many 'cool' named votes that member got from 'votez' table.

thanks in advance