> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
