Code: Select all
$query = "select * from Acoustic order by band_name limit $offset, $limit";
$result = mysql_query($query);
// use $result here to output page content
$num=mysql_numrows($result);
$lo=0;
while ($lo < $num) {
$bandname=mysql_result($result,$lo,"band_name");
$description=mysql_result($result,$lo,"description");
$id=mysql_result($result,$lo,"ID");
echo "<a href="http://naild.com/localmm/modules.php?name=Bands_Showcase&file=acoustic&band=$id"><b>$bandname</b></a><br><br><b>Description:</b> $description<br><br><hr>";
++$lo;
}Code: Select all
echo "<a href="http://naild.com/localmm/modules.php?name=Bands_showcase&file=acoustic&band=$id"><b>$bandname</b></a>"Code: Select all
<? $result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$bandname=mysql_result($result,$i,"band_name");
$description=mysql_result($result,$i,"description");
$history=mysql_result($result,$i,"history");
$influences=mysql_result($result,$i,"influences");
$genra=mysql_result($result,$i,"genra");
$email=mysql_result($result,$i,"email");
$website=mysql_result($result,$i,"website");
$mp3file=mysql_result($result,$i,"mp3file");
$imagefile=mysql_result($result,$i,"imagefile");
echo "<img align=right src="http://naild.com/localmm/upload/$imagefile"><br><b>$bandname</b><br><br><b>Description:</b> $description<br><br><b>History:</b> $history<br><br><b>Influences:</b> $influences<br><br><b>E-mail:</b> $email<br><br><b>Website:</b> <a href="$website">$website</a>       <b>Mp3: <a href="http://naild.com/localmm/upload/$mp3file">$mp3file</a><hr><br>";
++$i;
}
?>?>