Thanks for any help recieved.
Allocating Database enteries
Moderator: General Moderators
Allocating Database enteries
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.

Thanks for any help recieved.
It don't matter
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"));
$updateSQL = sprintf("UPDATE referrals
SET AgentFK=%s
WHERE AgentFK=36
LIMIT %s",
GetSQLValueString($_POST['lst_User'], "int"),
GetSQLValueString($_POST['txt_amount'], "int"));