sql query selecting one name no matter how many rows it was mentioned in

Posted by Baruch on Stack Overflow See other posts from Stack Overflow or by Baruch
Published on 2012-06-18T02:55:51Z Indexed on 2012/06/18 3:16 UTC
Read the original article Hit count: 169

Filed under:
|
|
|
|

Basically what I'm trying to do is get the information from column x no matter how many times it was mentioned. means that if I have this kind of table:

x     | y     | z
------+-------+--------    
hello | one   | bye    
hello | two   | goodbye     
hi    | three | see you

so what I'm trying to do is create a query that would get all of the names that are mentions in the x column without duplicates and put it into a select list.

my goal is that I would have a select list with TWO not THREE options, hello and hi

this is what I have so far which isn't working. hope you guys know the answer to that:

 function getList(){
 $options="<select id='names' style='margin-right:40px;'>"; 
 $c_id = $_SESSION['id'];

 $sql="SELECT * FROM names";
 $result=mysql_query($sql); 

$options.="<option value='blank'>-- Select something --</option>"   ;
 while ($row=mysql_fetch_array($result)) { 

$name=$row["x"]; 

$options.="<option value='$name'>$name</option>"; 
} 

 $options.= "</SELECT>";
return "$options";
 }

Sorry for confusing... i edited my source

© Stack Overflow or respective owner

Related posts about php

Related posts about html