Drop Down from MySQL Table

[Anon]

I am designing a vehicle database and need the user to be able to select from a list of makes to view the database.

The code I have below works fine but it repeats all the makes of vehicles in the database.

i.e It repeats FORD for every time there is a FORD in the MAKE of the database.

How do I stop it repeating the same make ?

Here is the code I have at the moment.

$sql = "SELECT * from stock";
$rsSelect = mysql_query($sql);

echo("<select name='Make'>");
echo("<option selected value=''>Make </option>");

while($row = mysql_fetch_array($rsSelect))
{
echo("<option value='$PHP_SELF?search=".$row["Make"]."'> ".$row["Make"]. "</option>");
}
echo("</select>");

Thanks for your help

[Anon]

Change your select statement to :

select unique make from stock;

Then you will have only a list of the makes in your database to work with.

[bastien]

select distinct (make) from stock

hth
bastien

[Anon]

You can also 'SELECT make FROM stock GROUP BY make'. This would also allow you to do a few other things that might add somewhat useful features, like 'SELECT make, count(make) as num_make FROM stock GROUP BY make'.

And a comment -- you should probably add an ORDER BY clause.

[Anon]

Many thanks guys for the tip 🙂

One other quick one, I want to show this menu on the same page that the database displays in its entirity.

Do I need to connect to the database twice.
I suppose I do to run two queries !!

Thanks a lot

[Anon]

No you can run multiple queries from a single database connection. The only time you'd need multiple connections is when you want to run queries against different databases, or as different users.