PHP - Sorting Database Table With Links Asc & Desc

Hi,
I want to be able to sort table columns dynamically, like clicking on a header arrow?
I have no idea where to start. I did a google search and I found lots of pre-made extensions bu not a simple tutorial to get me started.
Can you point me in the right direction?
Thanks

This topic has used a waypoint to get to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=359489.0


How do I like it, you ask? Quite well. Besides the downtime Tuesday I haven't had any server problems, and the game itself is great. Very D2-esque but with very noticeable enhancements.

Glad to be back in the community 

Anyways I've got a mysql table with 4 different entries from a form.  One being an id with an auto-increment.  I'm wanting to arrange them into a table, descending by the id number.  I'm having a hard time wrapping my mind around how to even start it and get the other 3 fields to retrieve and be in a table together.  I have:

$db="prayers";
$link = mysql_connect('localhost', 'root' , '');
if (! $link) die(mysql_error());
mysql_select_db($db , $link) or die("Select Error: ".mysql_error());


$query = "SELECT * FROM table prayerwall BY id DESC LIMIT 10";  

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

Not sure how to retrieve the other entries and then put them into a table.  A start or some help would be greatly appreciated.  Thanks everyone!

Ok so here is my code. Ignore the $_POST['dobm']. That is part of the whole script.
All I want to know is how to set the list from 1998 to 1911 in descending order. I already tried making $i = 1998 and make $i - 1 til $i >= 1911. It seems to go in an infinite loop when I do that.

Code: [Select]
<?php
for($i = 1911; $i <= 1998; $i++)
{
if ($_POST['dobm'] == $i)
{
echo '<option selected="selected" value="'.$i.'">'.date('Y', mktime(0,0,0,0,0,$i+1)).'</option>\n';
}
else
{
echo '<option value="'.$i.'">'.date('Y', mktime(0,0,0,0,0,$i+1)).'</option>\n';
}
}
?>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=319167.0

Hello and Gm.
I have a script (below) which paginates a mysql table. Showing 4 rows per page. It works well.

   <?php

$sql = mysql_query("SELECT * FROM tablename ORDER BY id ASC");

$nr = mysql_num_rows($sql); 
if (isset($_GET['pn'])) { 
    $pn = preg_replace('#[^0-9]#i', '', $_GET['pn']); 
   
} else {
    $pn = 1;
} 

$itemsPerPage = 8; //number of rows per page 

$lastPage = ceil($nr / $itemsPerPage);

if ($pn < 1) {
    $pn = 1; 
} else if ($pn > $lastPage) { 
    $pn = $lastPage;
} 

$centerPages = "";
$sub1 = $pn - 1;
$sub2 = $pn - 2;
$add1 = $pn + 1;
$add2 = $pn + 2;
if ($pn == 1) {
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
} else if ($pn == $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
} else if ($pn > 2 && $pn < ($lastPage - 1)) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub2 . '">' . $sub2 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add2 . '">' . $add2 . '</a> &nbsp;';
} else if ($pn > 1 && $pn < $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
}

$limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage; 

$sql2 = mysql_query("SELECT * FROM tablename ORDER BY id ASC $limit"); //second query

$paginationDisplay = ""; 
if ($lastPage != "1"){
   
    $paginationDisplay .= 'Page <strong>' . $pn . '</strong> of ' . $lastPage. '&nbsp;  &nbsp;  &nbsp; ';
 
    if ($pn != 1) {
        $previous = $pn - 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $previous . '"> Back</a> ';
    } 
  
    $paginationDisplay .= '<span class="paginationNumbers">' . $centerPages . '</span>';

    if ($pn != $lastPage) {
        $nextPage = $pn + 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $nextPage . '"> Next</a> ';
    } 
}

$outputList = '';
while($row = mysql_fetch_array($sql2)){  


print "$row[permalink]";
print "$row[title]";

  } 
    
  ?>
</div>

  

<h2>Total Items: <?php echo $nr; ?></h2>
 
      <?php echo $paginationDisplay; ?>
      <?php print "$outputList"; ?>

        

What I would like to do is have it like you see on other sites where there is a drop down menu that one can sort by a column first and it paginates after.

So the url or dropdown would look something like

/paginatedfile.php/column_name=title&orderby=desc

