MYSQL 記事を取ってくる

$qstring = "selectd.topicid,DATE_FORMAT( d.dt,'%Y/%m/%d') as postdatef,DATE_FORMAT( d.dt,'%H:%i') as posttimef,d.lastupdate,d.fdelete," .
 "d.catid,b.category,d.title,d.body,d.image_g,YEAR(d.dt) as yyyy,MONTH(d.dt) as mm " .
 " from b_webdiary d left join b_categories b " .
 " on d.catid = b.catid order by d.dt desc


******************************************************
b_webdiary

topicid	lastupdate	dt	fdelete	catid	title	body

1

2010-03-11 18:06:28

2010-03-11 18:06:28

0

1

ddd

ddddd

b_categories

			catid	category

 1 　　　General
2 　　友人
*****************************************************