Hi All,
PHP is unable to resolve the variable you are trying to use within a stting. If you
use complex array structures you have to write it like this:
$sql = "insert into sessions(session_id, user_id, session_expiration) values
('$sess_id', " . $user_fields['USER_ID'] . "', sysdate + (" .
$user_fields'MINS_TILL_EXPIRE'] . " * 1/1440))";
or use
$sql = sprintf("insert into sessions(session_id, user_id, session_expiration) values
('%s', sysdate + (%i * 1/1440))", $sess_id', $user_fields['USER_ID'],
$user_fields['MINS_TILL_EXPIRE']);
Your sample code also mised a ' after the first variable !
- Frank
> I'm trying to write a sql statement (for Oracle) that uses an associative
> array element as a dynamic value. PHP is choking on this line:
>
> $sql = "insert into sessions(session_id, user_id, session_expiration) values
>('$sess_id', $user_fields['USER_ID'], sysdate + ($user_fields['MINS_TILL_EXPIRE'] *
>1/1440))"
>
> I get this error back from PHP:
>
> Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
>
> Can I not use my associative array like this?
>
> --
> Michael Champagne, Software Engineer
> Capital Institutional Services, Inc.
> wk: [EMAIL PROTECTED]
> hm: [EMAIL PROTECTED]
>
>
>
> ******************************************************************
> This communication is for informational purposes only. It is not
> intended as an offer or solicitation for the purchase or sale of
> any financial instrument or as an official confirmation of any
> transaction, unless specifically agreed otherwise. All market
> prices, data and other information are not warranted as to
> completeness or accuracy and are subject to change without
> notice. Any comments or statements made herein do not
> necessarily reflect the views or opinions of Capital Institutional
> Services, Inc. Capital Institutional Services, Inc. accepts no
> liability for any errors or omissions arising as a result of
> transmission. Use of this communication by other than intended
> recipients is prohibited.
> ******************************************************************
>
> --
> 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]
