php mysql query display one instance of a value in field

Question

I have this query that searches my database for accommodation that has a type that is equal to e.g. "Hotel" it then outputs the results in an list displaying the location of the hotels. Basically because there are lets say 4 hotels in Windermere, Windermere is coming up 4 times. Is there anyway I can tell it to only display one instance of one value? Thanks in advance

<?php

include $_SERVER['DOCUMENT_ROOT']."/include/dbcon.php";
$query = "SELECT * FROM Places WHERE Type ='$type'" or die(mysql_error()); 
$result = mysql_query($query) or die(mysql_error());
echo "<ul>";
while ($row = mysql_fetch_array($result)) {

$link = $row ['Location'];
$link = strtolower($link);
$link = str_replace(" ", "-", $link);
$link = str_replace(".-", "-", $link);

echo "<li>";
echo "<a href='".$link."/"."'>".$row['Location']."</a>";
echo "</li>";
}
echo "</ul>";
mysql_close($con);
?>

Mischa · Accepted Answer · 2010-09-15 07:17:34Z

1

In your SQL you can use a GROUP BY statement:

SELECT Location FROM Places WHERE Type ='$type' GROUP_BY Location

Another possibility is using DISTINCT:

SELECT DISTINCT(Location) FROM Places WHERE Type ='$type'

edited Sep 15, 2010 at 7:17

answered Sep 15, 2010 at 7:09

Mischa

43.4k9 gold badges101 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

php mysql query display one instance of a value in field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related