[MySQL][HTML][PHP]Sortowanie roznych wynikow w tabeli Opcje

[yellow7]

Prosze o pomoc mam zrobiona tabelke do ktorej wstawiam rozne dane z obecnego miesiaca kod jak ponizej. Dostaje jako wynik tabelke pokolorowana na przemian chcialbym w niej sortowac wiersze po polu Profit i nie bardzo mam pomysl jak sie za to zabrac. Problem mam z tym ze te dane ktore wstawiam do tabeli wynikiem jakiegos dzialania i nie moge pobrac ich w calosci jako tabele i formatowac.

Jestem jeszcze za cienki zeby to ogarnac. Prosze o pomoc.

[PHP] pobierz, plaintext 
<table class="hor-zebra" summary="Employee Pay Sheet">
 
 
<thead>
 
<tr>Individual tipster </tr>
    	<tr>
        	<th scope="col">Tipster</th>
            <th scope="col">Won</th>
            <th scope="col">Lost</th>
            <th scope="col">Void</th>
		<th scope="col">Profit</th>
		<th scope="col">Yield</th>
 
        </tr>
 
</thead>
 
<tbody>
 
    	<tr class="odd">
        	<td>BAROS</td>
            <td>
 
		<?php
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK>0 AND TYPER='BAROS'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?>  
 
		</td>
 
		<td>
 
		<?php
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK<0 AND TYPER='BAROS'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?> 
 
		</td>
            <td>
 
		<?php
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK=0 AND RESULT!=' ' AND TYPER='BAROS'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?> 
 
		</td>
		<td>
 
		$query = "SELECT SUM(WYNIK) AS SUMA FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK IS NOT NULL AND TYPER='BAROS'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?>
 
		</td>
 
		<td>
		%
		</td>	
        </tr>
 
 
        <tr class="even">
        	<td>LIQUIDFISH</td>
            <td>
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK>0 AND TYPER='LIQUIDFISH'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?>  
 
		</td>
 
		<td>
 
		<?php
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK<0 AND TYPER='LIQUIDFISH'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?> 
 
		</td>
            <td>
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK=0 AND RESULT!=' ' AND TYPER='LIQUIDFISH'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?> 
 
		</td>
		<td>
 
		$query = "SELECT SUM(WYNIK) AS SUMA FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK IS NOT NULL AND TYPER='LIQUIDFISH'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?>
 
		</td>
 
		<td>
		%
		</td>	
        </tr>
 
        <tr class="odd">
        	<td>GEORGISD</td>
            <td>
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK>0 AND TYPER='GEORGISD'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?>  
 
		</td>
 
		<td>
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK<0 AND TYPER='GEORGISD'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?> 
 
		</td>
            <td>
 
		$query = "SELECT COUNT(*) AS TYPY FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK=0 AND RESULT!=' ' AND TYPER='GEORGISD'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?> 
 
		</td>
		<td>
 
		$query = "SELECT SUM(WYNIK) AS SUMA FROM TYPY WHERE DATA>=DATE_ADD(curdate(), INTERVAL -(DAYOFMONTH(curdate())-1) DAY) AND WYNIK IS NOT NULL AND TYPER='GEORGISD'";
		$result = mysql_query($query);
		echo mysql_result( $result, 0) ;
		}
		?>
 
		</td>
 
		<td>
		%
		</td>	
        </tr>
 
    </tbody>
</table>
 
[PHP] pobierz, plaintext 

Ten post edytował yellow7 17.01.2011, 15:29:59