Not sure what you are trying to do?
Not sure what a Persal is (maybe an Arial?)
Perhaps you want:
select
E.empname
from employer E, badclient B
where E.employercode = B.employercode
and E.pesal='$Persal'
Note there are two tables given aliases of E and B
that are JOINED by 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 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]
