Problems with the sort function

Hi,

i would like to sort my records by date. in europe we have this format: dd/mm/yyyy.

the situation is: it starts with day, then month, then year. i would like to start with year, then month, then day. All DESC.

why does my validation for spry not work?

thx for your quick help!

For your first problem:

What's the column type for the date entries?

I guess you have set it to "varchar" or something like that.

You should set it to "date" and insert the values like "yyyy-mm-dd".
In your portfolio page (=results table) you have to convert the date form "yyyy-mm-dd" to display like "dd.mm.yyyy".

You can do this in the bindings panel in dreamweaver --> select the date column and change the date format to "MySQL Date/Time: 30.12.2002"
There's a free dreamweaver extension at document.php?id_doc=51 which can do all the needed conversions.

Then you sort your recordset according to your wishes.

Your second problem:

the page shows a javascript error:

Meldung: 'Spry' ist undefiniert
Zeile: 291
Zeichen: 5
Code: 0
URI: kontakt.php?invalid=true

So maybe, that's the reason for the validation to fail. Just a guess however.

thx willi for your answer!

i changed it to date.
i have cs6 and can't see any format button in the bindings panel.

the validation tooltips for spry thing: i builded it up from zero. now its working. very annoying.

how can i set a default value to input files? is there a smart way to style it?

my datepicker does not work. any ideas? i have a custom theme with jquery.

files included:

2 jquery and 1 css

thx for your help!

my solution to format from yyyy-mm-dd to dd-mm-yyyy:
if the record is empty => show "no data"

<?php if ($row_Services['Datum'] != "") {
$originalDate = $row_Services['Datum'];
$newDate = date("d.m.Y", strtotime($originalDate));
echo $newDate;
} else { echo 'Kein Eintrag'; } ?>

=> "Services" is my recordset
=> "Datum" is my field name
=> "Kein Eintrag" is german and means no data.