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
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
>
>
>
>
>
>
> //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 " color='blue'> Mymp3 size='3'>® type='text' onclick=value='' size='50' name='search' value='$search'>
> type='submit' name='submit' value='Search'>";
>
> //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 $search";
> else
> {
> echo " /> align='right'>Showing 1-20 of $foundnum results found for
> $search.";
>
> echo " /> face='sana-serif' size='3'>
>
> Type
>
>
> Name
>
>
>
>
> Size
> ";
>
> 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 '';
>
> print ''."$type".'';
>
>
>//print ''."http://localhost/mymp3/"."; herf='$url'>$name".'';
>
>
>print ''."$name".'';
>
>
>print ''."$size".'';
>
>
>
> print '';
>
> print '';
> print '';
>
> /* echo "
>$type --> $nameSize: $size
>
> Date Added: $date
> "; */
> }
> ?>
>
>
>
>
>
>
> if (!$s<=0)
> echo "Prev";
>
> $i =1;
> for ($x=0;$x<$foundnum;$x=$x+$e)
> {
>
>
> echo " $i ";
>
>
> $i++;
>
>
> }
>
> if ($s<$foundnum-$e)
> echo "Next";
>
>}
> }
>
>
> ?>
>
>
>
>
>
> --
> Guru Prasad
> Ubuntu Voice GTK+ Forum
>