Location: PHPKode > scripts > Automatic Drop Down Menu > automatic-drop-down-menu/housecenterframe.php
$CATE = $_GET['categor'];
$SUBCAT = $_GET['subcateg']; 

<!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">
<!-- DW6 -->
<!-- Copyright 2005 Macromedia, Inc. All rights reserved. -->
<title>Productos categorizados</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="shortcut icon" href="favicon2.ico">
<link rel="stylesheet" href="mm_travel2.css" type="text/css" />
<style type="text/css">
.Estilo2 {
 font-size: 24px;
 font-weight: bold;
.Estilo3 {font-size: 18px}
<body bgcolor="#C0DFFD" on onload="" language="JavaScript">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <td width="50"><img src="mm_spacer.gif" alt="" width="50" height="1" border="0" /></td>
    <td colspan="2" valign="top"><img src="mm_spacer.gif" alt="" width="305" height="1" border="0" /><br />
      &nbsp;<br />
      &nbsp;<br />
      <table border="0" cellspacing="0" cellpadding="0" width="441">
$error.="<li>No ha ingresado uno de los datos requeridos. Por favor vuelva atraz y pruebe nuevamente.";
if($errors==1) echo $error;

$link = mysql_connect("localhost","xxx","YYYY");

$query1="SELECT CONCAT(modcatsub.CodigoCA,'-', modcatsub.CodigoSC,'-', modcatsub.CodigoM,'-', modcatsub.CodigoMO), marcas.Marca, modelos.ModeloN FROM modcatsub LEFT JOIN categoria ON modcatsub.CodigoCA=categoria.CodigoCA LEFT JOIN subcategorias ON modcatsub.CodigoCA=subcategorias.CodigoCA and modcatsub.CodigoSC=subcategorias.CodigoSC LEFT JOIN marcas ON modcatsub.CodigoM=marcas.CodigoM LEFT JOIN modelos ON modcatsub.CodigoM=modelos.CodigoM and modcatsub.CodigoMO=modelos.CodigoMO WHERE  categoria.NombreCA='".$CATE."' AND subcategorias.NombreSC='".$SUBCAT."' ORDER BY categoria.CodigoCA, modcatsub.CodigoSC, modcatsub.CodigoM, modcatsub.CodigoMO ";
$result1 = mysql_query($query1) or die('Query failed: ' . mysql_error());
echo "<table border = 1>\n";
          <TH COLSPAN="8"><h5><?php echo "CATEGORIA: $CATE "; ?></h5></TH>
          <TH COLSPAN="8"><h5><?php echo "SUBCATEGORIA: $SUBCAT"; ?></h5></TH>
while ($line = mysql_fetch_array($result1, MYSQL_ASSOC)) {
 echo "\t<tr>  \n";
   foreach ($line as $col_value) {
       echo "\t \t <td>$col_value   </td>  \n";
   echo "\t</tr>\n";
 }                                                        }
echo "</table>\n";
// Closing connection
?>          </td>
      </table>    </td>
    <td width="50"><img src="mm_spacer.gif" alt="" width="50" height="1" border="0" /></td>
    <td width="50">&nbsp;</td>
    <td width="171">&nbsp;</td>
    <td width="170">&nbsp;</td>
    <td width="50">&nbsp;</td>
Return current item: Automatic Drop Down Menu