₦airaland Forum

need your help here, am trying to deduct balance from minimum_bid in auction table, it working fine but problem is its only deducting from the top of the column instead of the what item is being displayed at the moment below is the code, thanks.



// work out & add fee

$query = "SELECT minimum_bid, fee_type FROM " . $DBPrefix . "auctions";
$db->direct_query($query);
$row = $db->result();
$fee_type = $row['fee_type'];
if ($row['fee_type'] == 'flat')
{
$fee_value = $row['minimum_bid'] * $qty;
}

My observation is that you are only querying the table without any condition. It will automatically select the first entry. Try using a WHERE Clause

hollyfat:
My observation is that you are only querying the table without any condition. It will automatically select the first entry. Try using a WHERE Clause

tried using that but it seem to either stop working or still select from the first entry

column in the auction table are

id fee_type minimum_bid

You will have to use the id of the currently viewed item in the where clause

hollyfat:
You will have to use the id of the currently viewed item in the where clause

yeah i have seen it was missing a auc_id