₦airaland Forum

Am a pro. In programming and am to get in touch with any one who want to learn programming language contact or inbox me @facebook@victorumezurike1, 08058816142, @twitter @vicscript but I most be sincere with you is not for free guys.

Dude, we can guess good programmers by a lot clues. There's absolutely no clue on you being even remotely one. I went through your posts, and it seems your blood is hot, calm down � and polish yourself, your writing style (grammar and all...), then come back and advertise your craft... After then, we will push the folks disturbing on "learning programming" to you; and recommend you to others. I am serious.

Take my post in good faith. I mean no offense.

ok

hi am having an update issue problem, i have two tables

table 1
users
column id balance
...........3 ......675
...........6 ......400
...........8.......900
...........2.......450
...........5.......200


table 2
bids
column auction bidder
...........90.......3
...........90.......6
...........90.......8

...........95.......2
...........95.......5

for now i have this code (below) that display users with selected auction works fine

// Retrieve users that bids

$query = "SELECT b.*, u.name, u.nick, u.balance, s.team_id, s.teams, uu.nick AS nick_tag FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
LEFT JOIN " . $DBPrefix . "users uu ON (uu.id = b.tagged)
LEFT JOIN " . $DBPrefix . "sports s ON (s.team_id = b.willwin)
WHERE b.auction = :user_id order by b.tagged desc";
$params = array();
$params[] = array(':user_id', $id, 'int');
$db->query($query, $params);



And i have this code (below) that update users balance but it update all users cause it not connected to bids, trying to update column balance in "users" based on the auction id in "bids" being equal to auction id

if (isset($_POST['action']) && $_POST['action'] == 'update')
{
$query = "UPDATE " . $DBPrefix . "users SET balance = :balance";
$params = array();
$params[] = array(':balance', $system->input_money($_POST['balance']), 'float');
$db->query($query, $params);

header('location: listusers.php?PAGE=' . intval($_POST['offset']));
exit;
}

hope u understand

I appreciate you so much bro but; seen they say is believing, first let me start by saying this when I say I want to teach computer programming language to anyone what you should have done is to ask me the language I teach bro we all must not speak the same language alright, and if you must know I work with vb. Net and c# programming language bro. Learn that before calling someone fake. #Verify