Verifying condition
Posted: Thu Mar 13, 2003 5:57 pm
I have a form to search in a database with 5 dropdown menus inside, the values choosen there, are catched by this code. The only problem is that the field 'Precio' on the database has to be <OR= (smaller or equal) than the one catched from the form, never bigger.
I do not know how to introduce this condition in this code without crashing it.
<?php
$base="bla";
$tabla="Datosinmueble";
$conexion = mysql_connect('bla', 'bla', 'bla') or die(mysql_error());
mysql_select_db($base,$conexion) or die(mysql_error());
$fields = array('Modo','Localidad','Tipo','Habitaciones','Precio');
$clauses = array();
for($i=0; $i!=count($fields); $i++)
{
if (isset($_POST['envio'.($i+1)]) && $_POST['envio'.($i+1)] != -1)
$clauses[] = "$fields[$i]='{$_POST['envio'.($i+1)]}'";
}
$query = "SELECT * FROM $tabla";
if (count($clauses) > 0)
$query .= ' WHERE '.join('AND ', $clauses);
$pegar=mysql_query($query, $conexion) or die($query.' :'.mysql_error());
?>
<TABLE BORDER="1" CELLSPACING="1" CELLPADDING="1">
<TR>
<TD>Modo</TD>
<TD>Localidad </TD>
<TD>Tipo</TD>
<TD>Habitaciones</TD>
<TD>Precio</TD>
</TR>
<?php
while($row = mysql_fetch_array($pegar))
{
?>
<TR>
<TD><?php echo $row["Modo"]; ?></TD>
<TD><?php echo $row["Localidad"]; ?></TD>
<TD><?php echo $row["Tipo"]; ?></TD>
<TD><?php echo $row["Habitaciones"]; ?></TD>
<TD><?php echo $row["Precio"]; ?></TD>
</TR>
<?php
}
?>
I do not know how to introduce this condition in this code without crashing it.
<?php
$base="bla";
$tabla="Datosinmueble";
$conexion = mysql_connect('bla', 'bla', 'bla') or die(mysql_error());
mysql_select_db($base,$conexion) or die(mysql_error());
$fields = array('Modo','Localidad','Tipo','Habitaciones','Precio');
$clauses = array();
for($i=0; $i!=count($fields); $i++)
{
if (isset($_POST['envio'.($i+1)]) && $_POST['envio'.($i+1)] != -1)
$clauses[] = "$fields[$i]='{$_POST['envio'.($i+1)]}'";
}
$query = "SELECT * FROM $tabla";
if (count($clauses) > 0)
$query .= ' WHERE '.join('AND ', $clauses);
$pegar=mysql_query($query, $conexion) or die($query.' :'.mysql_error());
?>
<TABLE BORDER="1" CELLSPACING="1" CELLPADDING="1">
<TR>
<TD>Modo</TD>
<TD>Localidad </TD>
<TD>Tipo</TD>
<TD>Habitaciones</TD>
<TD>Precio</TD>
</TR>
<?php
while($row = mysql_fetch_array($pegar))
{
?>
<TR>
<TD><?php echo $row["Modo"]; ?></TD>
<TD><?php echo $row["Localidad"]; ?></TD>
<TD><?php echo $row["Tipo"]; ?></TD>
<TD><?php echo $row["Habitaciones"]; ?></TD>
<TD><?php echo $row["Precio"]; ?></TD>
</TR>
<?php
}
?>