Re: Double results
| From: | Miles Thompson | Date: | Sun, 27 Jan 2002 14:22:58 +0000 |
| Subject: | Re: Double results | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16221@lists.php.net to get a copy of this message | ||
$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