Programming Help
Sorting Alpha and Numeric |
|
|
Hi,
I have a page that lists the names of the Artists in one column, and the title of their song in the next column. Ive included a sort section that allows users to view the artist (with the corresponding title) that starts with whatever letter they press. Ive now come to a point where I need to add in a check for numbers.
(View attached image to understand what were talking about)
So if the artist name starts with any number between 0-9, it will be shown in order on the page once a user clicks on "#". Ive tried doing it various ways, but cant seem to get it just right.
Here is the code (I took out all my attempts to get the numeric sort working):
PHP Code:
<?php
session_start();
include_once(inc/connect.php);
if (isset($_SESSION[username])){
$loginstatus = logout;
}
else{
$loginstatus = login;
}
if(!isset($_SESSION[sort_counter]))
{$_SESSION[sort_counter] = 1;}
if(($_SESSION[sort_counter]%2) == 0){ //test even value
$sortcount = DESC;
}else{ //odd value
$sortcount = ;
}
$result = mysql_query(SELECT * FROM sheets ORDER BY artist);
$sheetscount = mysql_num_rows($result);
$sortletteris = $_GET[letter];
$downloadclick = $_GET[downloadclick];
$show = $_GET[show];
$today = date(Y-m-d);
?>
<!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd>
<html lang=en-US xml:lang=en-US xmlns=http://www.w3.org/1999/xhtml>
<head>
<link rel=stylesheet type=text/css href=styles/style.css />
</head>
<body bgcolor=#343331>
<!-- Header -->
<div id=header>
<div id=headerleft></div>
<div id=headermiddle><a href=index.php><img src=img/logo.png></a></div>
<div id=headerright>
</div>
</div>
<!-- Content Top -->
<div id=contenttop>
<div id=links>
<!-- 92x30 -->
</div>
</div>
<!-- Content Middle -->
<div id=contentmiddle>
<div id=content>
<div id=sort>
<?php
echo <center>.$sheetscount. Sheets Available<br />;
echo <a href=newlyadded.php>New Sheets</a><span> | </span><a href=request.php>Request a Sheet</a></center>;
$letters = ABCDEFGHIJKLMNOPQRSTUVWXYZ;
echo <center><div id=letters>;
$i = 0;
while ($i<26){
$sortletter = $letters[$i];
echo <a href=index.php?letter=.$i.>.$letters[$i]. </a>;
$i += 1;
}
echo <a href=index.php>All</a></div></center>;
if (($sortletteris)!=){
// The letter that was clicked is set to this variable
$mysortletter = $letters[$sortletteris];
//echo $mysortletter;
// lname LIKE $letter%
$result = mysql_query(SELECT * FROM sheets WHERE artist REGEXP ^[$mysortletter] ORDER BY artist $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
elseif (($sortletteris)==){
$result = mysql_query(SELECT * FROM sheets ORDER BY artist $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
$greenboxleft = greenboxleft;
$greenboxright = greenboxright;
$grayboxleft = grayboxleft;
$grayboxright = grayboxright;
$colorvalue = 0;
echo <br /><table width=600px align=center style=border-collapse:separate;
border-spacing:0px;><th style=background-color: #cccccc; border-bottom-style: solid; border-color: #6aa504;>Artist</th><th style=background-color: #cccccc; border-bottom-style: solid; border-color: #6aa504;>Title</th>;
while($row = mysql_fetch_array($result))
{
if(($colorvalue%2)==0){
$styleleft = $greenboxleft;
$styleright = $greenboxright;
}
else{
$styleleft = $grayboxleft;
$styleright = $grayboxright;
}
echo <tr>;
echo <td align=center width=250 id=$styleleft><div id=songsboxleft>. ucwords($row[artist]). </div></td>;
echo <td align=center width=250 id=$styleright><div id=songsboxright><a target=_blank name=downloadclick href=.$row[url].> .ucwords($row[title]). </a></div></td>;
echo </tr>;
$colorvalue++;
}
echo </table>;
?>
</div>
</div>
</div>
<!-- Content Bottom -->
<div id=contentbottom>
</div>
</body>
</html>
website
|
Add comment
|
