Unserialize returning false?

[nuglobe]

Alright so this is the entry that was stored in the database:

a:1:{s:6:"Andrew";s:17:"[email protected]";}

Here is the function that serializes it. Note - $_SESSION['stateEmails'] is passed through as the request array.

[code]function submit_request($uID, $requestArray){

$players = serialize($requestArray);
$status = 1;


$query = "INSERT INTO requests (uID, playersID, status) VALUES ('$uID', '$players', '$status')";
mysql_query ($query) or die ('Could not submit request!.');

}[/code]


Here is the code that creates the array.

[code]$_SESSION['stateEmails'][$rowprof['uFName']] = $rowprof['uEmail'];[/code]

Its in a loop, so there cool be more to it then the one posted at the top.

And finally here is the function I am trying to use to pull from the database, unserialize and display.

[code]
function get_open_requests($uID)
{

$status = 1;

$query = "SELECT playersID FROM requests WHERE uID = $uID AND status = $status";
$pull = mysql_query($query);

$players = unserialize($pull);

print_r($players);

}[/code]

What am I doing wrong?

[manichean]

Hello the problem lies in this section of your code

Your code:
[quote]
function get_open_requests($uID)
{

$status = 1;

$query = "SELECT playersID FROM requests WHERE uID = $uID AND status = $status";
$pull = mysql_query($query);

$players = unserialize($pull);

print_r($players);

}
[/quote]

Completed fixed code:
[quote]
function get_open_requests($uID)
{
$status = 1;
$query = "SELECT playersID FROM requests WHERE uID = '$uID' AND status = '$status'";
$pull = mysql_query($query);
$row = mysql_fetch_assoc($pull);
$players = unserialize($row['playersID']);
print_r($players);
}
[/quote]

always remember a mysql_query stored into a variable storeds its RESOURCE ID # not the values obtained from the table. And always encapsulate your variables in a select or insert statment with ' ' single quotes

Hope this helps ya
cheers

[nuglobe]

Thanks!  :D