Dynamic menu
| From: | César Aracena | Date: | Sat, 20 Jul 2002 19:12:47 +0000 |
| Subject: | Dynamic menu | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-20670@lists.php.net to get a copy of this message | ||
Hi all. Im making a few dynamic menus that grab information from a
MySQL DB. What I dont know is how to print only one line of each. I
dont want a Drop Down List displaying 4 times the same line if the
information is repeated in 4 rows in the same table. What Im using is
something like:
$query = SELECT * FROM tbl_name;
$result = mysql_quiery($query) or die(mysql_error());
$num_rows = mysql_num_rows($result);
<select name="select_name">
<option SELECTED>Select Something</option>
for ($i=0; $i<$num_rows: $i++)
{
$row = mysql_fetch_array($result);
print ("<option
value=\"".$row[some]."\">".$row[some_else]."</option>");
}
</select>
This works just fine now that I dont have 2 or more rows with the
some_else repeated. Is there a WHERE or something like that which I
can use for this?
Thanks in advancem
<mailto:webmaster@icaam.com.ar> Cesar Aracena
CE / MCSE+I
Neuquen, Argentina
+54.299.6356688
+54.299.4466621