Re: [PHP-DB] Need Help with data sorting
[email protected] (Amit Tandon)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]>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 >