And if you click page 2 you get a url like..

/paginatedfile.php/column_name=title&orderby=desc&pn=2

Can someone please help.


Thanks, Chris


 
 

Hi there

I've been working with some code to display a single
record on page. This all works fine and I'm able to pull what I
want from the database. My problems is trying to use that
data and turning it into something else like a link.

I have a field in the database called image url which
contains rows of image urls.

So here is the problem area of the code:

Code: [Select]
<?php
//////Displaying Data/////////////
$id=$_GET['id']; // Collecting data from query string
if(!is_numeric($id)){ // Checking data it is a number or not
echo "Data Error";
exit;
}

$fetch=mysql_query("select * from productfeeds where ProductID=$id ");
$row=mysql_fetch_object($fetch);
echo mysql_error();
echo "<table>";
echo "
<tr><td><b>ProductID</b></td><td>$row->ProductID</td></tr>
<tr><td><b>ProductName</b></td><td>$row->ProductName</td></tr>
<tr><td><b>ProductPrice</b></td><td>$row->ProductPrice</td></tr>

//problem area for me
<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>
echo "</table>";
I'm trying to edit this part of the code:

<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>

I've tried this:

<tr><td><b>Image</b></td><td><a href='{$row['URL']}'> <img src='{$row['ImageURL']}'></a>

and

<tr><td><b>Image</b></td><td><a href='$row['URL']'> <img src='$row['ImageURL']'></a>  //removed brackets

but I'm just getting errors. Can you guys help please?

Thank you very much.

hello, i am hoping someone can help, i have a form that has a body and title fields and then sends to this function below.
it all works fine, but when i add a image or a link it stores it in the text field of the db like this:

<IMG alt=\"\" src=\"/public/images/231781538234094.jpg\" width=796></P>

this is what it should be /public/images/231781538234094.jpg

so when i view the image it doesent show it and i right click the image and goto image properties and i get this:
http://test.cyberglide.co.uk/%22public/images/231781538234094.jpg/%22

Code: [Select]
function content_update() {

$title = mysql_real_escape_string($_POST['title']);
$body = mysql_real_escape_string($_POST['body']);
$page = mysql_real_escape_string($_POST['page']);
$location = mysql_real_escape_string($_POST['location']);
$id = mysql_real_escape_string($_POST['id']);

$sql = "UPDATE content SET title = '$title', body = '$body', page = '$page', location = '$location' WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "<script>window.location='content.php'</script>";
}

if i manually edit it on the db it works fine

please help, many thanks.

I have a php page where  I have posts about different  topic.
I have a menu listing all this categories of topics . Some topics may belong to more than one category.

So when i click on a particular menu item, the topic belonging to that category will be displayed.
While displaying it is in this format---Topic Heading,Belongs to which all categories,date posted and the description.

All this are taken from database.

Now my actual issue is I am not able to give links to the categories dispalyed ,if the category exceeds more than 1.
For eg:
Global Warming
Posted on March 11,2011 in News, Issue
-----------description of global warming goes here.

In the above eg: News and issue are the two categories,when i click on News it should display all the items in news category,and when i click on issue it should display all items of issue category.
But I am not able to give this link to the categories.

Code: [Select]
while($row = mysql_fetch_array($q)) {
  if($row[6]=='News'){
  $c='<a href="category_disp.php?category=news">News</a>';
  }
  if($row[6]=='Issues'){
  $c='<a href="category_disp.php?category=issues">Issues</a>';
  }
 
 
   echo "<tr><td><p >$row[1]</p><br></td></tr>";
  echo "<tr><td>  <div >".
  "<p><span>$row[4]</span> <span>".
  "<a href='$row[6]' >$row[6]|<a href='$row[5]'> Post Comments</a></span></p>".
  "<p>&nbsp;</p></div><br></td></tr>";
  echo "<tr><td><p >$row[2]</p><br></td></tr>";
  echo "<tr><td><p ><a href='$row[3]' >Click Here to read more...</a></p></td></tr>";
  echo "</div></td></tr>";
 }

echo"  </table>

i'm back again and i am not very good with tables as the <tr> and <td> tags confuse me 
i need to put 2 sets of links into 2 columns in the table and they come out jumbled up.

