To: Snijders, Mark; 'Marco Tabini'; Terry Romine
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] sort by date
There is a difference between a general, how do I do this question and
a
specific here's my code, I can't find the bug question. Sometimes
people
just need a quick answer specific to their code
if i get your point:
1 event can have more dates.. and you wanna show for each event just the
first date...
so you wanna show more from one table as the other one
in that case you should try to use the left join !! so check the manual on
left join
-Original Message-
From: Terry
Ok, going out on a limb here... have you tried something like
select e.id, title, location, address, contact, category, event_time,
urllink, descript, min(event_date) from eventTable e inner join
dateTable d on e.id = d.id group by e.id
?
Marco
--
php|architect - The magazine
why does everybody always gives the answers?? why not a hint, or where to
search that they can learn something about it???
-Original Message-
From: Marco Tabini [mailto:marcot;inicode.com]
Sent: woensdag 6 november 2002 16:08
To: Terry Romine
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
Tabini [mailto:marcot;inicode.com]
Sent: woensdag 6 november 2002 16:08
To: Terry Romine
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] sort by date
Ok, going out on a limb here... have you tried something like
select e.id, title, location, address, contact, category, event_time,
urllink, descript
PROTECTED]
Sent: Wednesday, November 06, 2002 4:22 PM
Subject: RE: [PHP-DB] sort by date
why does everybody always gives the answers?? why not a hint, or where to
search that they can learn something about it???
-Original Message-
From: Marco Tabini [mailto:marcot;inicode.com]
Sent
understand
Ignatius
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: 'Marco Tabini' [EMAIL PROTECTED]; Terry Romine
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 4:22 PM
Subject: RE: [PHP-DB] sort by date
: Re: [PHP-DB] sort by date
11/06/2002
10:29 AM
Just to weigh in on the tail end here, a FAQ of the top N items would be
nice. But I have to say, I use the archives a lot before I post to the list.
The archives contain the answers to most questions out there. If subscribers
to this list checked the archives to see if their answer is there, then
Thanks.
My error seemed to be just in the group declaration. Comparing yours
and mine with slight modifications to yours that eventually worked as
desired:
yours:
select e.id, title, min(event_date) as event_date from eventTable e,
dateTable d where e.id = d.event_key group by e.id;
mine:
10:48 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] sort by date
Just to weigh in on the tail end here, a FAQ of the top N items would be
nice. But I have to say, I use the archives a lot before I post to the
list.
The archives contain the answers to most questions out there. If
subscribers
]
[EMAIL PROTECTED]cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] sort by date
11/06/2002
Besides, if they don't search the archives and newsgroups and Google
already, why would we believe they'd read the FAQ?
Peter
On Wed, 6 Nov 2002, Hutchins, Richard wrote:
Just to weigh in on the tail end here, a FAQ of the top N items would be
nice. But I have to say, I use the archives a lot
I have a manual and use it plus lots of sample code to work through,
but there are times when we hit a wall and a simple second set of
eyes to spot what should be obvious is helpful.
I appreciate having a forum to throw out a question and get a rapid
response. I could have rewritten this
What archive and how do I access it?
-Original Message-
From: Hutchins, Richard [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, November 06, 2002 10:50 AM
Subject: RE: [PHP-DB] sort by date
Just to weigh in on the tail end here, a FAQ of the top N items would
]
Sent: Wednesday, November 06, 2002 10:42 AM
To: Hutchins, Richard; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] sort by date
What archive and how do I access it?
-Original Message-
From: Hutchins, Richard [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday
This is how you'd find it in the future. It's fairly simple.
http://php.net/ -- Mailing Lists -- Databases and PHP archive link YES
OR -- Databases and PHP Newsgroup link Yes
Archives: http://marc.theaimsgroup.com/?l=php-db
Newsgroup: news://news.php.net/php.db
Great! But, many people cannot *understand* the manuals for their own
reasons, that is why they ask - they hope to get some sample code. Shall
we?
--
Maxim Maletsky
[EMAIL PROTECTED]
Peter Beckman [EMAIL PROTECTED] wrote... :
Hey, there are a lot of new people who are starting with PHP.
Peter Beckman [EMAIL PROTECTED] wrote... :
Besides, if they don't search the archives and newsgroups and Google
already, why would we believe they'd read the FAQ?
There are already lots of FAQs, but even you who argue about that do not
know much aboiut. So, an FAQ whether gets incorporated
not a hint, or where to
search that they can learn something about it???
-Original Message-
From: Marco Tabini [mailto:marcot;inicode.com]
Sent: woensdag 6 november 2002 16:08
To: Terry Romine
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] sort by date
Ok, going out on a limb here... have
20 matches
Mail list logo