subject:"\[PHP\] sql problem"

Re: [PHP] sql problem

2001-03-26 Thread Brett Bandy

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$e2a27

RE: [PHP] sql problem

2001-03-23 Thread Jeff Armstrong

the first condition in the where clause. Regards Jeff -Original Message- From: Wade Halsey [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 11:25 AM To: [EMAIL PROTECTED] Subject: [PHP] sql problem Hi ppl ("select empname from employer where empno = (select employercode

[PHP] sql problem

2001-03-23 Thread Wade Halsey

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