Re: query quandary

2002-08-14 Thread Dan Nelson
In the last episode (Aug 14), Mark Jones said: > Thank you!!! It works!! > > I'm curious how the creation of the temporary table would behave in a > web server environment. At which point does mysql delete the temp > table? After the db connection instituted by the script disconnects > (in my

Re: query quandary

2002-08-14 Thread Mark Jones
ected)? Again, many flowers. Mark Jones - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: "Mark Jones" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 9:44 AM Subject: Re: query quandary > Mark, > > I&

Re: query quandary

2002-08-13 Thread DL Neil
Mark, I'm a great believer in 'divide and conquor', so let's take your clear statement of problem and knowing that we can't achieve it by brute force/direct attack, let's break it down and solve it a piece at a time: table contains title and date of records a) sort so that records are listed by

query quandary

2002-08-11 Thread Mark Jones
I have a query I'm trying to construct on a table which contains a title and date of records. I want to sort the query so that records are listed by title with the newest dates first--keeping the records with identical titles together and order by date within the title groups. For example: T