Re: [nyphp-talk] The page you are tring to view contains POSTDATA ...

2007-06-03 Thread Michael B Allen
On Sun, 3 Jun 2007 23:17:30 -0400 Michael B Allen <[EMAIL PROTECTED]> wrote: > One special case is the search box which uses POST so I'll have to use > some JavaScript to make that use GET. Actually what am I talking about, I can just set the form method to GET. Feeling stupid, Mike

Re: [nyphp-talk] The page you are tring to view contains POSTDATA ...

2007-06-03 Thread Michael B Allen
On Sun, 03 Jun 2007 18:53:03 -0400 Chris Shiflett <[EMAIL PROTECTED]> wrote: > Michael B Allen wrote: > > If you hit the browser's Back button after submitted POST, that dialog > > box pops up that reads: > > > > "The page you are trying to view contains POSTDATA ... To resend the > > data hit

Re: [nyphp-talk] PHP array_unique vs. SQL DISTINCT

2007-06-03 Thread David Krings
Adrian Noland wrote: The key to speedy SQL is in the indexes. Without an index the SQL engine iterates over every row. With an index it automagically grabs the correct value. This is really an eyeopener. After indexing all those columns that come up in some selects running the same query that

Re: [nyphp-talk] PHP array_unique vs. SQL DISTINCT

2007-06-03 Thread David Krings
Adrian Noland wrote: The key to speedy SQL is in the indexes. Without an index the SQL engine iterates over every row. With an index it automagically grabs the correct value. Good to know. I heard about indices before, but wasn't really aware that they have such a huge impact. Since my days o

Re: [nyphp-talk] The page you are tring to view contains POSTDATA ...

2007-06-03 Thread Chris Shiflett
Michael B Allen wrote: > If you hit the browser's Back button after submitted POST, that dialog > box pops up that reads: > > "The page you are trying to view contains POSTDATA ... To resend the > data hit Ok. Otherwise hit Cancel." > > The way I see it, this message box must NEVER appear on a

[nyphp-talk] The page you are tring to view contains POSTDATA ...

2007-06-03 Thread Michael B Allen
Good Afternoon NYPHP Talk, If you hit the browser's Back button after submitted POST, that dialog box pops up that reads: "The page you are trying to view contains POSTDATA ... To resend the data hit Ok. Otherwise hit Cancel." The way I see it, this message box must NEVER appear on a professio

Re: [nyphp-talk] PHP array_unique vs. SQL DISTINCT

2007-06-03 Thread Adrian Noland
On 6/3/07, David Krings <[EMAIL PROTECTED]> wrote: David Krings wrote: > Hi! > > Which one is faster: PHP array_unique or SQL DISTINCT ? > OK, while I still like to know what the answer is, the DISTINCT wasn't the culprit, but the way I join the tables. I ran the query across only two tables an

[nyphp-talk] Google Gears / Apollo / FF3 ...

2007-06-03 Thread Jon Baer
Anyone played w/ it yet? Just saw that Apollo will *also* support SQLite in the end (and combine APIs w/ Google) ... http://www.mikechambers.com/blog/2007/05/30/apollo-beta-will-include- sqlite-embedded-database/ Does it mean the end of P(*) + MySQL on the backend? ;-) While I don't think

Re: [nyphp-talk] PHP array_unique vs. SQL DISTINCT

2007-06-03 Thread David Krings
David Krings wrote: Hi! Which one is faster: PHP array_unique or SQL DISTINCT ? OK, while I still like to know what the answer is, the DISTINCT wasn't the culprit, but the way I join the tables. I ran the query across only two tables and with that got millions of records when I expected onl

[nyphp-talk] PHP array_unique vs. SQL DISTINCT

2007-06-03 Thread David Krings
Hi! Which one is faster: PHP array_unique or SQL DISTINCT ? I learned about the DISTINCT key word for SQL some time ago and remember that pro developers always told me that SQL is faster than code. I tested a slightly complex select query across three tables and used DISTINCT. The tables have