- $query = "SELECT `nid`, `title`
- FROM `drupa_node`
- WHERE `type` = 'news'
- ORDER BY `nid` DESC
- LIMIT 0 , 30 ";
- $result = mysql_query($query) or die("Query failed : " . mysql_error());
- print "<table border=1>\n";
- while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
- print "\t<tr>\n";
- foreach ($line as $col_value) {
- print "\t\t<td><li>$col_value</td>\n";
- }
- print "\t</tr>\n";
- }
- print "</table>\n";
- mysql_free_result($result);