Subject Re: [firebird-php] $login_check = ibase_num_rows($sql); problem
Author Lester Caine
Johan van Zyl wrote:

> This now works
> $sql = ibase_query("SELECT username, \"PASSWORD\" FROM users WHERE
> username='$username' AND \"PASSWORD\"='$password' AND activated='1'");
> $login_check = ibase_fetch_row($sql);
> if($login_check > 0){
> but ibase_fetch_array seems to be a problem and I cannot find the ibase
> equivalent in PHP manual ?
> while($row = ibase_fetch_array($sql)){

ibase_fetch_assoc will return a php array with field names
ibase_fetch_row will return a php with field numbers

Use 'print_r($row);' to see exectly what you are getting back.

Lester Caine
L.S.Caine Electronic Services