Ver Mensaje Individual
  #6 (permalink)  
Antiguo 26/10/2010, 16:58
Avatar de oscarios
oscarios
 
Fecha de Ingreso: septiembre-2004
Mensajes: 186
Antigüedad: 20 años, 2 meses
Puntos: 2
Respuesta: Formulario de order by

PARTE 2

Código PHP:
Ver original
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
  5. <title>Documento sin t&iacute;tulo</title>
  6. </head>
  7.  
  8. <body>
  9. <table width="90%" border="0" cellspacing="0" cellpadding="2">
  10. </table>
  11. <table width="100%" border="0" cellspacing="0" cellpadding="2">
  12.   <tr>
  13.     <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
  14.       <tr>
  15.         <td><img src="imgs/tit_busque.jpg" width="218" height="33" /></td>
  16.         <td colspan="2" align="right"><span class="textoN">Usted encontr&oacute;&nbsp;</span><span class="encabN"><?php echo $totalRows_Recordset1 ?>&nbsp;&nbsp;<?php echo $row_Recordset1['tipo']; ?></span></td>
  17.         </tr>
  18.       <tr>
  19.         <td> Registros <?php echo ($startRow_Recordset1 + 1) ?> a <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> de <?php echo $totalRows_Recordset1 ?><br />
  20.           <a href="javascript:history.back(1)"><img src="imgs/volver.png" width="94" height="19" border="0" /></a></td>
  21.         <td><form id="form1" name="form1" method="get" action="result2b.php">
  22.           <select name="field" id="field">
  23.             <option value="barrio">Seleccione un campo</option>
  24.             <option value="barrio">Barrio</option>
  25.             <option value="valor">Valor</option>
  26.             <option value="area">Area</option>
  27.             <option value="habitaciones">Habitaciones</option>
  28.             <option value="codigo_inm">Codigo</option>
  29.           </select>
  30.           <select name="orden" id="orden" method="get">
  31.             <option value="ASC" selected="selected">Orden</option>
  32.             <option value="ASC">Ascendente</option>
  33.             <option value="DESC">Descendente</option>
  34.           </select>
  35.           <input name="busca" type="hidden" id="busca" value="<?php echo $row_Recordset1['ciudad']; ?>" />
  36.           <input name="busca2" type="hidden" id="busca2" value="<?php echo $row_Recordset1['zona']; ?>" />
  37.           <input name="busca3" type="hidden" id="busca3" value="<?php echo $row_Recordset1['tipo']; ?>" />
  38.           <label for="button"></label>
  39.           <input type="submit" name="button" id="button" value="Enviar" />
  40.         </form></td>
  41.         <td><table border="0">
  42.           <tr>
  43.             <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
  44.                 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>"><img src="First.gif" border="0" /></a>
  45.                 <?php } // Show if not first page ?></td>
  46.             <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
  47.                 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>"><img src="Previous.gif" border="0" /></a>
  48.                 <?php } // Show if not first page ?></td>
  49.             <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
  50.                 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>"><img src="Next.gif" border="0" /></a>
  51.                 <?php } // Show if not last page ?></td>
  52.             <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
  53.                 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>"><img src="Last.gif" border="0" /></a>
  54.                 <?php } // Show if not last page ?></td>
  55.             </tr>
  56.         </table></td>
  57.       </tr>
  58.     </table></td>
  59.   </tr>
  60.   <tr>
  61.     <td><?php do { ?>
  62.         <table width="100%" border="0" cellspacing="0" cellpadding="2">
  63.           <tr>
  64.             <td width="192" rowspan="3"><a href="result3.php?id=<?php echo $row_Recordset1['id']; ?>"><img src="photos/<?php echo $row_Recordset1['foto_a']; ?>" width="150" height="112" /></a></td>
  65.             <td width="126" align="center" nowrap="nowrap">Barrio</td>
  66.             <td width="157" align="center" nowrap="nowrap">Valor Venta</td>
  67.             <td width="101" align="center" nowrap="nowrap">Area</td>
  68.             <td width="72" align="center" nowrap="nowrap">Habit.</td>
  69.             <td width="86" align="center" nowrap="nowrap">Codigo</td>
  70.             <td width="120" rowspan="3"><a href="result3.php?id=<?php echo $row_Recordset1['id']; ?>"><img src="imgs/ingresar.png" width="100" height="25" border="0" /></a></td>
  71.           </tr>
  72.           <tr>
  73.             <td align="center"><?php echo $row_Recordset1['barrio']; ?></td>
  74.             <td align="center">$ <?php echo number_format($row_Recordset1['valor']); ?></td>
  75.             <td align="center"><?php echo $row_Recordset1['area']; ?></td>
  76.             <td align="center"><?php echo $row_Recordset1['habitaciones']; ?></td>
  77.             <td align="center"><?php echo $row_Recordset1['codigo_inm']; ?></td>
  78.           </tr>
  79.           <tr>
  80.             <td colspan="5"><?php echo $row_Recordset1['masinfo']; ?></td>
  81.           </tr>
  82.         </table>
  83.         <br />
  84.         <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></td>
  85.   </tr>
  86. </table>
  87. <p>&nbsp;</p>
  88. <p>&nbsp;</p>
  89. </body>
  90. </html>
  91. <?php
  92. mysql_free_result($Recordset1);
  93. ?>
__________________
oscariosdw