so i rewrote a code to collect price from a table and deduct from the users table the thing it works fine but the problem is it only deduct from the top of the table instead of the page being viewed at the moment.

$query = "SELECT minimum_bid, fee_type FROM " . $DBPrefix . "auctions ";

thats the query code i believe am missing something

skyhighweb:
so i rewrote a code to collect price from a table and deduct from the users table the thing it works fine but the problem is it only deduct from the top of the table instead of the page being viewed at the moment.

$query = "SELECT minimum_bid, fee_type FROM " . $DBPrefix . "auctions ";

thats the query code i believe am missing something

Is it deducting from a currently logged in user ?.
Is a session set ?
Just narrow down the query to the currently logged in user (add WHERE user = $currently_loggedin_user)
Or are you trying to achieve something else ? .

skyhighweb:
so i rewrote a code to collect price from a table and deduct from the users table the thing it works fine but the problem is it only deduct from the top of the table instead of the page being viewed at the moment.

$query = "SELECT minimum_bid, fee_type FROM " . $DBPrefix . "auctions ";

thats the query code i believe am missing something

Don't know how your code look like but to use variables from Currently logged-in user, you need to store and use session variables

the deducting is ok, its just seem to collect data from the top table instead of what's being viewed at the moment

Please help me correct the form "action" command for this script
Please anybody should help or just type what the action part will look like instead of the "confirm"
The file is the confirm.php

skyhighweb:
the deducting is ok, its just seem to collect data from the top table instead of what's being viewed at the moment

Donald3d:

Is it deducting from a currently logged in user ?.
Is a session set ?
Just narrow down the query to the currently logged in user (add WHERE user = $currently_loggedin_user)
Or are you trying to achieve something else ? .

Thanks in advance