hola ferbux ..tanto tiempo....mira
aca hao la consulta
Código PHP:
<?
include "link.php";
$dblink=MYSQL_CONNECT($MySqlHostname, $MySqlUsername, $MySqlPassword);
$sql6 = "SELECT DISTINCT PO.NOMBRES, PO.PATERNO, PO.TIENEPATROCINIO, PO.RUT, PO.DV, PO.MATERNO, TP.TP_IDENPOST , TP.TP_PTPS, TP.TP_PPS, TS.TS_IDENTPOST , TS.TS_TRES, TS.TS_TRMA, TS.TS_TRVE, TS.TS_TRME, TS.TS_N, TS.TS_PTS, TS.TS_PS FROM TEST_PRESELECCION22 AS TP, POSTULANTE AS PO, TEST_SELECCION AS TS WHERE ((TP.TP_IDENPOST=PO.RUT) AND (TS.TS_IDENTPOST=PO.RUT)) ORDER BY PO.PATERNO, PO.MATERNO DESC LIMIT $Limit_Post";
$query6 = @mysql_query($sql6, $dblink);
$shtml="<table>";
$shtml=$shtml."<td>Correlativo</td><td>A. Paterno</td><td>A. Materno</td><td>Nombres</td><td>RUT</td><td>DV</td>";
$shtml=$shtml."<tr>";
//echo "PATERNO MATERNO NOMBRES | PTPS | PPS | TRES | TRMA | TRVE | TRME | TPers | PTS | PS ";
while ($row = mysql_fetch_array($query6))
{
$num=$num+1;
$TP_PTPS = number_format($row['TP_PTPS'], 2);
$TP_PPS = number_format($row['TP_PPS'], 3);
$NOMBRES = $row['NOMBRES'];
$RUT = $row['RUT'];
$DV = $row['DV'];
$PATERNO = $row['PATERNO'];
$MATERNO = $row['MATERNO'];
$TIENEPATROCINIO = $row['TIENEPATROCINIO'];
$TS_TRES = number_format($row['TS_TRES'], 2);
$TS_TRMA = number_format($row['TS_TRMA'], 2);
$TS_TRVE = number_format($row['TS_TRVE'], 2);
$TS_TRME = number_format($row['TS_TRME'], 2);
$TS_N = $row['TS_N'];
$TS_PTS = number_format($row['TS_PTS'], 3);
$TS_PS = number_format($row['TS_PS'], 3);
$TP_IDENPOST=$row['TP_IDENPOS'];
$TS_IDENTPOST=$row['TS_IDENTPOST'];
if ( $num <= 224 )
{
echo '<td bgcolor="#c0c0c0"><div align="center"><font face="Tahoma" size="1" color="#000000">'.$num.'</font></div></td>';
}
if ( $num > 224 )
{
echo '<td><div align="center"><font face="Tahoma" size="1" color="#000000">'.$num.'</font></div></td>';
}
echo '<td><div align="left"><font face="Tahoma" size="1" color="#000000">'.$PATERNO.'</font></div></td>';
echo '<td><div align="left"><font face="Tahoma" size="1" color="#000000">'.$MATERNO.'</font></div></td>';
echo '<td><div align="left"><font face="Tahoma" size="1" color="#000000">'.$NOMBRES.'</font></div></td>';
if ($DV =='10')
{
$DV = 'k';
echo '<td><div align="center"><font face="Tahoma" size="1" color="#000000">'.$RUT.' - '.$DV.'</font></div></td></tr>';
}
else
if ($DV !='10')
{
echo '<td><div align="center"><font face="Tahoma" size="1" color="#000000">'.$RUT.' - '.$DV.'</font></div></td></tr>';
}
$shtml=$shtml."<tr>";
$shtml=$shtml."<td>$num</td><td>$PATERNO</td><td>$MATERNO</td><td>$NOMBRES</td><td>$RUT</td><td>$DV</td>";
$shtml=$shtml."</tr>";
pero entiendes lo que no me resulta?...gracias....por tu ayuda