<?php
$query = "SELECT b.*, u.nick, u.rate_sum FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
WHERE b.auction = " . $id . " ORDER BY b.bid DESC, b.quantity DESC, b.id DESC";
$result_numbids = mysql_query($query);
$system->check_mysql($result_numbids, $query, __LINE__, __FILE__);
?>

plz help i need to add another table how do i do this let say table name is buyers dbprefix is the same as users

do you want to select a column from another table?

is the any similar column between the two tables?

Yes i want to select another column from table buyer