Wednesday, 14 August 2013

drop down unique search for labels

drop down unique search for labels

My table has a column named Labels.
1 work
2 work, fun
3 fun, adventure
4 disney, fun
I created a drop down search for labels but I see all words like work work
fun fun fun adventure disney. I tried to do distinct but could not work it
out. Help Please...
<?php
include("config1.php");
$sql = mysql_query('SELECT DISTINCT Labels FROM bookmark_app group BY
Labels ');
//echo "<select name='term' onchange=\"reload(this.form)\"><option
value=''>Select one</option>";
$models = array();
while ($rows = mysql_fetch_array($sql)) {
$my_arr = explode(",", $rows['Labels']);
for ($i = 0; $i < count($my_arr); $i++) {
// echo "$my_arr[$i]</br>";
// $models[] = $rows;
$models[]= $my_arr[$i];
}
}
//print_r($models);
exit;
?>

No comments:

Post a Comment