Ir para conteúdo
Fórum CódigoFonte.net
Entre para seguir isso  
Fork

Nao mostrar dados repetidos

Recommended Posts

eu queria que meu resultado da busca nao aparecece resultado com o mesmo nome...apenas 1

vou postar meu select

if($rank == "TopSoD50") {

$total = mssql_query("SELECT * FROM SOD2RecBySandurr ORDER BY Point");

$tr = mssql_num_rows($total);

$tp = $tr / $cfg['rank'];

$tp = ceil($tp);

$ant = $pg-1;

$pro = $pg+1;

$verifica = mssql_query("SELECT TOP 50 * FROM SOD2RecBySandurr ORDER BY Point DESC ");

uso sql server 2005

Compartilhar este post


Link para o post
Compartilhar em outros sites

Ja respondido no forum do PHP

if($rank == "TopSoD50") {

$total = mssql_query("SELECT DISTINCT * FROM SOD2RecBySandurr ORDER BY Point");

$tr = mssql_num_rows($total);

$tp = $tr / $cfg['rank'];

$tp = ceil($tp);

$ant = $pg-1;

$pro = $pg+1;

$verifica = mssql_query("SELECT TOP 50 DISTINCT * FROM SOD2RecBySandurr ORDER BY Point DESC ");

Compartilhar este post


Link para o post
Compartilhar em outros sites

Join the conversation

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

Visitante
Responder

×   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.

Processando...
Entre para seguir isso  

×
×
  • Criar Novo...