[PHP-DB] getting rows by an ID field or by another field in a table

I have a table with the fields: CREATE TABLE `journal` ( `Date` date NOT NULL, `subject` varchar(100) NOT NULL, `entry` longtext NOT NULL ) TYPE=MyISAM COMMENT='Journal table'; I was wondering if I should get the rows out by an ID field of some kind or maybe do a select on the subject? what

[PHP-DB] formatting a date from mysql

I need to figure out how to format the date format: year-month-day (2005-12-06). It is a date(8) field in a mysql table that i pulled out of the table with php 5.0.5. I need it in the format: Tue December 6, 2005 (or in mysql's formatting: 6-12-2005). I am using the reformatting for display only.