(1) create a news release system, the table named message has the following fields (3)
ID article id
title article title
content article content
category_id article classification id
hits click / answer: T NULL auto_increment,
'title' varchar (200) default NULL,
content 'text,
> > > > = > (two) the same news release system: table recording user Reply content, the field is as follows (4 points)
comment_id reply id
ID article ID, id
comment_content reply content
in the associated message table, and now the following format is required to get the list of article titles in the following format by querying the database, and sort by the number of replies, and reply the highest to the top
use a SQL statement to complete the above query, if the article does not reply then the reply number is shown as 0
answer: SELECT message.id ID, message.title title, IF, IF (message.`hits`, 0, *)) BER FROM message LEFT JOIN
comment ON message.id=comment.id GROUP BY message.`id`;
(three) the above content management system, table save classification information, field as follows (3 points) / > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > When the user enters the article, by selecting the drop-down menu, the selected article classification
writes how to implement the drop-down menu
answer: function categoryList ()
{
$result=mysql_query ("select category_id, categroy_name from category")); ("