Code: Select all
if(isset($_GETї'start'])){$start=$_GETї'start'];}else{$start=0;}
$result=mysql_query("select * FROM gigdb WHERE headband LIKE '".strtoupper($_GETї'char'])."%' ORDER BY headband ASC LIMIT " .$start.", 15",$db);
{
while($myrow=mysql_fetch_array($result)){echo ( "<br><b><a href=?action=view&id=" .$myrowїid]. " class=link>" . $myrowї'headband'] . "</a></b> @ " .$myrowї'venue']. " - " . date("F j, Y", strtotime($myrowї'date'])) . "");
}
$query="SELECT count(*) as count FROM gigdb";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$numrows=$rowї'count'];
echo "<p>";
if($start>0){echo "<a href=?action=sortby&char=".strtoupper($_GETї'char'])."&start=".($start - 15)." class=link>Previous</a> ";}
if($numrows > ($start + 15))
echo("<a href=?action=sortby&char=" .strtoupper($_GETї'char']). "&start=" . ($start + 15) . " class=link>Next</a>");
}