Unserialize data

[bullbreed]

Hi Guys

 

I'm trying (but failing) to unserialize some data in the database

 

I have 5 image urls stored as a serialized array

uploads/black.jpg

uploads/white.jpg

uploads/blue.jpg

uploads/red.jpg

uploads/pink.jpg

 

The images associated with these urls are in the uploads folder

 

How do I unserialize them and show them on screen. Here is my attempt (doesnt work)

[syntax=php]

<?php

if (isset($_GET['cid'])){

 

$sql = "SELECT * FROM `products` WHERE `prod_cat` = '".$_GET['cid']."' ";

$query = mysql_query($sql) or die(mysql_error());

 

if (mysql_num_rows($query) > 0) {

 

while ($row = mysql_fetch_assoc($query)){

 

$colours = unserialize($row['prod_colours']);

$itemcount = count($colours);

for ($i=0;$i<$itemcount;$i++) {

 

?>

<div class="image-select"><?php echo $colours[$i]; ?></a></div>

 

<?php

}

}

}

}

?>

[/syntax]

I get this notice

 

Notice: unserialize() [function.unserialize]: Error at offset 40 of 50 bytes in C:\xampp\htdocs\folders\includes\prodcontent.php on line 24.

 

But not sure what that is.

[GKWelding]

Can you post here what your serialized array looks like? I'd be able to help you more if you did. Cheers.