I need to make this code show if a specific gm is online.
Example: this code need to show if only [GM]TEST is online.
I can't figure it out because i don't know php programing.
<?php
$busca_equipe = mssql_query("SELECT * FROM character.dbo.user_character WHERE login_flag = 'N'");
for($i=0;$i<mssql_num_rows($busca_equipe);$i++) :
if($i == 0) :
$first = 'class="first"';
else :
$first = '';
endif;
$resgata_equipe = mssql_fetch_array($busca_equipe);
$busca_online_equipe = mssql_query(" SELECT * FROM account.dbo.USER_PROFILE WHERE login_flag = '1100'");
if(mssql_num_rows($busca_online_equipe) > 0):
$equipe_status = '<font color="green"><strong>Online</strong></font>';
else :
$equipe_status = '<font color="red"><strong>Offline</strong></font>';
endif;
echo '<li '.$first.'>'.$resgata_equipe["character_name"].' - '.$equipe_status.'</li>';
endfor;
?>