OK I have a large database I an querying LIKE SO 

```
SELECT * FROM PricePaid WHERE PostCode LIKE '$loc%'
         ORDER BY Price DESC
     LIMIT $start,$perPage 

```

I know how to do the paging links to work out the total records found and page through them. I am using the following code on my NEXT link :

```
<a href='http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']."&start=$next'>NEXT</a>

```

Which works OK as it keeps my ?loc variable but the start variable duplicates. 

This is how my url looks on the first page

```
 mysite/uk-property-prices.php?loc=l24  

```

Then when I click my next page link the first time my url passes the start variable and the query displays page two

```
 mysite/uk-property-prices.php?loc=l24&start=1  

```

But when I click next again I get this 

```
mysite/uk-property-prices.php?loc=l24&start=1&start=2

```

Now I know this works but after a while my URL gets stupidly long LIKE so 

```
mysite/uk-property-prices.php?loc=l24&start=1&start=2&start=3&start=4

```

What AM I doing wrong