Hello,
I a not clear why are u using so many tables, and also div's within the
table. Either use tableless (css tables ) or simply use table(preferably
one) without divs in it
============
regds
amit
"The difference between fiction and reality? Fiction has to make sense."
On Sun, Jan 31, 2010 at 3:45 PM, nagendra prasad
<nagendra802000@gmail.com>wrote:
> 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'>®</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'>
>
> Type
>
> <b>
> Name</b>
>
>
>
>
> 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
>
|