Hi, I have a column in my database called cf_created it stores the data like this 2011-12-13 23:26:51 , how can I get the column default sort to sort using this data ?, I have tried putting in cf_created into the column index but the sorting seems erratic and not in date / time order. Another option would be to sort via the field cf_id which just goes 1, 2, 3, 4 etc but I cant work out how to get the sorting working correctly ?.
Thanks
Iain

Hello,

It is possible to sort by this field directly in a SQL query. It will look like:



Regards,
ARI Soft

thanks for that

Non related question, is there an easy way to cut off a line of text at a specific length in php ?, i have a databse field called emailmessage and i echo it on the page but i only want a summary of the first lets say ten words, either that or to a specific width of 200px but cant seem to find a way to do it, setting a fixed width and height just seems to wrap the text, but it keeps on expanding down regardless of what height i set.

See substr PHP function.

Regards,
ARI Soft