[PHP-DB] Need Help with data sorting

[nagendra prasad]

Hi,

I have a database of MP3s in mysql and I have created a php search engine.
Now I want to sort it in ascending or descending order if user clicks on the
title of the table. For example if user want to arrange the table in
ascending or descending order by Name, Size, or by any other field. Also, I
am unable to arrange the table properly. Please help me....?? Below is the
code.

Type = Rock, Pop etc.
Url = file url
Name= Name of the song
Size = size

********************************************************************************************************************************************

<?php


//get data
$button = $_GET['submit'];
$search = $_GET['search'];


$s = $_GET['s'];
if (!$s)
$s = 0;


$e = 30; // Just change to how many results you want per page


$next = $s + $e;
$prev = $s - $e;




 if (strlen($search)<=2)
  echo "Must be greater then 3 chars";
 else
 {
  echo "<br /><table><tr><td><font face='sana-serif' size='10'><font
color='blue'> <b>Mymp3</b></b><font face='sana-serif'
size='3'>&reg;</td><td><form action='search.php' method='GET'><input
type='text' onclick=value='' size='50' name='search' value='$search'> <input
type='submit' name='submit' value='Search'></form></td></tr></table>";

  //connect to database
  mysql_connect("localhost","root","");
  mysql_select_db("mp3");

   //explode out search term
   $search_exploded = explode(" ",$search);

   foreach($search_exploded as $search_each)
   {

        //construct query
    $x++;
    if ($x==1)
     $construct .= "name LIKE '%$search_each%'";
    else
     $construct .= " OR name LIKE '%$search_each%'";

   }

  //echo outconstruct
  $constructx = "SELECT * FROM mp3 WHERE $construct";

  $construct = "SELECT * FROM mp3 WHERE $construct ORDER BY se DESC LIMIT
$s,$e ";
  $run = mysql_query($constructx);

  $foundnum = mysql_num_rows($run);


  $run_two = mysql_query("$construct");

  if ($foundnum==0)
   echo "No results found for <b>$search</b>";
  else
  {
   echo "<table bgcolor='#0000FF' width='100%' height='1px'><br
/></table><table bgcolor='#f0f7f9' width='100%' height='10px'><tr><td><div
align='right'>Showing 1-20 of <b>$foundnum</b> results found for
<b>$search.</b></div></td></tr></table><p>";

   echo "<table bgcolor='#0000FF' width='100%' height='1px'><br
/></table><table bgcolor='#f0f7f9' width='100%' height='10px'><tr><td><font
face='sana-serif' size='3'>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Type
<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Name</b>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Size
</div></td></tr></table><p>";

   while ($runrows = mysql_fetch_assoc($run_two))
   {
    //get data
   $type = $runrows['type'];
   $date = $runrows['date'];
   $url = $runrows['url'];
   $name = $runrows['name'];
   $size = $runrows['size'];


   print '<table width="800" border="0" align="center" >';

   print '<td><font color="blue">'."$type".'</font></td>';


    //print '<td><font color="blue">'."http://localhost/mymp3/".";<a
herf='$url'>$name".'</font></td>';


    print '<td><font color="blue">'."<a href='$url'>$name".'</font></td>';


    print '<td><font color="blue">'."$size".'</font></td>';



  print '</tr>';

  print '</tr>';
print '</table>';

  /* echo "<table width='300px' height='10px'>
   <h4> <font color='blue'>$type -->   $name</font><b><br>Size: $size
</b></a><br />
      <font color='00CC00'>Date Added: $date</font></table></h4>
   ";   */
   }
?>

<table width='100%'>
<tr>
<td>
<div align="center">
<br><br>
<?php
if (!$s<=0)
 echo "<a href='search.php?search=$search&s=$prev'>Prev</a>";

$i =1;
for ($x=0;$x<$foundnum;$x=$x+$e)
{


 echo " <a href='search.php?search=$search&s=$x'>$i</a> ";


$i++;


}

if ($s<$foundnum-$e)
  echo "<a href='search.php?search=$search&s=$next'>Next</a>";

    }
}


?>
</div>
</td>
</tr>
</table>

-- 
Guru Prasad
Ubuntu Voice GTK+ Forum