include("db/dbinfo.inc.php"); include('db/globals.php'); mysql_connect("localhost",$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM `catalogue` ORDER BY 'catnum' DESC"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); ?> $i=0; while ($i < $num) { $band=mysql_result($result,$i,"band"); $title=mysql_result($result,$i,"title"); $relpic=mysql_result($result,$i,"relpic"); $catnum=mysql_result($result,$i,"catnum"); $info=mysql_result($result,$i,"info"); ?>
">" width="100" height="100" border="0" class="band_img">
"> echo "$catnum"; ?>
"> echo "$band"; ?>
"> echo "$title"; ?>