How to get mysql db result where `world_id` = '.$world_id.'; on php?

Question

I have these mysql tables:

---

(players):

(environment_killers):

(killers):

(player_deaths):

---

And a PHP page that prints this result:

$timenow = time();  
$dayago = $timenow - (86400 * 1);

$monstrums= $SQL->query('SELECT * FROM z_monsters GROUP by name;');

$killers_monsters = mysql_query('
    SELECT COUNT(name) as liczba 
    FROM environment_killers,player_deaths,killers 
    where player_deaths.id = killers.death_id 
        and killers.id = environment_killers.kill_id 
        and name LIKE "%'.$monstrums[name].'" 
        and date > '.$dayago.';');

---

I need this PHP page to print the $killers_monsters result where player_deaths.player_id = players.id and players.world_id = '.$world_id.'

Answer 1

Let me guess, this is an open Tibia server? XD

Anyway, here you go (assuming your query is correct):

if($killers_monsters == true) {
    if(mysql_num_rows($killers_monsters) > 0) {
        while($row = mysql_fetch_object($killers_monsters)) {
            echo "Total count: " . $row->liczba . "<br />";
        }
    } else {
        echo "Total count: 0.<br />";
    }
} else {
    echo "An error occured! Total count: 0.<br />";
}