list categories

Question

Boronia 0 Newbie Poster

14 Years Ago

Hi

If anyone could help with below code as I am new to php

<?php
$result = mysql_query("SELECT * FROM hotels ORDER BY city");

while($row = mysql_fetch_array($result))
  {
  echo $row['city'] . " " ;
  echo "<br />";
  }
?>

above code list all cities as below
newyork
newyork
newyork
newyork
newyork
newyork
Washington
Washington
Washington
Washington
Washington
Washington
Seattle
Seattle
Seattle
Seattle
Seattle
Kansas
Kansas
Kansas
Kansas
Kansas
Kansas
Kansas
.... continue

but i want to list like below and when a city link is clicked, all the hotels in that city will display on a city Page using the appropriate template

Newyork
washington
seattle
kansas ....

any help much appreciate

Thanks

php

Edited 14 Years Ago by nav33n because: Please wrap your code in [code] tags for easy readability.

3 Contributors
2 Replies
55 Views
1 Day Discussion Span
Latest Post 14 Years Ago Latest Post by wrivera

CFROG 9 Posting Pro in Training

14 Years Ago

You should avoid using SELECT ALL in your queries whenever and wherever possible. If you're after the city, select the city - especially in this case ;)

Anyhow, this is what you are after:

$result = mysql_query("SELECT DISTINCT city FROM hotels ORDER BY city ASC");

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

wrivera 0 Junior Poster in Training · Answer 1 · 2010-01-13T21:15:52+00:00

Hi
If anyone could help with below code as I am new to php
<?php
$result = mysql_query("SELECT * FROM hotels ORDER BY city");

while($row = mysql_fetch_array($result))
  {
  echo $row['city'] . " " ;
  echo "<br />";
  }
?>
above code list all cities as below
newyork
newyork
newyork
newyork
newyork
newyork
Washington
Washington
Washington
Washington
Washington
Washington
Seattle
Seattle
Seattle
Seattle
Seattle
Kansas
Kansas
Kansas
Kansas
Kansas
Kansas
Kansas
.... continue
but i want to list like below and when a city link is clicked, all the hotels in that city will display on a city Page using the appropriate template
Newyork
washington
seattle
kansas ....
any help much appreciate
Thanks

<?php
$result = mysql_query("SELECT * FROM hotels ORDER BY city");
$city=;
while($row = mysql_fetch_array($result))
  {
 if($city!=$row['city']){
  echo "<a href='city.php?city={$row['city']}'>{$row['city']} </a><br />";
     }
   $city=$row['city'];
  }
?>

this will list the city out by itself and then when you click it will open up the city page passing in the city as a get variable you can then run you php based on that.