sql looping problem??
| From: | Wade Halsey | Date: | Tue, 03 Apr 2001 14:48:44 +0000 |
| Subject: | sql looping problem?? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-46819@lists.php.net to get a copy of this message | ||
Hi
I have the following code
/*number of times to run*/
$NumCases = $HTTP_POST_VARS['txtNumCases'];
/*execute the sql*/
$sqlLargeRequest = sqlexecute($LargeRequest);
for ($val = 0; $val < $NumCases; ++$val){
if ($val < $NumCases) {
$details = sqlFetchObject( $sqlLargeRequest );
$AccNo = $details ->ACCNO;
etc etc
It executes the correct number of times but doesnt move to the next record.Im using an Interbase DB.
Any ideas??
TIA
Wade