Hi all
I wanne be able to make links in this page
so people can sort it on A B C D E F and on
How do i do this?
<html>
<head>
<title>Ringtone-zone.nl!</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../ring.css" type="text/css">
DELETED SOME JAVA!!
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#000000" vlink="#000000" alink="#000000">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center"><img src="http://www.ringtone-zone.nl/top.gif" width="740" height="100"></div>
</td>
</tr>
</table>
<table width="668" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="../menu/back2.gif">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="144" background="../menu/top2.gif" class="tekst4t"> <b><span class="tekst3"><font color="#000000">-</font></span></b><font color="#FF0000"><b><span class="tekst3">
</span></b></font><b><span class="tekst3"></span></b>Welkom!<br>
</td>
<td>
<div align="right"><img src="http://www.ringtone-zone.nl/menu/balkboven.gif"></div>
</td>
</tr>
<tr>
<td bgcolor="#000000" valign="top" class="teksttw" rowspan="7">
<span class="teksttw">
<?php include("../menu.php"); php?>
</span></td>
<td valign="top" class="tekst">
<div align="center"><span class="tekst">De </span><span class="tekst2"><font color="#FF0000">gratis
ringtones</font></span><span class="tekst"> van <font color="#000000">ringtone-zone.nl</font>!<br>
(</span><span class="tekst3">klik op de naam voor de gratis
ringtone die je zelf kunt invoeren</span><span class="tekst">)</span></div>
</td>
</tr>
<tr>
<td valign="top" class="tekst">
<div align="right"><img src="http://www.ringtone-zone.nl/menu/balkboven.gif"></div>
</td>
</tr>
<tr>
<td valign="top" class="tekst">
<div align="center"><a href="http://www.ringtone-zone.nl/gratis/inde ... &t_step=49" target="_self">0
t/m 49</a> - <a href="http://www.ringtone-zone.nl/gratis/inde ... tep=99">50
t/m 99</a> - 100 t/m 149 - 150 t/m 199 - 200 t/m 249</div>
</td>
</tr>
<tr>
<td valign="top" class="tekst">
<div align="right"><img src="http://www.ringtone-zone.nl/menu/balkboven.gif"></div>
</td>
</tr>
<tr>
<td valign="top" class="tekst">
<div align="center"><font size="1"><font color="<? echo $font_color;?>" face="<? echo $font_face;?>"><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt="">=Leuk
<img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt="">=Interessant
<img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt="">=Moet
je horen<img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt="">=Wauw!
<img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt=""><img src="http://www.ringtone-zone.nl/top/images/star.gif" width="10" height="9" border="0" alt="">=SUPERTIP!</font></font><font size="2">
<font color="<? echo $font_color;?>" face="<? echo $font_face;?>"><font size="1">(<font color="#FF0000"><b>N</b></font>=Nieuw
<font color="#0000FF">C</font>=Cool <font color="#FF0000"><b>H</b></font>=Hot
)</font></font></font><font size="2"> </font><font size="2">
<br>
<font color="<? echo $font_color;?>" face="<? echo $font_face;?>"><font color="#FF0000"><b><font size="1">MENU
OPTIES</font></b></font><font size="1">: <b><font size="3">V</font></b><font size="3">=Vote
<b>M</b>=Mail naar een vriend <b>R</b>=Review</font></font></font></font></div>
</td>
</tr>
<tr>
<td valign="top" class="tekst">
<div align="right"><img src="http://www.ringtone-zone.nl/menu/balkboven.gif"></div>
</td>
</tr>
<tr>
<td valign="top" class="tekst">
<div align="center">
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<?
include "../top/config.php";
$reset_file = file($reset_log_file);
// checks reset time and resets if it's time
//###########
// makes sure the file isn't empty, if so writes time
if(empty($reset_file[0])){
reset_update_time($reset_log_file,$days_to_reset);
}
if($reset_file[0] <= time()){
reset_list($site_log_file,$total,$file);
reset_update_time($reset_log_file,$days_to_reset);
}
//###########
$reset_file = file($reset_log_file);
if (!$cid) {$cid = 0;}
if (!$from) {$from = 0;}
if ($cid == 0) {
$squery = mysql_query ("select *,if (rank/votes, rank/votes,0) as ranks,if (stars, stars,0) as star from top_user where status='Y' AND thin>=$min_hits order by thin DESC,ranks DESC,star DESC,thout DESC limit $from,$t_step") or die (mysql_error());
$tquery = mysql_db_query ($dbname,"select count(sid) as total from top_user where status='Y'",$db) or die (mysql_error());
}
else {
$squery = mysql_db_query ($dbname,"select *,if (rank/votes, rank/votes,0) as ranks,if (stars, stars,0) as star from top_user where status='Y' AND thin>=$min_hits and category=$cid order by thin DESC,ranks DESC,star DESC,thout DESC limit $from,$t_step",$db) or die (mysql_error());
$tquery = mysql_db_query ($dbname,"select count(sid) as total from top_user where status='Y' and category=$cid",$db) or die (mysql_error());
}
?>
<font size="1">
<script language="JavaScript">
<!--
if (window != top) { top.location.href = location.href; }
-->
</script>
<script language=JavaScript><!--
function changecat(newcat) {
exit=false;
site = "index.php?cid="+(newcat);
if (newcat!=0) {
top.location.href=site;
} else {
top.location.href="index.php";
}
}
-->
</script>
<br>
</font><font size="2"></font>
<div align="center">
<table bgcolor="black" align="right" width="95%" border="0" cellspacing=0 cellpadding=3>
<tr>
<td align="center" bgcolor="white" width="5%" height="20"><b><font face="Arial, Helvetica, sans-serif" size="2">NR</font></b></td>
<td bgcolor="white" width="11%" height="20">
<div align="center"><font face="Arial, Helvetica, sans-serif"><font face="Arial, Helvetica, sans-serif"><font size="2"><font size="2"><b>Menu</b></font></font></font></font></div>
</td>
<td bgcolor="white" width="79%" height="20"><b><font face="Arial, Helvetica, sans-serif" size="2">Naam</font></b></td>
<td bgcolor="white" width="5%" height="20"><font face="Arial, Helvetica, sans-serif" size="2"><b>Uit</b></font></td>
</tr>
<?
if (!$from) $cc=1;
else $cc = $from+1;
while ($rows = mysql_fetch_array($squery)) {
$jscript_imgs[$img_num] = $rows[banner];
if ($rows[ranks] > 0) {
$rating = $rows[ranks];
}
else { $rating = 0;}
?>
<tr valign="middle">
<td align="center" bgcolor="white" width="5%"> <font color="<? echo $font_color;?>" face="<? echo $font_face;?>" size="<? echo $font_size-1;?>">
<? echo $cc;?>
</font> </td>
<td bgcolor="white" width="11%">
<div align="center"><font color="<? echo $font_color;?>" face="<? echo $font_face;?>" size="<? echo $font_size-1;?>">
<?
if ($use_rating == 1) {
echo "<B><font size=\"-2\"><A HREF=\"../top/rate.php?site=$rows[sid]\">V</A></font></B> ";
}
if ($use_taf == 1) {
echo "<B><font size=\"-2\"><A HREF=\"../top/recommend.php?site=$rows[sid]&cid=$rows[category]\">M</A></font></B> ";
}
if ($use_review == 1) {
$reviews = get_site_reviews($rows[sid]);
echo "<B><font size=\"-2\"><A HREF=\"../top/review.php?site=$rows[sid]\">R</A></font></B> ";
}
?>
</font></div>
</td>
<td bgcolor="white" width="79%"><font color="<? echo $font_color;?>" face="<? echo $font_face;?>" size="2"><a href="../top/out.php?<? echo "site=".$rows[sid];?>" onMouseOver="window.status='<? echo $rows[url]?>'; return true;" onMouseOut="window.status=''; return true;">
<? echo $rows[title];?>
</a> -
<? echo $rows[description];?>
<?
if ($new_site_days > 0) {
if (time() - $rows[sid] - 86400*$new_site_days < 0) echo $new_site_image;
}
$htc = hot_status_check ($rows[stars],$hot_site_image);
echo $htc;
if ($use_rating == 1 && $use_cool == 1) {
$ci = get_cool_icon ($rows[rank],$rows[votes],$cool_site_image);
echo $ci;
}
if ($use_rating == 1) {
$ssr = stars_site_rating ($rows[rank],$rows[votes]);
echo $ssr;
}
?>
</font></td>
<td bgcolor="white" width="5%"><font color="<? echo $font_color;?>" face="<? echo $font_face;?>" size="<? echo $font_size-1;?>">
<? echo $rows[thout];?>
</font></td>
</tr>
<?
$cc++;
}
$query = mysql_db_query ($dbname,"select count(sid) as stotal from top_user where status='Y'",$db) or die (mysql_error());
$rows = mysql_fetch_array($query);
$stotal = $rows[stotal];
?>
</table>
</div>
</td>
</tr>
</table>
<br>
<div align="center"><a href="http://www.ringtone-zone.nl/gratis/inde ... &t_step=49" target="_self">0
t/m 49</a> - <a href="http://www.ringtone-zone.nl/gratis/inde ... tep=99">50
t/m 99</a> - 100 t/m 149 - 150 t/m 199 - 200 t/m 249<br>
<font color="<? echo $font_color;?>" face="<? echo $font_face;?>" size="<? echo $font_size-1;?>">
</font></div>
<p><br>
<font size="2"><font color="<? echo $font_color;?>" face="<? echo $font_face;?>">Er
zijn al
<? include "../top/counter.php";?>
bezoekers geweest!</font></font> </p>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td bgcolor="#000000"><font face="Arial, Helvetica, sans-serif" size="1">-</font></td>
</tr>
</table>
<p class="tekst"><span class="teksttw">
<?php include("../footer.php"); php?>
</span></p>
</div>
</body>
</html>
Mysql sorting tables, Can someone help me?
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK