need help to finish this!!!!

[buladex]

on site page i made this :

 

Rank 	Name  	Wons  	Lost
1. 	Alexutzu 	0047 	
2. 	test145[PM] 	0001 

 

 

script for that is:

 

<tr>
    <td width="*" align="center">Rank</td>                                       
    <td width="*" align="center"><font color="#000000">Name</td>
    <td width="*" align="center"><font color="#000000">Wons</td>
<td width="*" align="center"><font color="#000000">Lost</td>

  </tr>
  
<?php				
$rank = mysql_query('SELECT player_name,data FROM xxxx WHERE event_type= 971'
      .' ORDER by data desc LIMIT '.$limit.';');
$i=1;
while ($row = mysql_fetch_array($rank)) {
	echo '<tr><td align="center">'.$i.'.</td>
      <td align="center"><font color="#0000FF">'.$row['player_name'].'</td>
      <td align="center"><font color="#FF0080">'.$row['data'].'</td>
[u]HERE i need lost table which is same as win only event_type= 972 how i do that??[/u]

    </tr> ';
    $i++;
    }

 

so i need lost table!!!

 

 

 

[Mchl]

SELECT w.player_name,w.data AS won, l.data AS lost FROM xxxx AS w CROSS JOIN xxxx AS l USING (player_name) WHERE w.event_type= 971 AND l.event_type = 972

[buladex]

is that to replace rank sql select?

 

[buladex]

not working so far , i replaced it and i get error at :

 

   while ($row = mysql_fetch_array($rank)) {

 

in:

 

<?php				
$rank = mysql_query('SELECT w.player_name,w.data AS won, l.data AS lost FROM cq_statistic AS w CROSS JOIN cq_statistic AS l USING (player_name) WHERE w.event_type= 971 AND l.event_type = 972'
      .' ORDER by data desc LIMIT '.$limit.';');
$i=1;
while ($row = mysql_fetch_array($rank)) {
	echo '<tr><td align="center">'.$i.'.</td>
      <td align="center"><font color="#0000FF">'.$row['player_name'].'</td>
      <td align="center"><font color="#FF0080">'.$row['data'].'</td>


    </tr> ';
    $i++;
    }

[fenway]

What error?

[buladex]

error on this line :

 

 while ($row = mysql_fetch_array($rank)) {

 

 

i think now it cant be

ORDER by data

cuz both win and lose are data

[Mchl]

Indeed you think correct. It needs to be

ORDER BY w.data

or

ORDER BY l.data

 

See this tutorial: http://www.phpfreaks.com/tutorial/debugging-a-beginners-guide/page1

for hints on how to get useful error messages from MySQL

[buladex]

acctualy right is w.data but still not working, got no error but doesnt show won and lost points:

 

 

<?php				
$rank = mysql_query('SELECT w.player_name,w.data AS Won, l.data AS Lost FROM xxxx AS w CROSS JOIN xxxx AS l USING (player_name) WHERE w.event_type= 971 AND l.event_type = 972'
      .' ORDER BY w.data desc LIMIT '.$limit.';');
$i=1;
while ($row = mysql_fetch_array($rank)) {
	echo '<tr><td align="center">'.$i.'.</td>
      <td align="center"><font color="#0000FF">'.$row['player_name'].'</td>
      <td align="center"><font color="#FF0080">'.$row['data'].'</td>

    </tr> ';
    $i++;
    }
?>

 

 

[Mchl]

Because you're not displaying those.

 

<td align="center"><font color="#FF0080">'.$row['Won'].'</td>
<td align="center"><font color="#FF0080">'.$row['Lost'].'</td>

[buladex]

i am all script:

 

<div align="center"><font color="#FF0000", size="5px"><b> Top Arena</b></div>

<table<?php echo $tableSet; ?>>
  <tr>
    <td width="*" align="center">Rank</td>                                       
    <td width="*" align="center"><font color="#000000">Name</td>
    <td width="*" align="center"><font color="#000000">Won</td>
<td width="*" align="center"><font color="#000000">Lost</td>

  </tr>
  
<?php				
$rank = mysql_query('SELECT w.player_name,w.data AS Won, l.data AS Lost FROM xxxx AS w CROSS JOIN xxxx AS l USING (player_name) WHERE w.event_type= 971 AND l.event_type = 972'
      .' ORDER BY w.data desc LIMIT '.$limit.';');
$i=1;
while ($row = mysql_fetch_array($rank)) {
	echo '<tr><td align="center">'.$i.'.</td>
      <td align="center"><font color="#0000FF">'.$row['player_name'].'</td>
      <td align="center"><font color="#FF0080">'.$row['data'].'</td>
      <td align="center"><font color="#FF0080">'.$row['Won'].'</td>
     <td align="center"><font color="#FF0080">'.$row['Lost'].'</td>

    </tr> ';
    $i++;
    }
?>
                                                        </tbody></table></td>

 

 

[buladex]

yes u right i found 1 bug ty ill reply whit result

 

[buladex]

my old script shows this whit 'won' table only which is corect:

 

 

Rank 	Name  	Won
1. 	SPIU[PM] 	0003
2. 	~*CaTHLeeN*~ 	0001

 

whit new script shows :

 

Rank 	Name  	Won 	Lost
1. 	~*CaTHLeeN*~ 	0001 	0001

 

which is corect by points but where is real rank 1 player????????

 

 

[buladex]

yes!!! i know why cuz SPIU[PM]has 0 lost!!! so how i do to show 0 on lost??? cuz far as i see script aint gone show if u have 0 lost

[Mchl]

Ok, so let's do it so it will display when the player has no wins too:

 

SELECT 
  p.player_name, IFNULL(w.data,0) AS won, IFNULL(l.data,0) AS lost 
FROM (
  SELECT DISTINCT player_name FROM xxxx WHERE event_type IN (971,972)
) AS p
LEFT JOIN (
  SELECT player_name, data FROM xxxx WHERE event_type = 971
) AS w USING (player_name)
LEFT JOIN (
    SELECT player_name, data FROM xxxx WHERE event_type = 972
) AS l USING (player_name)

 

 

[buladex]

not working pfff and i see in script u put won whit 0 also that aint needed

this rank depends on won so it cant be 0 but far as we made the script if the player has wins but lost = 0 wont show him in rank

 

 

[Mchl]

Use mysql_error to check if something's wrong with tje query

 

$rank = mysql_query('SELECT ...') or die(mysql_error());

[buladex]

hehe found a simple and easy solution ty for all ur help  +1 k from me