[PHP] RE: [PHP-DB] Dynamic menu From: Mark Middleton (mark <email protected>)
Date: 07/20/02

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 <email protected>]
> 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 <email protected>> Cesar Aracena
> CE / MCSE+I
> Neuquen, Argentina
> +54.299.6356688
> +54.299.4466621
>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php