List:General Discussion« Previous MessageNext Message »
From:Ross Hulford Date:September 14 2007 1:08pm
Subject:adress stored as an array
View as plain text  
Hi,

I have an address stored as a serialized array

address[0] = "my street";
address[1] = "Edinburgh";
address[2] = "Scotland";

This is what I have. I want if it is possible to extract all the UNIQUE 
towns from my database.

This is what the on of the entires looks like in my database.

a:7:{s:8:"building";s:0:"";s:7:"company";s:0:"";s:5:"line1";s:12:"Leyland 
Road";s:5:"line2";s:0:"";s:5:"line3";s:0:"";s:4:"town";s:8:"Bathgate";s:6:"county";s:12:"West

Lothian";}


R. 


Thread
Seeing Table Structuretonylabarbara23 Jul
  • Re: Seeing Table StructureOlaf Stein23 Jul
    • Re: Seeing Table StructureMogens Melander23 Jul
      • Re: Seeing Table Structuretonylabarbara23 Jul
      • Re: Seeing Table StructureSteve Edberg24 Jul
    • Re: Seeing Table Structuretonylabarbara23 Jul
    • adress stored as an arrayRoss Hulford14 Sep
      • Re: adress stored as an arrayBaron Schwartz14 Sep