# Duplicate results (PHP)

**URL:** <https://forum.kirupa.com/t/duplicate-results-php/237036>\
**Category:** Uncategorized\
**Created:** [August 26, 2007, 7:00pm UTC](https://forum.kirupa.com/t/duplicate-results-php/237036 "2007-08-26T19:00:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pucca](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@pucca](https://forum.kirupa.com/u/pucca)\
**Post date:** [August 26, 2007, 7:00pm UTC](https://forum.kirupa.com/t/duplicate-results-php/237036/1 "2007-08-26T19:00:15Z")

</div>

hi. another ques. I’ve got a select \* from statement, but my results duplicate each entry… Heres my sql statement(sorry, a bit long…):

```auto
$sqlquery = mysql_query("SELECT  
t2.id, 
t1.Web_ID, 
t1.Psuburb, 
t1.Pcity, 
t1.price, 
t1.priceFrom, 
t1.priceTo, 
t1.Sid, 
t1.SPhone, 
t2.type, 
t2.state, 
t2.image1, 
t2.caption1, 
t2.descript1, 
t2.contactSP, 
t1.beds, 
t1.baths, 
t1.garages, 
t3.FName, 
t3.LName, 
t3.email, 
t3.mobile, 
t3.initials 
FROM 
WB_listings AS t1, 
PDS_listings AS t2, 
WB_users AS t3 
WHERE 
t1.Web_ID = t2.webid AND 
t1.listing_LS = t3.initials
AND Residential_Type = 'listings' 
ORDER BY 
t1.Psuburb ASC 
LIMIT $from, $max_results"); 

```