Code:
$box=$_POST['box'];
while (list ($key,$val) = @each ($box)) {
echo "$val ";
}
echo "<form method=post action=''>";
echo "<table border='0' cellspacing='0' style='border-collapse: collapse' width='100' >
<tr bgcolor='#ffffff'>
<td width='25%'><input type=checkbox name=box[] value='AND exterijer = 1'></td>
<td width='25%'> Eksterijer</td>
<td width='25%'><input type=checkbox name=box[] value='AND interijer = 1'></td>
<td width='25%'> Interijer</td>
<td width='25%'><input type=checkbox name=box[] value='AND detalji = 1'></td>
<td width='25%'> Detalji</td>
<td colspan =6 align=center><input type=submit value=Filtriraj></form></td></tr>
</table>"; ?>
$box=$_POST['box'];
while (list ($key,$val) = @each ($box)) {
echo "$val ";
}
echo "<form method=post action=''>";
echo "<table border='0' cellspacing='0' style='border-collapse: collapse' width='100' >
<tr bgcolor='#ffffff'>
<td width='25%'><input type=checkbox name=box[] value='AND exterijer = 1'></td>
<td width='25%'> Eksterijer</td>
<td width='25%'><input type=checkbox name=box[] value='AND interijer = 1'></td>
<td width='25%'> Interijer</td>
<td width='25%'><input type=checkbox name=box[] value='AND detalji = 1'></td>
<td width='25%'> Detalji</td>
<td colspan =6 align=center><input type=submit value=Filtriraj></form></td></tr>
</table>"; ?>
te upit za sql bazu koj izgleda ovako
Code:
$sql .= ' WHERE ' . $__current['database']['query'] . 'AND zupanija = "obiteljske" ' . $val . ' ORDER BY id DESC';}
$sql .= ' WHERE ' . $__current['database']['query'] . 'AND zupanija = "obiteljske" ' . $val . ' ORDER BY id DESC';}
dakle variabla $val bi mi u sql upitu trebala ispisati AND exterijer = 1 i prikazati sve zapise gdje je eksterijer 1 ali to mi neradi a echo o $val se uspjesno ispisuje,
u cemu bi mogao biti problem?