[PHP-DB] Re: Expiry Date ($date function)

l = "INSERT cust_records (cust_name, cust_address, ... , purchase_date, expiry_date) " ."VALUES ('$custName', '$custAddr', ... , $todayForDB, $expiryForDB)"; $mysql_query($sql); > > Ron Hope this is helpful, Laurence Heywood -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: preg_match html tags

any character, 1 or more, ungreedy. Ungreedy because otherwise it will match right up to the last possible place it can. You want it to match up until the next '', not the last ''. (?=<\/p>) - forward looking assertion. Read as: "Expression immediately prior must

Re: [PHP-DB] Connect remote DB server

ql-4.3.2-14.ent Any idea? Laurence "Shahmat Dahlan" <[EMAIL PROTECTED]> ??? news:[EMAIL PROTECTED] ???... > How about mysql client (which will include all the necessary libraries)? > having php-mysql install, doesn't mean you will be able to connect if > you don't

Re: [PHP-DB] Connect remote DB server

e to connect if > you don't have the libraries. > Since I assume that you are using some form of redhat linux dist, how > about the following packages (if I remember them correctly): > 1. mysql-4.x > 2. mysql-devel > 3. mysqlclient > > > Laurence Lim wrote: > > &

Re: [PHP-DB] Connect remote DB server

Thx Shahmat, These 2 packages also installed on the platform, I had tried to use the console (mysql_client) to login, it works. MySQL-shared-compat-4.0.13-0 MySQL-client-4.0.13-0 But, just dunno anything is still missing on the platform to make the code run... Thanks for help! B.Rgds, Laurence

Re: [PHP-DB] Connect remote DB server

[EMAIL PROTECTED] ???... > I think the mysql extension was not loaded, that's why you got the > message, and it was not able to recognize the function mysql_connect. > > Fatal error: Call to undefined function: mysql_connect() > > how did you install your copy of php? compile i

[PHP-DB] Connect remote DB server

. and return me the error msg, Fatal error: Call to undefined function: mysql_connect() in /var/www/philately/hkpo-eng/request_information/test.php on line 6 I have granted permission for access, no firewall blocking... Anyone know why it happens? Thanks for reply! Regards, Laurence -- PHP Da

[PHP-DB] PHP and Oracle Stored Functions

MBER ,P_STARTDATE IN DATE ,P_ENDDATE IN DATE) RETURN NUMBER; The error I get back on screen is: Warning: OCIStmtExecute: ORA-06550: line 1, column 69: PLS-00201: identifier 'CALC.package_name_pkg' must be declared ORA-06550: line 1, column 44: PL/SQL: Statement ignored in /home/isadlve/publi

[PHP-DB] PHP and Oracle 8 Stored Functions

MBER ,P_STARTDATE IN DATE ,P_ENDDATE IN DATE) RETURN NUMBER; The error I get back on screen is: Warning: OCIStmtExecute: ORA-06550: line 1, column 69: PLS-00201: identifier 'CALC.package_name_pkg' must be declared ORA-06550: line 1, column 44: PL/SQL: Statement ignored in /home/isadlve/publ

[PHP-DB] PHP & Oracle Stored Functions

Hi, Anyone have information on calling a stored function? Is it similar to a stored procedure? How to you access a return, thorugh OCIBindByName? Regards, Laurence Veale ext 6172 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional