RE: [PHP-DB] sort by date
It's also a matter of time, I think a lot of people try to be the first to answer something, or are answering from work on a busy day... they just don't have time to write explanations, or to RTFM themselves to verify (I'm guilty of this one), but they want to help. This is especially frustrating when sometimes people are asking for things that aren't obvious, and it takes 2 or 3 posts of them saying "no that won't work because..." before what they're *really* trying to do comes out. You write a long, descriptive post and they really are just trying to do something that won't work the way they want it to. :) I try to be polite, and apologize when I've been proven wrong. I think people get too easily frustrated answering the same question over and over, especially when it's something they've known for a long time. I learned almost everything I know (especially in regards to php) from experience and lots of reading, as I'm sure most of us on this list have, and it's just natural to quote a manual page or point someone there to give them a chance to learn on their own. An then sometimes a question is so obvious and has been asked so many times (by people in the list, by most people as they're learning) that the answer is very simple, and automatic. It's easier to say "try [this code]" than to risk insulting someone by saying "hey you should know better that's all wrong, look here and here and here and find the answer". Like I said, I try to be polite, and I'm very patient with people, but honestly, if they're writing a php script and using a database to back it, they're not newbies, or at the very least, they *should* be able to read a manual. -- 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 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. Also, unfortunately, many times when people want to point to a resource they give the standard "RTFM". Believe it or not, many newbies don't always know how to do this!! A polite "it's too long to go into on the list, but you can read more about this here" with a link is much more helpful. -Lisi At 04:22 PM 11/6/02 +0100, Snijders, 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] >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, 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 PHP Professionals >The first monthly worldwide magazine dedicated to PHP programmer > >Come visit us at http://www.phparch.com! > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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. Also, unfortunately, many times when people want to point to a resource they give the standard "RTFM". Believe it or not, many newbies don't always know how to do this!! A polite "it's too long to go into on the list, but you can read more about this here" with a link is much more helpful. -Lisi At 04:22 PM 11/6/02 +0100, Snijders, 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] 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, 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 PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
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 into this mailing list or we answer mostly with the links to FAQs. There is really no other way. -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
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. We all are > here to help people learn how to use PHP because we are all PHP fans and > want the world to use PHP. register_globals is an issue that us more > advanced folk know about and deal with on a regular basis. There are lazy > people who don't know how to use a manual. However, we've got the ability > here to help people who don't know about or how to use the manual. And > honestly, some questions are more difficult than the manual provides, > especially if you aren't sure where to look. > > How's this? Anytime someone posts a potential answer, post the manual page > for the function, SQL reference or something related. That way it's in the > newsgroup and the archives. People DO search the archives, while some > people don't. > > We can't all expect everyone to be as smart and as knowledgable about PHP > as some of the people on this list are. So give them a chance and help > them learn how to learn instead of getting mad. And if you get mad, maybe > this isn't the right place for you to be! I mean that in the nicest > sense; the world is filled with idiots, and this list is here to help both > idiots and geniuses get through their stumbling blocks by being an > intelligent, helpful and friendly community. At least that's what I hope > this is. > > Peter > > On 6 Nov 2002, Marco Tabini wrote: > > > Well, excuse me for being a bit cynical, but it's hard to be > > philosophical with a deadline hanging over your head. It's true that > > most of the questions can be answered by looking at the manual, but you > > also have to assume the possibility that the person who's asking them > > has a real and immediate need for the answers--at least that's the way I > > try to think. > > > > One thing that would be great, IMHO, would be to start putting together > > a little FAQ, like many other mailing lists have, that gets updated and > > posted to the list once a month... it could contain answers to the most > > frequently asked questions--anybody who's tired of answering that > > register_globals has been turned off in recent versions raise your hand! > > :-) > > > > > > Marco > > -- > > > > php|architect - The magazine for PHP Professionals > > The first monthly worldwide magazine dedicated to PHP programmer > > > > Come visit us at http://www.phparch.com! > > > > > > --- > Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation > [EMAIL PROTECTED] http://www.purplecow.com/ > --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
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 Peter On Wed, 6 Nov 2002, dwalker wrote: > What archive and how do I access it? --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
Go here: http://www.php.net/mailing-lists.php and scroll down to find the archive for your type of question. Just click and search away - no subscription necessary. Lots of good help in there if you're diligent. > -Original Message- > From: dwalker [mailto:dwalker@;healthyproductsplus.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]> > 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 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 > >questions like register_globals might decrease in frequency. > > > >The other side effect of researching answers for yourself > before posting is > >that you gain exposure to more of the language faster. How > many times do > you > >read about something that doesn't solve your immediate > problem, but puts an > >idea into your head as to how you might handle a future > situation? I know I > >benefit from it. > > > >Still, nothing better than being able to get help from some > of the seasoned > >pros on this list right away. > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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, 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 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 >questions like register_globals might decrease in frequency. > >The other side effect of researching answers for yourself before posting is >that you gain exposure to more of the language faster. How many times do you >read about something that doesn't solve your immediate problem, but puts an >idea into your head as to how you might handle a future situation? I know I >benefit from it. > >Still, nothing better than being able to get help from some of the seasoned >pros on this list right away. > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
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 problem, taking the wrong way around and spending more time than my client would like. This way I not only have the solution, but the reason behind it, as well. Thanks again. Terry On Wednesday, November 6, 2002, at 09:35 AM, [EMAIL PROTECTED] wrote: Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
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 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 > questions like register_globals might decrease in frequency. > > The other side effect of researching answers for yourself before posting is > that you gain exposure to more of the language faster. How many times do you > read about something that doesn't solve your immediate problem, but puts an > idea into your head as to how you might handle a future situation? I know I > benefit from it. > > Still, nothing better than being able to get help from some of the seasoned > pros on this list right away. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Hey, there are a lot of new people who are starting with PHP. We all are here to help people learn how to use PHP because we are all PHP fans and want the world to use PHP. register_globals is an issue that us more advanced folk know about and deal with on a regular basis. There are lazy people who don't know how to use a manual. However, we've got the ability here to help people who don't know about or how to use the manual. And honestly, some questions are more difficult than the manual provides, especially if you aren't sure where to look. How's this? Anytime someone posts a potential answer, post the manual page for the function, SQL reference or something related. That way it's in the newsgroup and the archives. People DO search the archives, while some people don't. We can't all expect everyone to be as smart and as knowledgable about PHP as some of the people on this list are. So give them a chance and help them learn how to learn instead of getting mad. And if you get mad, maybe this isn't the right place for you to be! I mean that in the nicest sense; the world is filled with idiots, and this list is here to help both idiots and geniuses get through their stumbling blocks by being an intelligent, helpful and friendly community. At least that's what I hope this is. Peter On 6 Nov 2002, Marco Tabini wrote: > Well, excuse me for being a bit cynical, but it's hard to be > philosophical with a deadline hanging over your head. It's true that > most of the questions can be answered by looking at the manual, but you > also have to assume the possibility that the person who's asking them > has a real and immediate need for the answers--at least that's the way I > try to think. > > One thing that would be great, IMHO, would be to start putting together > a little FAQ, like many other mailing lists have, that gets updated and > posted to the list once a month... it could contain answers to the most > frequently asked questions--anybody who's tired of answering that > register_globals has been turned off in recent versions raise your hand! > :-) > > > Marco > -- > > php|architect - The magazine for PHP Professionals > The first monthly worldwide magazine dedicated to PHP programmer > > Come visit us at http://www.phparch.com! > > --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- --- Begin Message --- Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. "Ignatius Reilly" To: "Snijders, Mark" <[EMAIL PROTECTED]>, "'Marco Tabini'" , "Terry Romine" <[EMAIL PROTECTED]> [EMAIL PROTECTED]>cc: <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] sort by date 11/06/2002 10:29 AM Good point. "Tell me and I forget, show me and I remember, involve me and I 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 > 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 >
RE: [PHP-DB] sort by date
I agree, but in regard to your last paragraph, you're assuming that they read your post and respond to it. Everybody's quick to answer simple redundant questions that every programmer *should* know the answer to, but higher level stuff seems to just get ignored. I'd hope in a high-frequency list like this the converse would be true. Where are the "seasoned pros" when somebody is asking a hard question, or asking for alternative approaches to a problem? -- Josh -Original Message- From: Hutchins, Richard [mailto:Richard.Hutchins@;GetingeCastle.com] Sent: 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 there. If subscribers to this list checked the archives to see if their answer is there, then questions like register_globals might decrease in frequency. The other side effect of researching answers for yourself before posting is that you gain exposure to more of the language faster. How many times do you read about something that doesn't solve your immediate problem, but puts an idea into your head as to how you might handle a future situation? I know I benefit from it. Still, nothing better than being able to get help from some of the seasoned pros on this list right away. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
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: select e.*,min(d.event_date) as event_date from eventTable e,dateTable d where e.id = d.event_key group by d.event_date,d.event_key; As you see, I was already trying to do a join, but the group by was throwing me. Terry On Wednesday, November 6, 2002, at 09:15 AM, Marco Tabini wrote: My guess? Because we're all professionals at work and trying to solve a specific problem...since we're adults, I guess the learning part should be up to each of us--the information is certainly there even in the answer. :-) Marco -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 to this list checked the archives to see if their answer is there, then questions like register_globals might decrease in frequency. The other side effect of researching answers for yourself before posting is that you gain exposure to more of the language faster. How many times do you read about something that doesn't solve your immediate problem, but puts an idea into your head as to how you might handle a future situation? I know I benefit from it. Still, nothing better than being able to get help from some of the seasoned pros on this list right away. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Well, excuse me for being a bit cynical, but it's hard to be philosophical with a deadline hanging over your head. It's true that most of the questions can be answered by looking at the manual, but you also have to assume the possibility that the person who's asking them has a real and immediate need for the answers--at least that's the way I try to think. One thing that would be great, IMHO, would be to start putting together a little FAQ, like many other mailing lists have, that gets updated and posted to the list once a month... it could contain answers to the most frequently asked questions--anybody who's tired of answering that register_globals has been turned off in recent versions raise your hand! :-) Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! --- Begin Message --- Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. "Ignatius Reilly" To: "Snijders, Mark" <[EMAIL PROTECTED]>, "'Marco Tabini'" , "Terry Romine" <[EMAIL PROTECTED]> [EMAIL PROTECTED]>cc: <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] sort by date 11/06/2002 10:29 AM Good point. "Tell me and I forget, show me and I remember, involve me and I 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 > 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] 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 - The magazine for PHP Professionals > The first monthly worldwide magazine dedicated to PHP programmer > > Come visit us at http://www.phparch.com! > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. "Ignatius Reilly" To: "Snijders, Mark" <[EMAIL PROTECTED]>, "'Marco Tabini'" , "Terry Romine" <[EMAIL PROTECTED]> [EMAIL PROTECTED]>cc: <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] sort by date 11/06/2002 10:29 AM Good point. "Tell me and I forget, show me and I remember, involve me and I 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 > 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] 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 - The magazine for PHP Professionals > The first monthly worldwide magazine dedicated to PHP programmer > > Come visit us at http://www.phparch.com! > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Good point. "Tell me and I forget, show me and I remember, involve me and I 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 > 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] 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 - The magazine for PHP Professionals > The first monthly worldwide magazine dedicated to PHP programmer > > Come visit us at http://www.phparch.com! > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
My guess? Because we're all professionals at work and trying to solve a specific problem...since we're adults, I guess the learning part should be up to each of us--the information is certainly there even in the answer. :-) Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! --- Begin Message --- 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] 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 - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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: 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, 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 PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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, 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 PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! --- Begin Message --- 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|| | address | varchar(100) | YES | | NULL|| | contact | varchar(100) | YES | | NULL|| | category | varchar(100) | YES | | NULL|| | event_time| varchar(200) | YES | | NULL|| | urllink | varchar(100) | YES | | NULL|| | descript | text | YES | | NULL|| | id | int(11) | | PRI | 0 | auto_increment | | event_key | int(11) | YES | | NULL|| | event_date | date| YES | | NULL|| They are linked via dateTable.event_key=eventTable.id I want to be able to sort by the first date that the event takes place. I tried: $sql="select e.*,d.event_date from eventTable e,dateTable d where e.id=d.event_key order by d.event_date,d.event_key but it still shows each date that the event takes place. I tried doing a min(d.event_date) as event_date and then "group by" instead of "order by" but still get too many results. Any help to straighten this out? Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
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 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 | auto_increment | | title | varchar(100) | YES | | NULL|| | location | varchar(100) | YES | | NULL|| | address | varchar(100) | YES | | NULL|| | contact | varchar(100) | YES | | NULL|| | category | varchar(100) | YES | | NULL|| | event_time| varchar(200) | YES | | NULL|| | urllink | varchar(100) | YES | | NULL|| | descript | text | YES | | NULL|| | id | int(11) | | PRI | 0 | auto_increment | | event_key | int(11) | YES | | NULL|| | event_date | date| YES | | NULL|| They are linked via dateTable.event_key=eventTable.id I want to be able to sort by the first date that the event takes place. I tried: $sql="select e.*,d.event_date from eventTable e,dateTable d where e.id=d.event_key order by d.event_date,d.event_key but it still shows each date that the event takes place. I tried doing a min(d.event_date) as event_date and then "group by" instead of "order by" but still get too many results. Any help to straighten this out? Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 | auto_increment | | title | varchar(100) | YES | | NULL|| | location | varchar(100) | YES | | NULL|| | address | varchar(100) | YES | | NULL|| | contact | varchar(100) | YES | | NULL|| | category | varchar(100) | YES | | NULL|| | event_time| varchar(200) | YES | | NULL|| | urllink | varchar(100) | YES | | NULL|| | descript | text | YES | | NULL|| | id | int(11) | | PRI | 0 | auto_increment | | event_key | int(11) | YES | | NULL|| | event_date | date| YES | | NULL|| They are linked via dateTable.event_key=eventTable.id I want to be able to sort by the first date that the event takes place. I tried: $sql="select e.*,d.event_date from eventTable e,dateTable d where e.id=d.event_key order by d.event_date,d.event_key but it still shows each date that the event takes place. I tried doing a min(d.event_date) as event_date and then "group by" instead of "order by" but still get too many results. Any help to straighten this out? Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php