Code: Select all
if($_GETї'action'] == 'sortby')
{
$result = mysql_query("select * FROM interdb WHERE bandname LIKE '".strtoupper($_GETї'char'])."%' ORDER BY bandname ASC LIMIT 5",$db);
while($myrow = mysql_fetch_array($result))
{
echo "<p><b><a href=?action=view&id=" .$myrowїid]. " class=link>" . $myrowї'bandname'] . "</a></b> <font class=rm>- " . date("F j", strtotime($myrowї'date'])) . "</font>";
echo "<br>" . $myrowї'preinter'];
echo "<br><b><font class=rm><a href=?action=view&id=" .$myrowїid]. " class=rm>...Read More</a></b></font>";
}
}
elseif($_GETї'action'] == 'view')
{
$result = mysql_query("SELECT * FROM interdb WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
{
echo( "<br><b>" . $myrowї'bandname'] . " Interview</b>" );
echo( "<p>" . $myrowї'preinter'] );
echo( "<p>" . $myrowї'inter'] );
}
}
else
{
$result = mysql_query("SELECT * FROM interdb ORDER BY id desc LIMIT 5",$db);
while($myrow = mysql_fetch_array($result))
{
echo( "<p><b><a href=?action=view&id=" .$myrowїid]. " class=link>" . $myrowї'bandname'] . "</a></b> <font class=rm>- " . date("F j", strtotime($myrowї'date'])) . "</font>" );
echo( "<br>" . $myrowї'preinter'] );
echo( "<br><b><font class=rm><a href=?action=view&id=" .$myrowїid]. " class=rm>...Read More</a></b></font>" );
}
}