[RELEASE] Get guild name from character_name (PHP)

[janvier123]

i hope you get it

[pieter]

how about shorter with one qry?

SELECT guild_name 
from character..guild_info 
where guild_no in
(
 select guild_no 
 from character..guild_char_info 
 where character_no in
   (
     select character_no 
     from character..user_character 
     where character_name = 'CharNameHere'
    )
)

[janvier123]

its the same result

[pieter]

jep just 1 query instead of 2

[daddycool.]

Same results, different ways... both works well. Thanks.

[҉ THT ҉]

javier12 is back and I can see [RELEASE] everywhere again,, that makes my happy