PHP & MySQL: sort desending and print

Tags

shell scripts

Top Forums Shell Programming and Scripting PHP & MySQL: sort desending and print

08-26-2003

Registered User

143, 0

Join Date: Aug 2002

Last Activity: 30 March 2011, 8:28 AM EDT

Location: Ireland

Posts: 143

Thanks Given: 0

Thanked 0 Times in 0 Posts

PHP & MySQL: sort desending and print

How do i get php to sort the times in a table and print order desending. eg:

in the table i have: 02:60.00
02:70.00
02:20.00
02:50.00
in that order in a table

how do i get php & mysql to print it in order by the smallest time first like this:

02:20.00
02:50.00
02:60.00
02:70.00

perleo

View Public Profile for perleo

Find all posts by perleo

09-02-2003

Registered User

142, 0

Join Date: Jun 2003

Last Activity: 9 May 2008, 12:16 AM EDT

Location: Canada

Posts: 142

Thanks Given: 0

Thanked 0 Times in 0 Posts

Convert the times to epoch, then sort the array according to size, then convert the times back to human-readable.

Karma

View Public Profile for Karma

Find all posts by Karma

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Difference of Sort -n -k2 -k3 & Sort -n -k2,3

Hi, Could anyone kindly show me a link or explain the difference between sort -n -k2 -k3 & sort -n -k2,3 Also, if I like to remove the row with repetition at both $2 and $3, Can I safely use sort -u -k2 -k3 Example; 100 20 30 100 20 30 So, both $2 and $3 are same and I...

2. UNIX for Dummies Questions & Answers

How to create a print filter that print text & image?

Currently, I have a print filter that takes a text file, that convert it into PCL which then gets to a HP printer. This works. Now I need to embedded a image file within the text file. I'm able to convert the image file into PCL and I can cat both files together to into a single document...

3. Shell Programming and Scripting

Sort a the file & refine data column & row format

cat file1.txt field1 "user1": field2:"data-cde" field3:"data-pqr" field4:"data-mno" field1 "user1": field2:"data-dcb" field3:"data-mxz" field4:"data-zul" field1 "user2": field2:"data-cqz" field3:"data-xoq" field4:"data-pos" Now i need to have the date like below. i have just...

4. Shell Programming and Scripting

PHP read large string & split in multidimensional arrays & assign fieldnames & write into MYSQL

Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP. I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you...

5. Web Development

[php] webpage with login & mysql-db

Hi all, What I was looking for before was a multi-user password manager, web-based! The offer of free or cheap tools of this kind is very pover. Or they are too complex (or too expensive) I'm not a web programmer but I now decided to set up a (php) website with login and based on this login...

6. Web Development

Confused maybe about MySQL Dump & PHP

Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So...

7. UNIX for Dummies Questions & Answers

PHP & Apache & MySQL install how-to ?

how do i install php & mysql with apache on suse linux ??? apache was installed and configured when i installed linux. all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/ so how do i install php and get it to work with apache and...

8. UNIX for Dummies Questions & Answers

Linux/Unix/PHP/MySQL & servers?

Hello everyone! First I would like to say that I am very glad that I found this forum, and by some of the posts I have viewed, I see that I can learn a lot from you all! Secondly, I know next to nothing about Linux/Unix (gotta learn sometime right?) and need some assistance. I am a...

Shell Programming and Scripting