Forum Moderators: coopster

Message Too Old, No Replies

Sorting Data in PHP

         

bubster119

12:26 pm on Apr 12, 2007 (gmt 0)

10+ Year Member



I'm trying to research into how I can create a page on my portfolio site in which the user can sort through my work by "date" and "genre".

I was hoping to get it to work in such a way that the full content is displayed on the screen (images and text) but if this is too complicated I'd settle for just a list of links to the work which the user can sort.

I'm not sure if this is achievable solely through PHP or whether it's going to have to be a PHP/MySQL process.

I've searched the archives here and the web but as I'm not really sure what this process is referred to as and what technology it uses I've drawn a blank.

Any pointers in the right direction or if anyone feel generous enough to provide some links, I'd really appreciate it.

Cheers

Scally_Ally

12:52 pm on Apr 12, 2007 (gmt 0)

10+ Year Member



The most traditional way i think would be to have all off you work (titles, dates etc) in a mysql database. These pieces of work could then be drawn from the database, ordered by date, to display your work in a relevant order.

Another way would be to have all of the titles of your work, along with dates created and other information stored in a text file - php could then search through this text file and see what dates correspond to which piece of work.

Hope this helps

Ally

bubster119

1:03 pm on Apr 12, 2007 (gmt 0)

10+ Year Member



Thats great Ally, I'll have a search around.

If anyone has any useful link relating to this I'd appreciate it.

Thanks

Scally_Ally

1:16 pm on Apr 12, 2007 (gmt 0)

10+ Year Member



I think finding a tutorial on running both php and mysql together would be good, there are loads out there. The traditional guest book tutorial would be good as it will give you insight into ordering

[google.co.uk ]

and then maybe this

[w3schools.com ]

[w3schools.com ]

Ally

bubster119

1:28 pm on Apr 12, 2007 (gmt 0)

10+ Year Member



Thanks alot Ally