Re: [PHP] Clarity needed
At 9:48 AM +0200 2/6/09, Thodoris wrote: There is a very good schema for doing thing like that in this pdf. Its main purpose is to explain join temporary, tables and transactions but you will find it useful because I think it is relevant with your case. http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf Why don't you give it a try. Yes, I did read it and it most certainly fits part of the problem I'm facing. In fact, it says the same things that all my other MySQL books do. The problem is that sometimes, regardless of all that you read, it's good to see how others solve similar problems. Keep in mind that not all problems fall into the camp of requiring such in-depth solutions. Sometimes, the full-blown solution can be an overkill. So, discussing such things on this list does exactly as the subject line indicated -- it provides clarity. Thanks everyone, Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
On Fri, Feb 6, 2009 at 1:13 PM, tedd tedd.sperl...@gmail.com wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I think people should just be wise enough to understand the world they live in, how things work, and when people are puppets. There are lots of ways to find information out there... -- http://www.voom.me | EFnet: #voom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
On Friday 06 Feb 2009 18:13:02 tedd wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Yes even the BBC who are under governmental bill to be impartial get round the issue by saying that it's the particular reporter/author of the article that is being biased rather than the BBC as a collective entity... signature.asc Description: This is a digitally signed message part.
Re: [PHP] Clarity needed
***RANT WARNING*** Shawn McKenzie schreef: Jochem Maas wrote: Daniel Brown schreef: On Thu, Feb 5, 2009 at 07:56, Jochem Maas joc...@iamjochem.com wrote: and the answer to you Q, like everyone else said: yup :-) PS - given you unlimited resources you might consider doing a charitable donation to FoxNews aficionados :-) Or reminding you how to speak English, Jochem. What the hell are you trying to say here?!? ;-P that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Man, a guy disappears for a while and his speech goes to gibberish almost as bad as my own. ;-P almost :-P Or fox may go someway towards dulling the socialist propaganda of the tutors/courses. I didn't assume any particular leaning on the part of the education resource in question ... merely that to count as education I would require ciriculum to foster peoples ability to question/analyse/research for *themselves*, but heck, why bother when Bill O'Reilly can do it for you right? We're headed there, but thank God I'm not schreefing from an insanely socialist country! :-) ir dismissive to call something insane just because you either don't understand it or don't agree with it. not to mention that my country 'boasts' a rather wide spectrum political viewpoints, many of which are hardly socialist. ... and it certainly wasn't socialists that shipped countless slaves from Africa to America ... but the culprits we're often dutch. oh and here's a bit of Socialist Doctrine: We hold these truths to be self-evident, that all men are created equal ... not that I'm much of a socialist, mainly because i think all politics is inherently bogus - just a bigpile of strawmen, but wait ... capitalism ... that's working out a treat isn't it (in a gonna make the 'Great Depression' look like a day in park kind of way). with regard to capitalism, were do you think the staple concepts and structures came from? 13th century europe, specifically the 'lowlands', not to mention the AEX (now Euronext), which is generally considered to be the oldest formal stock exchange. ... so stick that in your pipe and smoke it ... oh wait you can't, which is why there's a constant stream of planes touching down here, full of yanks gagging to get shitfaced. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
On Fri, Feb 6, 2009 at 1:35 PM, Jochem Maas joc...@iamjochem.com wrote: ***RANT WARNING*** Shawn McKenzie schreef: Jochem Maas wrote: Daniel Brown schreef: On Thu, Feb 5, 2009 at 07:56, Jochem Maas joc...@iamjochem.com wrote: and the answer to you Q, like everyone else said: yup :-) PS - given you unlimited resources you might consider doing a charitable donation to FoxNews aficionados :-) Or reminding you how to speak English, Jochem. What the hell are you trying to say here?!? ;-P that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Man, a guy disappears for a while and his speech goes to gibberish almost as bad as my own. ;-P almost :-P Or fox may go someway towards dulling the socialist propaganda of the tutors/courses. I didn't assume any particular leaning on the part of the education resource in question ... merely that to count as education I would require ciriculum to foster peoples ability to question/analyse/research for *themselves*, but heck, why bother when Bill O'Reilly can do it for you right? We're headed there, but thank God I'm not schreefing from an insanely socialist country! :-) ir dismissive to call something insane just because you either don't understand it or don't agree with it. not to mention that my country 'boasts' a rather wide spectrum political viewpoints, many of which are hardly socialist. ... and it certainly wasn't socialists that shipped countless slaves from Africa to America ... but the culprits we're often dutch. oh and here's a bit of Socialist Doctrine: We hold these truths to be self-evident, that all men are created equal ... not that I'm much of a socialist, mainly because i think all politics is inherently bogus - just a bigpile of strawmen, but wait ... capitalism ... that's working out a treat isn't it (in a gonna make the 'Great Depression' look like a day in park kind of way). with regard to capitalism, were do you think the staple concepts and structures came from? 13th century europe, specifically the 'lowlands', not to mention the AEX (now Euronext), which is generally considered to be the oldest formal stock exchange. ... so stick that in your pipe and smoke it ... oh wait you can't, which is why there's a constant stream of planes touching down here, full of yanks gagging to get shitfaced. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php WOW! Jochem, you need to relax just a little bit and bring down that blood pressure... And the dutch were hardly the only ones in there.. Greets from Canada -- Bastien Cat, the other other white meat
Re: [PHP] Clarity needed OT
Eric Butera eric.but...@gmail.com wrote in message news:6a8639eb0902061020v793d22b9x1430872c2170b...@mail.gmail.com... On Fri, Feb 6, 2009 at 1:13 PM, tedd tedd.sperl...@gmail.com wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I think people should just be wise enough to understand the world they live in, how things work, and when people are puppets. There are lots of ways to find information out there... -- http://www.voom.me | EFnet: #voom Ok...I'm sure that somewhere in here has to be reference to the original topic, and php...right? Frank...there is isn't there? *sigh* -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
On Fri, Feb 6, 2009 at 1:46 PM, Frank Stanovcak blindspot...@comcast.net wrote: Eric Butera eric.but...@gmail.com wrote in message news:6a8639eb0902061020v793d22b9x1430872c2170b...@mail.gmail.com... On Fri, Feb 6, 2009 at 1:13 PM, tedd tedd.sperl...@gmail.com wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I think people should just be wise enough to understand the world they live in, how things work, and when people are puppets. There are lots of ways to find information out there... -- http://www.voom.me | EFnet: #voom Ok...I'm sure that somewhere in here has to be reference to the original topic, and php...right? Frank...there is isn't there? *sigh* -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Notice the OT appended? :P -- http://www.voom.me | EFnet: #voom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
***FACT WARNING*** Jochem Maas wrote: ***RANT WARNING*** Shawn McKenzie schreef: Jochem Maas wrote: Daniel Brown schreef: On Thu, Feb 5, 2009 at 07:56, Jochem Maas joc...@iamjochem.com wrote: and the answer to you Q, like everyone else said: yup :-) PS - given you unlimited resources you might consider doing a charitable donation to FoxNews aficionados :-) Or reminding you how to speak English, Jochem. What the hell are you trying to say here?!? ;-P that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Man, a guy disappears for a while and his speech goes to gibberish almost as bad as my own. ;-P almost :-P Or fox may go someway towards dulling the socialist propaganda of the tutors/courses. I didn't assume any particular leaning on the part of the education resource in question ... merely that to count as education I would require ciriculum to foster peoples ability to question/analyse/research for *themselves*, but heck, why bother when Bill O'Reilly can do it for you right? Bill is a dumb-ass. I wasn't talking about editorial or commentary, which is expected to be biased. I was talking about unbiased news reporting. We're headed there, but thank God I'm not schreefing from an insanely socialist country! :-) ir dismissive to call something insane just because you either don't understand it or don't agree with it. No , insanity is trying the same thing over and over and expecting a different result, i.e. socialism. not to mention that my country 'boasts' a rather wide spectrum political viewpoints, many of which are hardly socialist. On one point I apologize, though NL is still European socialism, I misinterpreted schreef as German! :-( ... and it certainly wasn't socialists that shipped countless slaves from Africa to America ... but the culprits we're often dutch. oh and here's a bit of Socialist Doctrine: We hold these truths to be self-evident, that all men are created equal ... Well, if you change it up a bit, like We hold these truths to be self evident, that it is the government's responsibility to attempt to make all men equal. then I would agree. not that I'm much of a socialist, mainly because i think all politics is inherently bogus - just a bigpile of strawmen, but wait ... capitalism ... that's working out a treat isn't it (in a gonna make the 'Great Depression' look like a day in park kind of way). Yes, I am down on all politicians as well, however, capitalism works great. What you are seeing now is socialist engineering of the capitalist market, starting with mildly socialist Clinton, moderately to very socialist Bush and then of course hard leftist Obama. The world economy is bolted onto the U.S. economy because European Socialism doesn't work. We're all in for a miserable time as European style socialism takes root and spreads across the U.S. with regard to capitalism, were do you think the staple concepts and structures came from? 13th century europe, specifically the 'lowlands', not to mention the AEX (now Euronext), which is generally considered to be the oldest formal stock exchange. If by lowlands you mean Scotland, then yes I agree. :-) ... so stick that in your pipe and smoke it ... oh wait you can't, which is why there's a constant stream of planes touching down here, full of yanks gagging to get shitfaced. I would be happy if those yanks stayed there permanently :-) I handle my problems by dealing with them, so no need to toke them away. I was just taking a playful stab at you earlier. Not trying to piss you off! -Shawn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
Frank Stanovcak wrote: Eric Butera eric.but...@gmail.com wrote in message news:6a8639eb0902061020v793d22b9x1430872c2170b...@mail.gmail.com... On Fri, Feb 6, 2009 at 1:13 PM, tedd tedd.sperl...@gmail.com wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I think people should just be wise enough to understand the world they live in, how things work, and when people are puppets. There are lots of ways to find information out there... -- http://www.voom.me | EFnet: #voom Ok...I'm sure that somewhere in here has to be reference to the original topic, and php...right? Frank...there is isn't there? *sigh* Yes, 3 tables :-) -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
Shawn McKenzie schreef: ***FACT WARNING*** that would be funny if it wasn't so sad. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed (Really OT)
At 7:35 PM +0100 2/6/09, Jochem Maas wrote: ***RANT WARNING*** oh and here's a bit of Socialist Doctrine: We hold these truths to be self-evident, that all men are created equal ... Socialist Doctrine? Here's a group of people under treat of loss of life tell their government that everyone is created equal and you say that what they said is a Socialist Doctrine? A doctrine that came into being some 140 years later? Look, you are a gifted programmer and I learn a lot from you, but this goes to prove that often we are gifted in only a limited number of subjects. As Will Rogers once said, We're all ignorant, only in different subjects. I say We're all gifted, but not in everything. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
On Fri, Feb 6, 2009 at 13:46, Frank Stanovcak blindspot...@comcast.net wrote: Ok...I'm sure that somewhere in here has to be reference to the original topic, and php...right? Frank...there is isn't there? *sigh* Stick around you'll see this happens frequently. It's considered a Good Thing[tm]. It maintains a level of sanity among the community. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
Daniel Brown danbr...@php.net wrote in message news:ab5568160902061416u10e761dal224ec7177d83e...@mail.gmail.com... On Fri, Feb 6, 2009 at 13:46, Frank Stanovcak blindspot...@comcast.net wrote: Ok...I'm sure that somewhere in here has to be reference to the original topic, and php...right? Frank...there is isn't there? *sigh* Stick around you'll see this happens frequently. It's considered a Good Thing[tm]. It maintains a level of sanity among the community. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! since when have the words 'sanity', and 'programmer' ever been used together outside of the setup for a joke? Frank...still faithfully taking his pills. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
On Fri, Feb 6, 2009 at 17:26, Frank Stanovcak blindspot...@comcast.net wrote: since when have the words 'sanity', and 'programmer' ever been used together outside of the setup for a joke? Frank...still faithfully taking his pills. This guy fits in well 'round there here parts. ;-P -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed (Really OT)
tedd wrote: At 7:35 PM +0100 2/6/09, Jochem Maas wrote: Socialist Doctrine? the community orm? Here's a group of people under treat of loss of life tell their government that everyone is created equal and you say that what they said is a Socialist Doctrine? A doctrine that came into being some 140 years later? and required a tonne of xml to set-up? Look, you are a gifted programmer and I learn a lot from you, but this goes to prove that often we are gifted in only a limited number of subjects. he is ! and his surname sounds like a technology Wanted Senior MAAS Developer, London £35k As Will Rogers once said, We're all ignorant, only in different subjects. I say We're all gifted, but not in everything. we'll never be gifted at everything but it won't stop us trying and pretending we are to clients - the developers motto Cheers, Regards, tedd nath -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed (Really OT)
Nathan Rixham wrote: tedd wrote: At 7:35 PM +0100 2/6/09, Jochem Maas wrote: Socialist Doctrine? the community orm? Here's a group of people under treat of loss of life tell their government that everyone is created equal and you say that what they said is a Socialist Doctrine? A doctrine that came into being some 140 years later? and required a tonne of xml to set-up? Look, you are a gifted programmer and I learn a lot from you, but this goes to prove that often we are gifted in only a limited number of subjects. he is ! and his surname sounds like a technology Wanted Senior MAAS Developer, London £35k As Will Rogers once said, We're all ignorant, only in different subjects. I say We're all gifted, but not in everything. we'll never be gifted at everything but it won't stop us trying and pretending we are to clients - the developers motto Cheers, Regards, tedd nath +5 Funny -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
On Fri, 2009-02-06 at 13:13 -0500, tedd wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Come off it. Look around you, there are government conspiracies everywhere. I shouldn't even be saying this, their silent black helicopters are already after me... I can hear them now... Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
Ashley Sheridan wrote: On Fri, 2009-02-06 at 13:13 -0500, tedd wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Come off it. Look around you, there are government conspiracies everywhere. I shouldn't even be saying this, their silent black helicopters are already after me... I can hear them now... Ash www.ashleysheridan.co.uk What happened to your tin foil hat? -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
On Fri, Feb 6, 2009 at 19:36, Shawn McKenzie nos...@mckenzies.net wrote: What happened to your tin foil hat? Who needs that when your fillings pick up the live and encrypted radio broadcast of the CIA cafeteria lunch schedule? -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed OT
And the pentagon was not hit by a jumbo jet. check the photos and ask yourself 'where are the wings'? Sorry couldn't resist after the conspiracy comment :-P Bastien Sent from my iPod On Feb 6, 2009, at 19:37, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Fri, 2009-02-06 at 13:13 -0500, tedd wrote: At 1:55 AM +0100 2/6/09, Jochem Maas wrote: that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Or to provide clarity to those who think that Fox News is doing harm. Alter all, the main-stream news doesn't like reporting unfavorable things about their favorites celebrities, do they? Keep in mind that not paying taxes by elected officials has not met the same threshold of reporting not knowing how to speak publicly has made. I would rather have all politicians stammer in their speeches and pay their taxes than the other way around. In fact, it would be nice if the politicians would get their facts/words straight. For example, the Speaker of the House just announced that Last month over 500 million people lost their jobs in her support for the importance of rushing the approval of the Stimulus package (whatever that is). In any event, it's interesting to realize that accordingly to her, EVERYONE in the USA lost their job last month and two thirds of the population lost it twice! It would be nice if the Speaker of the House at least realized how many people actually live in the country she represents. BUT -- you didn't hear that on the main-stream news -- or -- if you did, they didn't make much of it, right? However, if Bush had said it, that would have been something different -- it would be headline news and on Saturday Night Live. Clearly, there is a difference in news reporting today. There are no impartial sources -- everything has biases and spin. The days of Walter Cronkite reporting are over. Viva opposing opinions. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Come off it. Look around you, there are government conspiracies everywhere. I shouldn't even be saying this, their silent black helicopters are already after me... I can hear them now... Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
Yannick Mortier wrote: 2009/2/4 tedd t...@sperling.com: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Hi, tedd! Though you might think that this is a stupid task I can recommend you to draw a little entity-relationship model. It quite helps you to overlook the structure of the database that you want to design. It has got different relations between the data and defines a way to represent those in the database. If you are interested in this you can look in wikipedia here: http://en.wikipedia.org/wiki/Entity-relationship_model Since I heard from these models the first time I always use them and I had no more database changes after I started coding since then. Greetings Hey Tedd, Your idea is correct. The keyword you're looking for is 'atomary data', where you have just 1 occurrence of a particular type of information in your entire database. In your case, this translates to: - A single table for tutors (`tutors`) - A single table for courses (`courses`) - A table that combines these two (`tutors_courses`) Basically, what you're doing here is what you did in 'the old days': you're creating a linked list, but on the database level (and more efficient probably; certainly easier to manage). DB queries will cause you some headaches at first, if you're not used to this. You'll be using JOIN instructions to pull data out of the db. I use InnoDB for this type of stuff (it validates the link). Sample query: SELECT `tutors`.`name` AS `tutor_name`, `courses`.`course` AS `course` FROM `tutors_courses` AS `tc` LEFT JOIN `tutors` AS `t` ON `t`.`id` = `tc`.`tutor` LEFT JOIN `courses` AS `c` ON `c`.`id` = `tc`.`course` WHERE whatever you're filter is HTH, Stijn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
tedd schreef: Hi gang: I need some fog removed. does HARPP have anything for that? what about this? : http://www.postcard.org/fog.mp3 and the answer to you Q, like everyone else said: yup :-) PS - given you unlimited resources you might consider doing a charitable donation to FoxNews aficionados :-) I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
On Thu, Feb 5, 2009 at 07:56, Jochem Maas joc...@iamjochem.com wrote: and the answer to you Q, like everyone else said: yup :-) PS - given you unlimited resources you might consider doing a charitable donation to FoxNews aficionados :-) Or reminding you how to speak English, Jochem. What the hell are you trying to say here?!? ;-P Man, a guy disappears for a while and his speech goes to gibberish almost as bad as my own. ;-P -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
Daniel Brown schreef: On Thu, Feb 5, 2009 at 07:56, Jochem Maas joc...@iamjochem.com wrote: and the answer to you Q, like everyone else said: yup :-) PS - given you unlimited resources you might consider doing a charitable donation to FoxNews aficionados :-) Or reminding you how to speak English, Jochem. What the hell are you trying to say here?!? ;-P that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Man, a guy disappears for a while and his speech goes to gibberish almost as bad as my own. ;-P almost :-P -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
Jochem Maas wrote: Daniel Brown schreef: On Thu, Feb 5, 2009 at 07:56, Jochem Maas joc...@iamjochem.com wrote: and the answer to you Q, like everyone else said: yup :-) PS - given you unlimited resources you might consider doing a charitable donation to FoxNews aficionados :-) Or reminding you how to speak English, Jochem. What the hell are you trying to say here?!? ;-P that tedd's unlimited educational resources (tutors/courses) might go someway to undoing all the harm Fox News inflicts on the masses. Man, a guy disappears for a while and his speech goes to gibberish almost as bad as my own. ;-P almost :-P Or fox may go someway towards dulling the socialist propaganda of the tutors/courses. We're headed there, but thank God I'm not schreefing from an insanely socialist country! :-) -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd There is a very good schema for doing thing like that in this pdf. Its main purpose is to explain join temporary, tables and transactions but you will find it useful because I think it is relevant with your case. http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf Why don't you give it a try. -- Thodoris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Clarity needed
Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
On Wed, 2009-02-04 at 17:24 -0500, tedd wrote: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Probably a table of tutors, a table of courses and then a table of links between the two. That way you can use a single query joining the 3 tables together to pull out all the matches for a particular tutor or course. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
2009/2/4 tedd t...@sperling.com Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd Hey, as you said I would suggest 3 tables, one for the tutors, one for the courses and the third, relational table for connecting tutors and courses. I think this is the most flexible way you can do this. -eddy
Re: [PHP] Clarity needed
Yup, that's how I've done it before: tutors - id tutorname courses - id coursename xref_tutors_courses tutor_id course_id But I've been known to do things goofy before. I'm curious to see how other people handle it. -TG - Original Message - From: tedd t...@sperling.com To: php-general@lists.php.net Date: Wed, 4 Feb 2009 17:24:35 -0500 Subject: [PHP] Clarity needed Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
On Wed, Feb 4, 2009 at 17:24, tedd t...@sperling.com wrote:
[snip!]
I understand that I can have one record set up for each tutor, and another
record set up for each course, and then tie the two together by another
record like an assignment. That way I can have as many assignments as I want
tying courses to tutors.
It that the way you guys would do it?
I would, yes. Very basically:
database.tutors:
id INT(8) NOT NULL auto_increment
f_name VARCHAR(32)
l_name VARCHAR(32)
database.courses
id INT(8) NOT NULL auto_increment
class_name VARCHAR(90)
class_description MEDIUMTEXT
database.course_tutors
id INT(8) NOT NULL auto_increment
tutor_id INT(8)
course_id INT(8)
Then just run the query you want based on the following example:
?php
// Database includes, etc
$sql = SELECT course_name,course_description FROM courses WHERE id ;
$sql .= IN (SELECT course_id FROM course_tutors WHERE tutor_id=;
$sql .= '.mysql_real_escape_string($_GET['tutor_id']).');
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
echo Class: .$row['course_name'].br /\n;
echo Description: .$row['course_description'].br /\n;
}
?
You can also use JOINs and so forth, of course, but a simple
WHERE/IN should be fine.
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
Unadvertised dedicated server deals, too low to print - email me to find out!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
Yep, 3 tables is the way to go! One for tutors, one for courses and one to join them Bastien Sent from my iPod On Feb 4, 2009, at 17:24, tedd t...@sperling.com wrote: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clarity needed
2009/2/4 tedd t...@sperling.com: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor (another linked list). As a tutor adds courses, I would just add the course to the end of the linked list. If the tutor deletes a course, then I would remove it from the list by changing a single pointer. If I needed a list of all the courses the tutor taught, I would just run down the linked list pulling them out as needed. But now I have to think in terms of records in a database. I'll eventually figure it out, but what are your suggestions/solutions? I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want tying courses to tutors. It that the way you guys would do it? Thanks, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Hi, tedd! Though you might think that this is a stupid task I can recommend you to draw a little entity-relationship model. It quite helps you to overlook the structure of the database that you want to design. It has got different relations between the data and defines a way to represent those in the database. If you are interested in this you can look in wikipedia here: http://en.wikipedia.org/wiki/Entity-relationship_model Since I heard from these models the first time I always use them and I had no more database changes after I started coding since then. Greetings -- Currently developing a browsergame... http://www.p-game.de Trade - Expand - Fight Follow me at twitter! http://twitter.com/moortier -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
