RE: [PHP] Dynamic menu

Use GROUP_BY in your query on the some_else column SELECT * FROM table GROUP BY some_else ---John Holmes... > -----Original Message----- > From: César Aracena [mailto:icaam@icaam.com.ar] > Sent: Saturday, July 20, 2002 3:13 PM > To: PHP General List; PHP DB List > Subject: [PHP] Dynamic menu > > Hi all. I’m making a few dynamic menus that grab information from a > MySQL DB. What I don’t know is how to print only one line of each. I > don’t want a Drop Down List displaying 4 times the same line if the > information is repeated in 4 rows in the same table. What I’m 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 don’t 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 >