Arranging Date information

[barney0o0]

how can i do that?....sorry, you know im a bit thick!

[Jake Arkinstall]

lol.

Anyway, I mean some of the data returned by the query. To do that, use PHPMyAdmin and run the query through it, then paste the results.

Thanks,
Jake Arkinstall.

[barney0o0]

will this surfice?

[Jake Arkinstall]

That's great.
Here you go - this should work. I originally assumed that mindate and maxdate held timestamps (the amount of seconds since jan 1st 1970).

$dateformat = "l jS F, y";
$min = strtotime($row_Recordset2['mindate']);
$max = strtotime($row_Recordset2['maxdate']);
$minform = date($dateformat, $min);
$maxform = date($dateformat, $max);
printf("<p>%s%s</p>", $minform, (($max > $min) ? " - " . $maxform : ""));