Allocating Database enteries

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mic2100
Forum Newbie
Posts: 4
Joined: Tue Nov 15, 2005 5:30 am

Allocating Database enteries

Post by mic2100 »

What I am trying to do is make a page that will allow me to select a user and allocate 50 enteries to them at a time. I have been trying over christmas to get ma head around it but havn't had mush luck with it. I can only seem to update one record at a time, thats ok but i really need to bulk the enteries.

Thanks for any help recieved.

:?: :?:
mic2100
Forum Newbie
Posts: 4
Joined: Tue Nov 15, 2005 5:30 am

It don't matter

Post by mic2100 »

Hurray I have finally sussed it out.

$updateSQL = sprintf("UPDATE referrals
SET AgentFK=%s
WHERE AgentFK=36
LIMIT %s",
GetSQLValueString($_POST['lst_User'], "int"),
GetSQLValueString($_POST['txt_amount'], "int"));
Post Reply