Código HTML:
[CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Nuestros Vehículos en Exportec</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />
<link href="css/estilo.css" rel="stylesheet" type="text/css" />
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
<style type="text/css">
<!--
.Estilo1 {
color: #990000;
font-weight: bold;
}
-->
</style>
</head>
<body>
<table width="918" border="0" align="center" cellpadding="0" cellspacing="0" id="contenedor">
<tr>
<td width="9" align="center" valign="middle" background="images/sombraizquierda.jpg"> </td>
<td width="900" align="center" valign="middle"><table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','900','height','171','src','flash/banner','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','flash/banner' ); //end AC code
</script>
<noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="900" height="171">
<param name="movie" value="flash/banner.swf" />
<param name="quality" value="high" />
<embed src="flash/banner.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="900" height="171"></embed>
</object>
</noscript> </td>
</tr>
</table>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="240" height="56" align="center" valign="middle" background="images/menuizq.jpg"><a href="quienes.php"><strong>Quienes somos</strong></a></td>
<td width="369" height="56" align="center" valign="middle" background="images/menucent.jpg"><span class="Estilo1">Nuestros vehículos</span></td>
<td width="291" height="56" align="center" valign="middle" background="images/menuder.jpg"><a href="contacto.php"><strong>Contacto</strong></a></td>
</tr>
</table>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle">
<FORM METHOD="POST" ACTION="buscador.php">
<p>Escriba aqui la marca o el modelo de vehiculo que desa buscar</p>
<p>
<INPUT TYPE="text" NAME="palabra">
</p>
<label>
<input type="submit" name="button" id="button" value="Enviar" />
</label>
</FORM>
</td>
</tr>
</table>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle">
<table width="890" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top">
<?php
include ("conexion.php");
$con = conectar ();
if (isset($_REQUEST['accion'])) {
switch ($_REQUEST['accion']){
case "add": anadir($con);break;
case "del": borrar($con);break;
case "list": listar($con,0);break;
case "edit": editar($con);break;
case "view": mostrar($con);break;
case "save": guardar($con);break;
default: listar($con,0);break;
}
}
else {
listar($con,0);
}
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle"> </td>
</tr>
</table>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle"> </td>
</tr>
</table></td>
<td width="9" align="center" valign="middle" background="images/sombraderecha.jpg"> </td>
</tr>
</table>
<table width="890" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" id="copy">Copyright 2007-2008 © Todos los derechos reservados a Exportec</td>
</tr>
<tr>
<td align="center" valign="middle" id="copy">| Hospedado en: <a href="http://www.ideacorporativa.com" target="_blank">ideahosting</a> | Desarrollado por: <a href="http:/www.ideacorporativa.com" target="_blank">ideacorporativa</a> |</td>
</tr>
</table>
</body>
</html>
<?php
function listar($con,$el_id)
{
echo "<center>";
$SQL_listar="SELECT id,nom_marca,nom_modelo,foto01 FROM exportec ORDER BY 'id' DESC";
$listar=@mysql_query($SQL_listar,$con) or die ("<p class=\"MSG\">¡ERROR! Ha ocurrido un error al intentar listar los registros</P>");
$n_registros=mysql_num_rows($listar);
//Si no existen registros en la tabla (tabla vacia)
if ($n_registros == 0) {echo "<p class=\"MSG\">No existen registros en la base de datos</P>";}
else //Si existen registros en la tabla
{
echo "<table class=\"list\">
<tbody>";
while($registro = mysql_fetch_array($listar))
{
if ($usu_id!=$registro['id']) {echo "<tr onmouseover=\"this.bgColor='#990000'\" onmouseout=\"this.bgColor='#990000'\">";}
else {echo "<tr style=\"background-color:#990000;\">";}
//Vamos a ver cual es la marca
$SQL_cat="SELECT nombre FROM marcas WHERE id=".$registro['nom_marca']."";
$cat=@mysql_query($SQL_cat,$con) or die ("<p class=\"MSG\">No se pudo mostrar la categoría</P>");
$aux_cat = mysql_fetch_array($cat);
$la_marca = $aux_cat['nombre'];
//Vamos a ver cual es el modelo
$SQL_cat="SELECT modelo FROM modelos WHERE id=".$registro['nom_modelo']."";
$cat=@mysql_query($SQL_cat,$con) or die ("<p class=\"MSG\">No se pudo mostrar la categoría</P>");
$aux_cat = mysql_fetch_array($cat);
$el_modelo = $aux_cat['modelo'];
$brk = false; // iniciamos una variable booleana
// abrimos tabla
echo "<table> <tr>";
while( $row = mysql_fetch_array($SQL_listar) ) // bucle
{
echo "<td>" . $row['nom_marca'] . "</td>";
if( $brk == true ) // Si la variable es true crea una nueva fila echo "</tr><tr>";
$brk = !$brk; // cambiamos la variable booleana a su valor opuesto
}
echo "</tr><table>"; // cerramos
echo "<div class=\"nregistros\">Existen $n_registros registros</div><br />";
} //EndIf
mysql_free_result($listar);
echo "</center>";
} //EndFunction [/CODE]