RE: [PHP-DB] Dynamic menu

Try the "SELECT DISTINCT" syntax in MySQL From the MySQL manual: "The options [for the SELECT statement] DISTINCT, DISTINCTROW and ALL specify whether duplicate rows should be returned. The default is (ALL), all matching rows are returned. DISTINCT and DISTINCTROW are synonyms and specify that duplicate rows in the result set should be removed." $query = "SELECT DISTINCT * FROM tbl_name"; I hope this helps! -Mark > -----Original Message----- > From: César Aracena [mailto:icaam@icaam.com.ar] > Sent: Saturday, July 20, 2002 12:13 PM > To: PHP General List; PHP DB List > Subject: [PHP-DB] 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 > >