Fetch navbar elements from SQL with PHP

Question

I have a mySQL table containing stores. It looks like this:

id | name   | city
1  | H&M    | New York
2  | Gucci  | New York
3  | H&M    | Chicago
4  | H&M    | Boston
5  | Gucci  | Las Vegas
6  | Cavalli| New York
7  | H&M    | Phoenix

I have a drop-down menu that I want to be looking like this:

Home
Stores
- New York
- Chicago
- Boston
- Las Vegas
- Phoenix

My question is: How do I fetch, without repeating, the cities I have stores in so I can make each of them a hyperlink in my drop-down menu like this: mypage.com/city/new-york. The page it will lead to, will obviously contain the stores where city='$_GET['city']'.

SELECT DISTINCT city FROM ...

Rajdeep Paul
– Rajdeep Paul

2016-10-31 07:34:26 +00:00
Commented Oct 31, 2016 at 7:34 — Rajdeep Paul
– Rajdeep Paul, Commented Oct 31, 2016 at 7:34

Karthi · Accepted Answer · 2016-10-31 07:40:30Z

1

use DISTINCT this will help to optimize data MORE INFO

Syntax:

SELECT DISTINCT column FROM Table_name

also you can use multiple columns

Syntax:

SELECT DISTINCT c1, c2, c3 FROM t1

answered Oct 31, 2016 at 7:40

Karthi

5281 gold badge5 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Frank Helligberger Over a year ago

Had not heard of this one. Worked great. Thanks!

Collectives™ on Stack Overflow

Fetch navbar elements from SQL with PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related