# Session array in mysql query

**URL:** <https://forum.kirupa.com/t/session-array-in-mysql-query/121489>\
**Category:** Uncategorized\
**Created:** [September 3, 2004, 5:36am UTC](https://forum.kirupa.com/t/session-array-in-mysql-query/121489 "2004-09-03T05:36:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cmd](https://avatars.discourse-cdn.com/v4/letter/c/dbc845/32.png) [@cmd](https://forum.kirupa.com/u/cmd)\
**Post date:** [September 3, 2004, 5:36am UTC](https://forum.kirupa.com/t/session-array-in-mysql-query/121489/1 "2004-09-03T05:36:00Z")

</div>

hey there,

i have a variable in php called $\_SESSION[‘memberinfo’]. it is an array.

anyone know the syntax so i don’t have to store an array value into a temporary variable? for example instead of:

$username = $\_SESSION[‘memberinfo’][4];  
$query =  
“SELECT \* FROM members where username=’$username’”;

use this instead:  
$query =  
“SELECT \* FROM members where username=’$\_SESSION[`memberinfo`][4]’”;

chris
