I afraid your $login_check is an array.
See man what is return value of ibase_fetch_row().

Michal


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)){
>
>Thx to everyone for the help so far!
>Johan
> -----Original Message-----
> From: Lester Caine [mailto:lester@...]
> Sent: 21 November 2004 15:25
> To: firebird-php@yahoogroups.com
> Subject: Re: [firebird-php] $login_check = ibase_num_rows($sql); problem
>
>
> Johan van Zyl wrote:
>
> > $sql = ibase_query("SELECT username, password FROM users WHERE
> > username='$username' AND password='$password' AND activated='1'");
> > $login_check = ibase_fetch_row($sql);
>
> Johan - check things out in IBOConsole before trying in PHP.
> This will show what the query actually returns, password at least would
> require '"'s round it to use it in Firebird. Don't think you have got to
> a PHP error yet ;)
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
> Yahoo! Groups Sponsor
>
> Get unlimited calls to
>
> U.S./Canada
>
>
>
>
>----------------------------------------------------------------------------
>--
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-php/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.799 / Virus Database: 543 - Release Date: 2004/11/19
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>