reordering content

[afe]

roddyinnovations.com/?action=resources&cat=81

hello, I was wondering how to make that. Where the visitor is able to reorder the content posted and the content is like that in those boxes. Can anyone please help me!! Please and thank you! Also how would I be able to reorder from a star rater that I have?

[BLiZZaRD]

Easiest way is to use PHP/SQL mix. When an item is added you supply the SQL with name, date, star rating, whatever, in a table(s).

Then use php to run a search on the SQL when a link is clicked. The php will tell the page (post, self) to reload with the new data. Sort by date/name/rating etc. asc or desc.

[afe]

Blizzard you are a genious! Ok, now where do I start? Please and thank you!

[BLiZZaRD]

After a bit of research, we can do this in pure PHP if you like.

Read up on the php sort() functions here with particular attention to msort() and ksort().

easier!

Edit:
it appears that msort is now know as array_multisort()

[afe]

Thanks!

[afe]

Ok, I have read that link and also array_multisort() and I think I get the idea, so now what?

[BLiZZaRD]

well, now you set up your page. Forget the php for right now. make the links in regular html like click here for by date, click here for by name, etc.

Once you have that you choose the best method of sort() and put the php code in. Then you can go back to your html links and add the php code with all the variables so it will know what to do.

[afe]

http://www.athletes4excellence.com/sortexample.php

I am not sure how to do the links, and also on "Ajax Help" from your amazing help, I figured out how to fix the star raters! Thanks a lot!

[BLiZZaRD]

Okay, where you have this:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>

    <td>Sorth by: A to Z | Z to A | Top Rated to Least Rated | Least Rated to Top Rated </td>
  </tr>
</table>

Ignoring the typos and the fact you are using tables...

<td>Sort by: <a href="http://www.athletes4excellence.com/sortexample.php#"> A to Z</a> | <a href="http://www.athletes4excellence.com/sortexample.php#">Z to A</a> |
etc etc..
</td>

That will make them basic links for now. Then you can work on the php coding for the sorting.

[afe]

http://www.athletes4excellence.com/sortexample.php