duplicate result

[skyhighweb]

am having a duplicate result because of bids.
i need to limit the result for only auctions to 1, i tried "limit 1" but they all get limited to 1 both bids n auctions, how do i limit only auctions to 1
how do i go about this, thanks.

 

$query = "SELECT b.*, u.nick, a.id, a.team1, a.team2 FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
LEFT JOIN " . $DBPrefix . "auctions a ON (a.id = b.auction)
WHERE b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder') and b.auction = :auc_id";
$params = array();
$params[] = array(':auc_id', $id, 'int');
$db->query($query, $params);

[Mahaveer]

use distinct in mysql query

[skyhighweb]

1 minute ago, Mahaveer said:

use distinct in mysql query

thanks for d reply, how do i implement that in d above code, thanks

[skyhighweb]

12 minutes ago, skyhighweb said:

thanks for d reply, how do i implement that in d above code, thanks

i added it but nothing seem to happen

[skyhighweb]

14 hours ago, skyhighweb said:

i added it but nothing seem to happen

solved thanks