Help to retrieve serialised data

[Lassie]

Hi,

I cant work out how to access a field with serialised data and extract it.

Any suggestions appreciated.

The table is sw_index and the fields are ID, property_title, post-code, zedindex,Date

My code

$wpdb->show_errors();//debug
$data = serialize($array);
global $wpdb;
$wpdb->query( $wpdb->prepare(
"INSERT INTO sw_zindex (ID,property_title,post_code,zedindex,Date)VALUES(NULL,'$property_title','$post_code','$data',NOW())"));

//retrieve entry from database as test
$result=$wpdb->query(
"SELECT zedindex FROM sw_zindex WHERE property_title= '$property_title'");
$row=mysql_fetch_array($result);
echo "

";                            print_r($row);// gives boolean false                            echo "

";
extract($row);
$data=unserialize($row['zedindex']);