Re: [PHP] sql problem
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]
Re: [PHP] LDAP problem
Make sure all the dlls used by php3_ldap.dll are available. I have php4 and the php_ldap.dll requires the libsasl.dll to be available. Brett ""almir"" [EMAIL PROTECTED] wrote in message 99d00g$j4h$[EMAIL PROTECTED]">news:99d00g$j4h$[EMAIL PROTECTED]... ok i am usng php3.0.11 ,IIS4 and NT4 trying to connect to ldap server but i get a error Fatal error: Call to unsupported or undefined function ldap_connect() in ... i have included php3_ldap.dll in my php3.ini, i have even tried to include it dinamicaly with dl but then i get Fatal error: Unable to load dynamic library './php3_ldap.dll' snip -- 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]
Re: [PHP] Error with ldap
php_ldap.dll also requires libsasl.dll, so make sure you move this dll to \winnt\system32 as well. Brett "Alain ROMERO" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I copy 'msvcrtd.dll' in winnt\system32 and php3 works fine, but not php4 HELP ! Alain ROMERO a écrit : PHP 4.0.2 on Win32 or PHP 3 on Win32 extension=php_ldap.dll is on in the php.ini file I get 'Unable to load php_ldap.dll' (PHP4) when I call a php file ? I get 'Call to an unsupported function ldap_connect()' (PHP3) ? Help please ? -- 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] -- 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] -- 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]
Re: [PHP] Opening/closing a DB
With InterBase using persistent connections will save a lot of time. However, you need to be extra careful with how you manage transactions. InterBase uses a versioning engine for transaction management and you can easily screw up the system performance if you don't manage your transactions correctly. Make sure you use short quick transactions. Don't leave a transaction open, always make sure the transaction is committed or rolledback. Lingering transactions are probably the biggest performance problem you'll encounter with InterBase. Brett ""Daniel Grace"" [EMAIL PROTECTED] wrote in message 004101c0a992$80fa98c0$b4bc9a40@hades">news:004101c0a992$80fa98c0$b4bc9a40@hades... On Saturday, March 10, 2001 at 7:03 AM, Todd Cary [EMAIL PROTECTED] wrote: I have some questions about PHP and it's interaction with a DB (namely, Interbase). My client's application uses a DB extensively and I am not clear about opening and closing a DB - the price one pays. First, I notice that the approximate time to open a connection to my DB on my test system is 1 second with a "locate time" of another second. So, 50% of the time is opening the DB. -- snip -- I haven't used Interbase, but if it's like most of PHP's database interfaces, it isn't too critical to worry about closing the database connection. PHP will do so automatically when your script ends. -- unsnip -- The next question envolves closing the DB and returning memory. ibase_free_result; ibase_close($dbh); What will happen if in my code I forget to do this in a place or two? Will the system eventually crash? -- snip -- The Interbase extensions to PHP support persistent connections: http://www.php.net/manual/en/function.ibase-pconnect.php (see mysql_pconnect() as well for more general info on persistent connections). With persistent connections, the overhead in connecting to the database backend is minimized since the same connection can be shared across multiple pages. This won't work with the CGI version of PHP however. - Daniel Grace http://dewin.oldbattery.com/ "Space may be the final frontier but its made in a Hollywood basement." - Red Hot Chili Peppers - Californication -- 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] -- 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]
Re: [PHP] Interbase
you might try www.ibphoenix.com as they have more info (than the Borland site) regarding InterBase. Brett ""Chris"" [EMAIL PROTECTED] wrote in message 03fd01c0a73c$15183c00$01c8c8c8@ibcserver">news:03fd01c0a73c$15183c00$01c8c8c8@ibcserver... Hi, Has anyone here dealt with the new Interbase 6.0 License? The web site says it is a free download for development, but I can't find any info about commercial use, and their sales office doesn't seem to know either, and they haven't called back yet. Anyone know what the commercial license is? Is it still free? Thanks, Chris -- 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]
