Dreamweaver and MYSQL Questions!

Hi

Dreamweaver and MYSQL Questions!

I have a table called "board_comments", it has a timestamp field called "timestamp".

I want to display this timestamp as a proper date, rather than a string of numbers.

I have created a recordset and used the following query

"select date_format(timestamp,'%e/%c/%Y %I:%i:%s %p') from board_comments"

When i click test it displays the dates just fine, when i try and drag the recordset into the dreamweaver page it says Unexpeted % or undefined varible

any ideas?

Try making an alias to the formatted date string like so:


What happens in that case, if you don't use an alias, is the returning column name is actually
'date_format(timestamp,'%e/%c/%Y %I:%i:%s %p')' rather than a human relatable name. I've never used Dreamweaver in that capacity so I can't vouch for it to be your solution, but it's the first place I'd try.

GOT IT!

Thanks i have been trying to do that for ages!