Code: [Select]
<table>
<tr>
<th>column 1</th>
<th>column 2</th>
</tr>
<?php

$sites = array_map('trim',file('websites.txt')); //read the whole file into an array & trim the newline character from the end of each line
foreach ($sites as $link) {
   echo "<tr><td><a href='$link'>$link</a></td>";
}


$sites = array_map('trim',file('websites2.txt')); //read the whole file into an array & trim the newline character from the end of each line
foreach ($sites as $link) {
   echo "<td><a href='$link'>$link</a></td></tr>";
}

?>

</table>

I have a table and one column has links that point to index.php?id= but I want it to display the info of that row of my database. On the index.php page i have this code Code: [Select]
<?php
include "dbaptsConfig.php";

// test id, you need to replace this with whatever id you want the result from
$id = "1";

// what you want to ask the db
$query = "SELECT * FROM `apartments` WHERE `id` = ".$id;

// actually asking the db
$res = mysql_query($query, $ms);

// recieving the answer from the db (you can only use this line if there is always only one result, otherwise will give error)
$result = mysql_fetch_assoc($res);

// if you uncomment the next line it prints out the whole result as an array (prints out the image as weird characters)
// print_r($result);

// print out specific information (not the whole array)
   echo "id: ".$result['id']."<br />";
echo "username: ".$result['username']."<br />";
   echo "type: ".$result['type']."<br />";
   echo "title: ".$result['title']."<br />";
   echo "description: ".$result['description']."<br />";  
echo "county: ".$result['county']."<br />";
   echo "town: ".$result['town']."<br />";
   echo "phone: ".$result['phone']."<br />";
   echo "rooms: ".$result['rooms']."<br />";
   echo "bath: ".$result['bath']."<br />";
   echo "squa  ".$result['square']."<br />";
echo "rent: ".$result['rent']."<br />";
echo "time: ".$result['time']."<br />";

?>I know there is something wrong with this cause I always get the same info no matter which apartment I click. Do I use the $_GET function and how do I implement this?

I have two tables categories and subcategories and what I want do is display them but here I ran into problem displaying the subcategories. Here's the code that doesn't work, all it does it displays categories.
$query = "SELECT ID,name FROM `categores`";
        $result = mysql_query($query) or die(mysql_error());
       
        while($row = mysql_fetch_array($result))
        {
        echo $row['name'];
        $id_main=$row['ID'];
        $query2 ="SELECT name_subcategory FROM subcategories WHERE id_main_category=".$row['ID'];
        $result2 = mysql_query($query2) or die(mysql_error());
        while ($row2=mysql_fetch_array($result2));
        {       
            echo $row2['name_subcategory']; 
        }
        echo "<br />";
        }

Display should be
-category
--subcategory
--subcategory
-another category
--subcategory of "another category"
.
.
.

Hi there

I'm trying to work out how I'd go about searching my database for URLs that have been submitted by users that are duplicates.
Now this isn't as simple as http://www.example.com/something.php and http://www.example.com/something.php oh no!

People have entered links such as http://www.example.com//something.php or http://www.example.com///something.php

The script (I didn't write it) currently see's these links as unique, but they're not. They function exactly the same way.

Anyone have any advice on how to weed these out?

I was thinking maybe a straight forward LIKE '%//%' in the mySQL syntax, but this will bring all URLs up due to the http:// aspect of the link

Any feedback would be appreciated!

Hi.. been a while since I have touched php and need some help. What I am trying to do is have my links pull text from separate php files, and load them into main table. Here is my old php code..used to work..
I had my index.php with my website template on it. In the table I want my info to appear i put this code.

<?php /* START MAIN AREA HERE */
if($news) include("news.php");
elseif($bio) include("bio.php");
elseif($draw) include("draw.php");
elseif($pic) include("pic.php");
else include("news.php");
/* END HERE */?>

My link looks like this.

<A HREF="?news=x"
            ONMOUSEOVER="changeImages('home', 'images/home-over.gif'); return true;"
            ONMOUSEOUT="changeImages('home', 'images/home.gif'); return true;">
            <IMG NAME="home" SRC="images/home.gif" WIDTH=69 HEIGHT=31 BORDER=0 ALT=""></A>

Any help much appreciated!