SQL Query

[Kavvson]

I know its wrong but how to make it working.

$v1 = $SQL->query ('SELECT COUNT(*) as `vocation` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') WHERE `vocation`=1;')->fetch();

 

[koob]

SELECT COUNT(*) as `vocation` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') [COLOR="red"]AND[/COLOR] `vocation`= 1;

What u need exactly ?

 

[Kavvson]

Counting vocations in a guild


@Thanks your script work properly.

Btw check my other topic bit lower if you are a good sql mate

 

[koob]

Try that @up query - should work.