3 Listas Dependientes

[donquinto]

y la pagina donde debe mostrar el resultado es algo asi...


<td bordercolor="#FFFFFF"><img src="<?php echo $row_search_result['url_thumbnail']; ?>"></td>
<td bordercolor="#FFFFFF"><?php echo $row_search_result['provincia']; ?></td>
<td bordercolor="#FFFFFF"><?php echo $row_search_result['marca']; ?></td>
<td bordercolor="#FFFFFF"><?php echo $row_search_result['modelo']; ?></td>


y keda mas...


<?php require_once('Connections/connection_menulist_n.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

mysql_select_db($database_connection_menulist_n, $connection_menulist_n);
$query_provincias = "SELECT * FROM provincia ORDER BY provincia ASC";
$provincias = mysql_query($query_provincias, $connection_menulist_n) or die(mysql_error());
$row_provincias = mysql_fetch_assoc($provincias);
$totalRows_provincias = mysql_num_rows($provincias);

$colname_marcas = "-1";
if (isset($_POST['id_provincia'])) {
$colname_marcas = $_POST['id_provincia'];
}
mysql_select_db($database_connection_menulist_n, $connection_menulist_n);
$query_marcas = sprintf("SELECT id_marca, marca FROM marca WHERE id_provincia = %s ORDER BY marca ASC", GetSQLValueString($colname_marcas, "int"));
$marcas = mysql_query($query_marcas, $connection_menulist_n) or die(mysql_error());
$row_marcas = mysql_fetch_assoc($marcas);
$totalRows_marcas = mysql_num_rows($marcas);

$colname_modelos = "-1";
if (isset($_POST['id_marca'])) {
$colname_modelos = $_POST['id_marca'];
}
mysql_select_db($database_connection_menulist_n, $connection_menulist_n);
$query_modelos = sprintf("SELECT id_modelo, modelo FROM modelo WHERE id_marca = %s ORDER BY modelo ASC", GetSQLValueString($colname_modelos, "int"));
$modelos = mysql_query($query_modelos, $connection_menulist_n) or die(mysql_error());
$row_modelos = mysql_fetch_assoc($modelos);
$totalRows_modelos = mysql_num_rows($modelos);

mysql_select_db($database_connection_menulist_n, $connection_menulist_n);
$query_connection_recientes_n = "SELECT marca.marca, modelo.modelo, modelo.url_thumbnail, modelo.precio FROM modelo, marca WHERE modelo.id_modelo = marca.id_marca ORDER BY modelo.`date` DESC";
$connection_recientes_n = mysql_query($query_connection_recientes_n, $connection_menulist_n) or die(mysql_error());
$row_connection_recientes_n = mysql_fetch_assoc($connection_recientes_n);
$totalRows_connection_recientes_n = mysql_num_rows($connection_recientes_n);

$colname_search_result = "-1";
if (isset($_POST['id_modelo'])) {
$colname_search_result = $_POST['id_modelo'];
}
mysql_select_db($database_connection_menulist_n, $connection_menulist_n);
$query_search_result = sprintf("SELECT provincia.provincia, marca.marca, modelo.modelo, modelo.url_thumbnail, modelo.precio, modelo.`description`, modelo.`date` FROM modelo, marca, provincia WHERE provincia.id_provincia = %s AND marca.id_marca = %s AND marca.id_marca = %s AND modelo.id_modelo = %s ", GetSQLValueString($colname_search_result, "text"),GetSQLValueString($colname_search_resu lt, "text"),GetSQLValueString($colname_search_resu lt, "text"),GetSQLValueString($colname_search_resu lt, "text"));
$search_result = mysql_query($query_search_result, $connection_menulist_n) or die(mysql_error());
$row_search_result = mysql_fetch_assoc($search_result);
$totalRows_search_result = mysql_num_rows($search_result);
?>