Josh
-Original Message-
From: Lisi [mailto:lists@;shemeshdirectory.co.il]
Sent: Thursday, November 07, 2002 2:23 AM
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
ers, Mark wrote:
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]
Subje
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
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.
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/ph
ctsplus.com]
> 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
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
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 prob
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 lo
Reilly" To: "Snijders, Mark"
<[EMAIL PROTECTED]>, "'Marco Tabini'"
, "Terry Romine"
<[EMAIL PROTECTED]>
[EMAIL PROTECTED]>cc: <
t: Wednesday, November 06, 2002 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
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:
sel
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
;" <[EMAIL PROTECTED]>; "Terry Romine"
<[EMAIL PROTECTED]>
Cc: <[EMAIL 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 lea
IL PROTECTED]>, "'Marco Tabini'"
, "Terry Romine"
<[EMAIL PROTECTED]>
[EMAIL PROTECTED]>cc: <[EMAIL PROTECTED]>
ROTECTED]>; "Terry Romine"
<[EMAIL PROTECTED]>
Cc: <[EMAIL 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
rom: 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 you tried something like
select e.id, title, location, address, contact, category, event_time,
urllink
-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, min(event_date) from eventTable e inner join
dateTable d on e.id = d.id group by e.id
?
Marco
--
php|architect
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 for
Romine [mailto:eatrom@;blazing-trails.com]
Sent: woensdag 6 november 2002 15:55
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sort by date
I have two tables, one contains event information and the other dates
that the event takes place:
| id| int(11) | | PRI | 0
I have two tables, one contains event information and the other dates
that the event takes place:
| id| int(11) | | PRI | 0 | auto_increment |
| title | varchar(100) | YES | | NULL||
| location | varchar(100) | YES | | NULL
21 matches
Mail list logo
