array_push($where, "sp.country = " . $_POST["cboCountry"]);
}
//Busqueda Avanzada
if ($_POST["cboItem"] != 0) {
array_push($where, " i.coditem = " . $_POST["cboItem"]);
}
if ($_POST["cboProvince"] != 0) {
array_push($where, "sp.province = " . $_POST["cboProvince"]);
}
if ($_POST["cboCity"] != 0) {
array_push($where, " sp.city LIKE '%" . $_POST["cboCity"] . "%'");
}
if (count($where) > 0) {
$sql .= " WHERE " . implode(" AND ", $where);
}
$browsing = new class_browsing($data);
$rstList = $browsing->get_query($sql);
while ($row = mysql_fetch_array($rstList)) {
?>
<div class="anunciante">
<div class="imganunciante"><img src="images/images.jpg" height="100" alt="foto" /></div>
<div class="datosanunciante">
<h3><?php
echo utf8_encode($row["business_name"]);
?>
</h3>
<div class="datosanunciante_list">
<span>Rubro: </span><?php
echo utf8_encode($row["rubro"]);
?>
<?php
include "connection/connection.php";
$browsing = new class_browsing($data);
$rstList = $browsing->get_query("SELECT * FROM usuarios");
?>
<table width="100%">
<tr>
<td><b>Nombre</b></td>
<td><b>Usuario</b></td>
<td><b>Password</b></td>
<td><b>Email</b></td>
</tr>
<?php
while ($row = mysql_fetch_array($rstList)) {
?>
<tr>
<td><? echo $row["name"];?></td>
<td><? echo $row["username"];?></td>
<td><? echo $row["pass"];?></td>
<td><? echo $row["email"];?></td>
</tr>
<?php
}
?>
</table>
