Jump to content
Fórum Script Brasil
  • 0

Ajuda IImprimir dados


403Forbidden

Question

Boa tarde a todos

Estou querendo imprimir dados de 4 tables, que se encontram em 4 databases

no caso a CT (ClanDB)

usuarios online no momento

dessa deve pegar CHName

AllPersonalMember (accountdb)

mostra Cidade da pessoa

dessa deve pegar CUserName2

LevelList (Rptb) mostra nivel e classe do personagem

dessa deve pegar charlevel + charclass

De modo que so apareça na lista quem estiver online -> CT (ClanDB), e complementando com os outros dados das outras 2 tabelas -> AllPersonalMember (accountdb) e LevelList (Rptb)

tenho essa script como base, mas ela so mostra o nome do personagem:

<style type="text/css">

<!--

.style1 {color: #FF0000}

-->

</style>

<?

include "incluir/functions.php";

$query = "SELECT * FROM [ClanDB].[dbo].[CT] WHERE [userid] <> '' ";

$q = odbc_do($connection,$query);

$total = AcertarLinhasODBC($connection,$query);

?>

<table width="499" border="0" align="center" cellpadding="0" cellspacing="0" class="boxTable2">

<tbody>

<tr>

<td width="499" height="74" class="boxTitle2">Players Online

</tr>

<tr>

<td height="91" align="center" class="boxContent2">No total h&agrave; <b><?=$total?></b> players online no servidor;<br />

<br>

<?

while(odbc_fetch_row($q)){

$nick = odbc_result($q,"ChName");

?>

O player <b><?=$nick?></b> est&aacute; online! </br>

<?

}

?>

<br></td>

</tr>

<tr>

<td width="499" height="10" background="-imgs/23.gif">&nbsp;</td>

</tr>

</tbody>

</table>

<? } ?>

e gostaria que fossem imprimidos os valores dentro de uma tabela, se possivel, exemplo:

Nick Classe Level Cidade

Admin Pikeman 150 Florianópolis

Admin2 Fighter 150 São Paulo

imagens das tables:

www.friendspt.com.br/files/sql/accountdb.jpg

www.friendspt.com.br/files/sql/clan.jpg

www.friendspt.com.br/files/sql/rptb.jpg

agradeço desde já, meu MSN é suporte@live.ru

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Forum Statistics

    • Total Topics
      152.2k
    • Total Posts
      652k
×
×
  • Create New...