Algorithm problem? php programming?

Question

I'm puting data from mysql database to an optionbox....

I'm using this code:



Main Category
$con = mysql_connect("localhost","Admin","987654321");

mysql_select_db("sciencelist", $con);

$result = mysql_query("SELECT * FROM websites");

while($row = mysql_fetch_array($result))
{
echo "";
echo $row['mainbranch'];
echo "";
}

?>

but my problem is that, if 2 (or more) similar data would exist, I dont want them to be shown. I want that any data to be shown only once in my optionbox, and there would not be 2 similar in my optionbox.

Help me please...

3 answers

Main Category
$con = mysql_connect("localhost","Adm...

mysql_select_db("sciencelist", $con);

$result = mysql_query("SELECT DISTINCT(mainbranch) FROM websites");

while($row = mysql_fetch_array($result))
{
echo "";
echo $row['mainbranch'];
echo "";
}

?>


USE "SELECT DISTINCT(mainbranch) FROM websites" query
Got it ([e-mail])

mysql select sintax:

SELECT
[ALL | DISTINCT | DISTINCTROW ]
....

The ALL, DISTINCT, and DISTINCTROW options specify whether duplicate rows should be returned. If none of these options are given, 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.

modify your sql query to read:

select top 1 from websites order by

Answer 1

Answer 2

mysql select sintax:

SELECT
[ALL | DISTINCT | DISTINCTROW ]
....

The ALL, DISTINCT, and DISTINCTROW options specify whether duplicate rows should be returned. If none of these options are given, 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.

Answer 3

modify your sql query to read:

select top 1 from websites order by