hi plz plz help me
i want to retrieve a date i was save it at the database with defult formate i want to retrieve it with this format Month name and the year. and i want to use it at sql query like:

select * from title where date like "your help";
 thanx for your time.

Hi Dear

Suppose in ur database table column name of date is date_date
then SQL query will be like this
"select date_format(date_date, '%b %e %Y at %r') as date from TABLE where ......... ORDER BY DATE"

you can change the order also u want for ur date...see the DATE/TIME format in PHP

in the above query
DATE in ORDER BY clause will be the name u r giving in ur query.
Like
WHERE...ORDER BY date ///in the above this is right

not like ORDER BY DATE///it will give an error

i think u got wat u want if no then just reply me..

REGARDS