$sql = "SELECT DISTINCT * FROM newforum WHERE id='$id' OR replyto='$id''";
BUT you do have an OR in your where condition. Try it - Miles On Sunday 27 January 2002 10:18 am, Jordy Driessen wrote: > Hello, > > Is there a query which can eliminate double results? Because my query ($sql > = "SELECT * FROM newforum WHERE id='$id' OR replyto='$id''";) selects > information from my MySQL-database double which isn't necessary... > > Who knows the answer? > > Thanx, > > Jordy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]