Example of generating and displaying data by querying data (based on PHP MySQL)

// TABLE

Create table tableurl (

Id int (5 ),

Sort int (2 ),

Click int (6 ),

Getday date,

Name char (30 ),

Link char (40 ),

Brief char (50 ),

Primary key (id)

)

// XML FILE

------------------------------

<? Php

Require ("db. inc. php ");

If (empty ($ order ))

{$ Order = 'Hot ';

}

Switch ($ order)

{

Case 'Hot ':

$ Querystring = "select * from tableurl order by click desc LIMIT 20 ";

Break;

Case 'New ':

$ Querystring = "select * from tableurl order by getday desc LIMIT 20 ";

}

$ Result = mysql_query ($ querystring, $ db );

Echo "<? Xml version = "1.0" encoding = "gb2312"?> N ";

Echo "<? Xml-stylesheet type = "text/xsl" href = "sitelist. xsl"?> ";