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)){

http://uk.php.net/manual/en/function.ibase-fetch-assoc.php

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