Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199807

[PHP3] Oracle - fetch out of sequence? From: Paul Monaghan (paulm <email protected>)
Date: 07/31/98

Anyone know why I get the above error with the following code:

$names=array(paul,paulm,monaghan,paulm);

$count_names = count($names);
                        
$count = 0;
$conn_id = ora_plogon("username","password");
ora_CommitOn($conn_id);
$cur = ora_open($conn_id);
do {
        ora_parse($cur, "SELECT login from dbadmin.db_account WHERE login =
'$names[$count]'");
        ora_exec($cur);
        ora_fetch($cur);
        $takenname=ora_getcolumn($cur,0);
        $ora_error=Ora_ErrorCode($cur);
        if ($takenname == $names[$count]) {
                $count = $count + 1;
        } else {
                $availnames[$count]=$names[count];
                $count = $count +1;

        } } while ($count <= $count_names);

Ora_Close($cur);
Ora_Logoff($conn_id);

What I hope to end up with is an array called $availnames that contains
names from $names that is not in the database. Can't seem to get it to
work. :(

TIA

Paul 

--
Paul Monaghan (PM1819, paulm <email protected>)
System Administrator - Internet Operations - ACC Tel.
No user-servicable parts inside. Refer to qualified service personnel.

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3