Re: Date() Problem
| From: | Jome | Date: | Sat, 27 Jul 2002 09:43:59 +0000 |
| Subject: | Re: Date() Problem | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109951@lists.php.net to get a copy of this message | ||
> Yeh, ive allready looked at that before, but where and when do i use
> DATE_FORMAT() ? When im inserting the row or selecting it?
>
Replace your existent query with this one and try:
SELECT
artist_id,title,content,user_id,DATE_FORMAT(date,'%d-%m-%Y
%H:%i:%s'),type,views FROM
resources WHERE id = $id
Regards,
Jome