times clauses - Search results in mailing lists
Mailing lists >> pgsql-php >> Thread
2009-04-18 18:31:31 | Re: sorting query results (Andrew McMillan)
clause in the SQL, whereas the sorting in PHP would often change the whole way the query results are processed. Another approach I have seen used, which you don't mention
Mailing lists >> pgsql-php >> Thread
2006-10-16 23:02:43 | Re: plpgsql returning array (Jean-Christophe Roux)
time to understand it and see how it can improve codes.
----- Original Message ----
From: Marc McIntyre
Mailing lists >> pgsql-php >> Thread
2006-04-29 18:32:14 | Re: PHP Newbie- Display Aggregates in HTML Table (Tommy Gildseth)
time)'], but it doesn't, imo, look very nice. The reason why your query doesn't work, is because you're trying to use an agregate function without a group by clause
Mailing lists >> pgsql-php >> Thread
2006-02-28 16:33:29 | Re: selecting records by timestamp (date) (Jason Minion)
clause. Also, note that your create table statement lists your table name as "ValueLog" - try and make sure that you aren't having case problems. You may need to enclose the table name in double
Mailing lists >> pgsql-php >> Thread
2004-03-17 16:22:05 | Query Problem (David Costa)
clause or be used in an aggregate function any idea? we kept trying for hours to no avail *sigh* :'( thanks in advance for your time
Mailing lists >> pgsql-php >> Thread
2003-02-02 16:53:57 | Re: Left Join SQL Help (Gerard Samuel)
time LIMIT 10 OFFSET 0; Not a definate answer to the problem, but so far in the actual code it looks like a probable solution.. Lonnie VanZandt wrote: >Add a select DISTINCT clause
Mailing lists >> pgsql-php >> Thread
2002-11-21 13:03:20 | Selecting distinct records (Dave [Hawk-Systems])
clause for the user=User1 we end up missing some of user1's entries where another users identical sessionid appears first. What I am looking to do is - grab every record for $user - remove
Mailing lists >> pgsql-php >> Thread
2002-01-21 23:12:17 | Re: PHP Abstraction layers (Manuel Lemos)
clause functionality but in a way that works in all supported database besides MySQL ( PostgreSQL, Oracle, MS SQL server, Interbase, Informix, MiniSQL, ODBC, etc..). This is important for display query results split in multiple pages
Mailing lists >> pgsql-php >> Thread
2001-04-06 11:59:47 | Re: Sorting after a search (Steve Werby)
clause to the SQL statement? It should be much faster to sort the records within PostgreSQL than within PHP. I'd suggest building your SQL statement dynamically. $sql = "SELECT * FROM table1 WHERE surname LIKE '$NAME