Execute sql a number of times
| From: | Wade Halsey | Date: | Wed, 14 Mar 2001 06:13:06 +0000 |
| Subject: | Execute sql a number of times | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-43810@lists.php.net to get a copy of this message | ||
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