Mysql Filtre Data

LolzyTM · Posted: 29-02-2012, 14:56:51 | Translate post to: ... (Click for more languages)

Salut am urmatorul cod:

Code:

<form method="get" action="">
<select name="categorie">
<option>nokia</option>
<option>LG</option>
<option>sony ericsson</option>
<option>Philips</option>
</select>
<input type="submit" value="Filtreaza!" name="subfil" />
</form>
<?
if(isset($_GET['subfil']))
{
$sql = "SELECT * FROM produse WHERE categorie='$categorie'";
$res = mysql_query($sql) or die("$sql");

while ($row = mysql_fetch_array($res))
{

$categorie = $_GET['categorie'];
$produs= $row["produs"];
$id = $row["id"];
$pret = $row["pret"];
$detalii = $row["detalii"];

echo'<table width="20px" align="center" style="float:left; padding-left:5px; margin-left:28px; margin-bottom:9px; margin-top:20px; margin-right:12px; background-color:#F3F3F3; border:solid 1px #ccc; -webkit-border-radius:8px; -moz-border-radius:8px; -ms-border-radius:8px;">
<th width="100" rowspan="3"><img src="produse/'.$id.'.jpg" width="100" height="100"/></th><td width="120">'. $produs .'
</tr>
<tr>
<td>Pret: '.$pret.'  Lei</td>
</tr>
<tr>
<td height="43"><a href="produse.php?produs='.$id.'"><img src="detalii.png" border="0" title="Detalii '.$produs.'"/></a></td>
</tr></table>    ';
}
}
?>

Eu am vrut sa fac sa imi filtreze produsele din baza de date daca $categorie = nokia sa imi arate produsele nokia dar nu merge nu se intampla nimic..... daca poate cineva sa imi zica unde am gresit... Ms mult!

nr913 · Posted: 29-02-2012, 15:16:31 | Translate post to: ... (Click for more languages)

Înainte de $sql = "SELECT ... pune $categorie = intval($_GET['categorie']);

Attitude - A little thing that makes a BIG difference

LolzyTM · Posted: 29-02-2012, 15:49:24 | Translate post to: ... (Click for more languages)

nr913 wrote:

Înainte de $sql = "SELECT ... pune $categorie = intval($_GET['categorie']);

Nope ...nu merge am incercat

nr913 · Posted: 29-02-2012, 15:51:00 | Translate post to: ... (Click for more languages)

Ce salvezi în câmpul categorie? Un id sau un string?

Attitude - A little thing that makes a BIG difference