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:{
$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
id, display FROM news ORDER BY date DESC ");
I have the query above the problem is oders them like so
30/05/2007
29/07/2007
25/0/2007
The order is taken by the first number. Is there any way to order them
properly wit
I have atable which contains the number and name of the photo galleries and
'thumnails' the images that are conenected to the galleries.
I am trying to create a 'pick a gallery' screen where it selects all the
galleries and then output the first thumbnail image associated with that
gallery.
I have two tables galleries which contains the number and name of the photo
galleries and 'thumnails' the images that are conenected to the galleries.
I am trying to create a 'pick a gallery' screen where it selects all the
galleries and then output the first thumbnail image associated with t
