Arrays and Sessions!

[sodascape]

I'm having issues getting all of the variables of an array into a session, I put four or five things in, save it to a session and it only prints out the first one when I call it.  What is the best way to fix this?

[SharkBait]

Can you show us the code that deals with the array and inserting the values into a session?

[sodascape]

The input tag from the form:
[code]
<input type="checkbox" name="store[]" value="blue" />
<input type="checkbox" name="store[]" value="red" />
<input type="checkbox" name="store[]" value="green" />
[/code]

Turning the array into a session
[code]
// TURNING THE ARRAY INTO A SESSION
$_SESSION['bag'] = $_POST['store'];
[/code]

PUTTING THIS INTO THE DATABASE WITH OTHER VARIABLES NOT IN THE ARRAY
[code]
// UPLOAD THIS SHTuff TO THE DATABASE STORE
mysql_connect('localhost','stickys_stsp','stsp');
mysql_select_db( 'stickys_vbase' );

// DUMP ARRAY OUT OF SESSION
foreach ($_SESSION['bag'] as $bag) {

echo '<td align="center"><img src="setcaps/'.$bag.'" border="1" alt="" /></td>';

$storebag = "INSERT INTO store (id, username, setcap, today, expires, key) VALUES (0, $user, $bag, 0, 0, $key)";
// Display Results
$bagr = mysql_query ($storebag);

} // end foreach
[/code]

[sodascape]

Anyone have any idea?  This is driving me nuts!?!?!

[JasonLewis]

try print_r the store checkbox once you have submitted, then once the session is set do the same thing, to see if all variables have been passed correctly.

[sodascape]

[code]Array ( [0] => red.jpg [1] => green.jpg [2] => blue.jpg )[/code]
THAT'S WHAT I GET WHEN I PRINT_R THE ARRAY

[code]Array ( [0] => red.jpg [1] => green.jpg [2] => blue.jpg )[/code]
THAT'S THE RESPONSE I GET WHEN I PRINT_R THE SESSION.

EVERYTHING SEEMS TO BE passing fine.

[btherl]

Try this to replace your mysql_query():

[code=php:0]$bagr = mysql_query ($storebag) or die("Error in $storebag: " . mysql_error());[/code]

Can you tell us where you are finding only one item instead of all three items?