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]