# PHP browse script: get unique results

**URL:** <https://forum.kirupa.com/t/php-browse-script-get-unique-results/237844>\
**Category:** programming\
**Created:** [September 4, 2007, 4:19pm UTC](https://forum.kirupa.com/t/php-browse-script-get-unique-results/237844 "2007-09-04T16:19:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![imagined](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@imagined](https://forum.kirupa.com/u/imagined)\
**Post date:** [September 4, 2007, 4:19pm UTC](https://forum.kirupa.com/t/php-browse-script-get-unique-results/237844/1 "2007-09-04T16:19:02Z")

</div>

```auto

<p>Browse by:
<ul>
<li><a href="clients.php?browse=city">City</a></li>
	<?php
	if(isset($_GET['browse'])||$_GET['browse']=='city')
	{
		echo '<ul>';
		$query_browse = 'SELECT * FROM clients';
		$result_browse = mysql_query($query_browse);
		while($row_browse=mysql_fetch_array($result_browse))
		{
			echo '<li>'.$row_browse['city'].'</li>';
		}
		echo '</ul>';
	}
	?>

<li><a href="clients.php?browse=state">State</a></li>
<li><a href="clients.php?browse=zipcode">Zipcode</a></li>
<li><a href="clients.php?browse=country">Country</a></li>
</ul>
</p>

```

Im trying to work on a Browse Script. If there are 10 records that contain TEXAS as state, it prints 10 TEXAS results. But I just want to print ONE TEXAS result.

How can I only print ONE result of each?