InterBase isn't real good with subselects.
Try using a join instead:
select e.empname from employer e join badclient b on e.empno =
b.employercode where b.pesal = '$Persal';
Brett
""Wade Halsey"" <[EMAIL PROTECTED]> wrote in message
00a501c0b38b$e2a27ea0$256410ac@wadeh">news:00a501c0b38b$e2a27ea0$256410ac@wadeh...
Hi ppl
("select empname from employer where empno = (select employercode from
badclient where pesal = '$Persal')")
Could anyone help me out with the syntax?
Im running an interbase db and php4.04
Thanks
Wade
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
