ansaurus

Question

sort postgres table data in php through array

Answer 1

A:

I suggest to order the rows through SQL (ORDER BY clause). It will be the most efficient way, specially if the date_out column is indexed.

Cătălin Pitiș 2009-10-19 19:49:49

$date = $_POST['date']; $query = "SELECT * from workorders WHERE closed='Y' ORDER BY date_out '$date'";

russell 2009-10-19 19:55:27

This is my sort code. I have another page which asks for a date and posts it to this page. When i run it, it says ###ERROR: non-integer constant in ORDER BY in /var/www/company/accounts/sales.php on line 31

russell 2009-10-19 19:57:14

I am a complete newbie at postgres. Sorry ;)

russell 2009-10-19 19:57:49

Answer 2

+2 A:

I'm not sure why you'd need PHP since this is a job which postgres can easily handle:

SELECT
    visitdate
FROM
    public.statistics
WHERE
    visitdate 
        between date '2009-10-19' and date '2009-10-20'
ORDER BY
    visitdate
OFFSET 2
LIMIT 3;

p3t0r 2009-10-19 19:54:21

Thanks. I need it in php as my program is running through my apache server so i can access it anywhere i go. as i said, my knowledge on postgres is very small. how can i impliment your suggestion in php? thank you

russell 2009-10-19 20:13:52

I'm not a PHP programmer, but I think you might want to start with something like this: http://www.designmagick.com/article/10/Starting-Out/Retrieving-Data-from-your-database

p3t0r 2009-10-20 05:22:04

Answer 3

A:

While you really should do this via SQL, php's strtotime should translate it to a timestamp you can use for integer based comparison.

Kevin Peno 2009-10-20 19:55:13

ansaurus

tags:

views:

answers:

sort postgres table data in php through array

related questions