Page 1 of 1

Allocating Database enteries

Posted: Tue Jan 03, 2006 5:19 am
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.

:?: :?:

It don't matter

Posted: Tue Jan 03, 2006 6:17 am
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"));