Hi
I need to execute an sql statement a certain number of times based on a users input
/* number of times to execute
$NumCases = $HTTP_POST_VARS['txtNumCases'];
/* sql to run
$GetDetails = sqlexecute("select b.accno,b.debttype, c.surname, c.initial
,c.firstname, c.id_number, c.maidenname, c.addr_line1, c.addr_line2, c.addr_line3,
c.addr_code, c.telnum, c.postaddress1, c.postaddress2, c.postaddress3, c.postpostcode,
c.bankname, c.accountnumber, c.accounttype,m.magdistrictname from bad b, client c,
magdistrict m where b.accno = c.persal and m.code = b.magdistrictcode ");
I presume i need a while loop or someting similar but im really confused as to how to
implement it.
Please note that I am running an Interbase database
Any help would be greatly appreciated