hi. another ques. I’ve got a select * from statement, but my results duplicate each entry… Heres my sql statement(sorry, a bit long…):
$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");