# Session array in mysql query

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 3, 2004, 8:13am UTC](https://forum.kirupa.com/t/session-array-in-mysql-query/63138/2 "2004-09-03T08:13:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 3, 2004, 1:36pm UTC](https://forum.kirupa.com/t/session-array-in-mysql-query/63138/3 "2004-09-03T13:36:56Z")

</div>

> [@amitgeorge](#):
>
> $query = “SELECT \* FROM members where username='” . $\_SESSION[`memberinfo`][4] . “'”;

Don’t use backticks - that’d be equivalent to this:

```php

 $_SESSION[shell_exec("memberinfo")][4]
 

```

which I assume you don’t want to do 😉

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 3, 2004, 2:38pm UTC](https://forum.kirupa.com/t/session-array-in-mysql-query/63138/4 "2004-09-03T14:38:01Z")

</div>

thanks it works, i gotta use . notation for all queries now

chris