Phases_OgMaxim posted:

---

This morning and set a $first variable at 1001, but it's not automated. But that's okay because I have a -404.jpg image in there anyway that might mess that up, for when people try to mess with the ID manually and put in something other than what I have comics for.

---

Phases_OgMaxim posted:

---

Oh, I should mention that the button's aren't traditional, they're just css/links.

But, that wouldn't seem to matter with your last post. That looks interesting..

---

beibhinn posted:

---

I've no idea what went on in this thread, but whatever it was - it was awesome

---

Phases_OgMaxim posted:

---

Do you know if it's possible to have <li> or <ol> but not have it break lines? so instead of the output being

1.
2.
3.

I can have 1. 2. 3. ?

---

beibhinn posted:

---

I've no idea what went on in this thread, but whatever it was - it was awesome

---

PHP code

---

$query = "SELECT ID, FeaturedCharacter, Rank, Average, TotalVotes, FivePoints, FourPoints, ThreePoints, TwoPoints, OnePoints, DateUpdated, Poll FROM TsundereOrNot ORDER BY ID DESC LIMIT $offset, $rowsPerPage";

---

1. The most straightforward is to make the headers links to the current page but with a parameter telling which column to sort by (and optionally, whether it's descending or not):
   

   <a href="<?=$_SERVER['SCRIPT_NAME']?>?p=<?=$pageNum?>&orderby=Rank&desc=0">Rank</a>

   
   In the PHP code, check for the orderby command, verify that it's one of the values you expect, then change your SQL statement to order by that field. Let me just re-iterate that you should verify anything given to you by the user, especially if you're going to use it in an SQL statement; if you don't, then you're vulnerable to SQL injection attacks, among others.
   
   For example:
   

   $valid_orderby = array("ID", "FeaturedCharacter", "Rank", "Average", "TotalVotes", "DateUpdated");
   $orderby = $valid_orderby[0];
   if (isset($_GET['orderby']) && in_array($_GET['orderby'], $valid_orderby))
   {
   $orderby = $_GET['orderby'];
   }
   
   $desc = "";
   if ($_GET['desc'])
   {
   $desc = "DESC";
   }
   
   $query = "SELECT * FROM TsundereOrNot ORDER BY $orderby $desc LIMIT $offset, $rowsPerPage";

   To make it so clicking on a header toggles DESC, one way is to use a function:
   

   function is_desc($header)
   {
   global $orderby;
   
   if ($header == $orderby)
   {
   return !$_GET['desc'];
   }
   return false; // Optionally you can specify defaults per-column here
   }

   
   And then in the URL above, use &desc=<?=is_desc('Rank')?>
   (I haven't tested any of this code, so there may be bugs or typos).


2. Another way is to put all of the table data in a javascript array, and use javascript to generate the table and do the sorting. This has the benefit that it's fast -- it doesn't require a page reload to sort the data. However, it can only be used if all of the data fits on one page, which doesn't seem to be the case here.


3. The most complicated way that combines the best of options 1 and 2, is to use AJAX to retrieve the data from the server in either XML or JSON format. Whenever you want to sort or change pages, you just make an AJAX request with the new parameters, then repopulate the table using javascript. I'd only recommend this if you like playing around with new stuff and want to learn about AJAX. It could take a long time to get it working if you've never used AJAX or more advanced javascript before.

-FIGS- posted:

---

I want your brain Raiztlin!!

---