Re: [PHP] one more mysql question
Jochem Maas wrote: snip while were not on the subject John I have a question about your wife ... She's 7 months pregnant, and down right mean at the moment. oh shit wrong list ;-) Doesn't seem to matter here, eh? no no I meant to ask about sand - how do I make a CPU using the stuff? Allright, now that was totally off-topic and uncalled for. Pistols at Dawn!!! ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
Sebastian wrote: they are just grumpy old men i guess.. it is not like you asked a windows question on a linux list.. i've seen stupid html questions here.. yet they get answered. Not by me. They'll get the same response from the 'grumpy old men' group as this topic did. i always try to help when i can and if i cant offer help i dont say anything because that wasnt the way i was raised. it is rude. How nice. at least if it was too offtopic for the list someone could of just nicely said ask on the mysql list but that wasn't case. It was 'too offtopic'...and he's been around long enough to know that he should ask MySQL questions on the MySQL list. anyway, consider this a done deal as you already received help. You've got my vote for sainthood. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
John Nichel wrote: Jochem Maas wrote: snip while were not on the subject John I have a question about your wife ... She's 7 months pregnant, and down right mean at the moment. been there (http://iamjochem.com/baby) - kind of - congrats anyhow, and good luck! oh shit wrong list ;-) Doesn't seem to matter here, eh? no no I meant to ask about sand - how do I make a CPU using the stuff? Allright, now that was totally off-topic and uncalled for. Pistols at Dawn!!! isnt't it the [n]etiquette that if you demand a duel I get to decide on weapons? that'll be Wooden Spoons at dawn if you please. ;-) ;) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
Sebastian wrote: they are just grumpy old men i guess.. I'm niether - I believe John Nichel is a little older than I. he for one has been on this list fielding questions longer than you have been writing php code sebastian. complete noobs often get some slack, even with offtopic questions + a gentle nudge - lazy people get a kick in the ass. people who have been asking questions (primarily) for a while (e.g. afan) will eventually run out of credit and find themselves on the shortend of a bit John Nichel humor (for instance). yes humor - at least I thought his comment was funny - which is part of what makes this list fun to be on. it is not like you asked a windows question on a linux list.. i've seen stupid html questions here.. yet they get answered. HyperTextMarkupLanguage PhpHypertextProcessor you might see a reason why 'stupid HTML' question are possibly a little more relevant, generally speaking, than pure SQL syntax questions. i always try to help when i can and if i cant offer help i dont say anything because that wasnt the way i was raised. it is rude. rude is lying about 9-11 to the whole world, or invading a country in order to boost your country's weapons oil industry, or gang-raping 12yo's (dutch news) those are rude - maybe a bit of relativity is in order sebastian. at least if it was too offtopic for the list someone could of just nicely said ask on the mysql list but that wasn't case. anyway, consider this a done deal as you already received help. [EMAIL PROTECTED] wrote: Hey! Stop it! I put a question on wrong place. I was nailed for it by John. I accepted I was wrong. I apologized. What do you want now? Sebastian wanted to help – in difference to you and John. Even it’s “wrong place”. I guess you would never stop and help to car in trouble on highway because you are IT or “it’s not your department”, ha? not if it was Dubya's car. although I might swerve to catch him with a big puddle of water ;-). actually I can't fix cars for shit but I have helped complete strangers push their cars to the edge of the road before ... aren't I great ;-) C’mon… It’s really not place to be sarcastic… I was having a joke with John - if you took yourself a little less seriously afan you might have been able to laugh too - besides I grew up in england... where sarcasm is is part of national curriculum ;-) an art form no less. which might account for something. -afan Jochem Maas wrote: John Nichel wrote: Sebastian wrote: while were not on the subject John I have a question about your wife ... oh shit wrong list ;-) no no I meant to ask about sand - how do I make a CPU using the stuff? take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. And he might be using Apache on Linux like the majority of PHP users. More than likely outputting some HTML and maybe some JavaScript. Probably using a PC too. So what? the fact is without mysql php would be nowhere where it is today.. its like peanut butter w/o the jelly.. The fact is, without IBM, PHP would be nowhere it is today. Say, here's an idea, let's just make this the IBM and anything which relates to it list. see my reply in the other email.. im sure it will work for you. I'll be sure to tell everyone on the MySQL list that they can shut it down, since you have it covered over here. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] one more mysql question
I agree with Sebastian, there is no excuse for being arrogant and rude. I understand the frustration, but is there any need for some of the replies people get? If I can, I will try to help anyone, even if the thread is OT. C. -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: 15 August 2005 14:42 To: PHP Mailing Lists Subject: Re: [PHP] one more mysql question * This e-mail has been received by the Revenue Internet e-mail service. * Sebastian wrote: they are just grumpy old men i guess.. it is not like you asked a windows question on a linux list.. i've seen stupid html questions here.. yet they get answered. Not by me. They'll get the same response from the 'grumpy old men' group as this topic did. i always try to help when i can and if i cant offer help i dont say anything because that wasnt the way i was raised. it is rude. How nice. at least if it was too offtopic for the list someone could of just nicely said ask on the mysql list but that wasn't case. It was 'too offtopic'...and he's been around long enough to know that he should ask MySQL questions on the MySQL list. anyway, consider this a done deal as you already received help. You've got my vote for sainthood. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php This message has been delivered to the Internet by the Revenue Internet e-mail service * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
Shaw, Chris - Accenture wrote: I agree with Sebastian, there is no excuse for being arrogant and rude. I understand the frustration, but is there any need for some of the replies people get? Not that you're judging, eh? If I can, I will try to help anyone, even if the thread is OT. Great, I'm happy for you. However, do those of us who would like this list to remain a PHP list a favor. Help those with OT questions off list. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] one more mysql question
-Original Message- From: Shaw, Chris - Accenture [mailto:[EMAIL PROTECTED] Sent: Monday, August 15, 2005 11:49 AM To: PHP Mailing Lists Subject: RE: [PHP] one more mysql question I agree with Sebastian, there is no excuse for being arrogant and rude. I understand the frustration, but is there any need for some of the replies people get? If I can, I will try to help anyone, even if the thread is OT. There is never any excuse for being rude. That said, there is considerable value in keeping this (or any) mailing list ON TOPIC. There is also considerable value for the end user to ask questions in relevant forums. The original poster would likely have gotten enthusiastic and helpful response from the MySQL list, whereas he got a generally cold response here. Not because the list members here are rude, but because HE was rude to have ignored generally known netiquette and posted the question anyway. JM -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
Shaw, Chris - Accenture wrote: I agree with Sebastian, there is no excuse for being arrogant and rude. I understand the frustration, but is there any need for some of the replies people get? If I can, I will try to help anyone, even if the thread is OT. C. On that note I think we can agree to disagree on various topics and leave the beating of dead horses to another list, perhaps alt.flame or something? :P -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
In a message dated 8/13/2005 6:33:16 P.M. Central Standard Time, [EMAIL PROTECTED] writes: while were not on the subject John I have a question about your wife ... oh shit wrong list ;-) no no I meant to ask about sand - how do I make a CPU using the stuff? lol... I thought that was pretty funny too? I would have laughed if it were directed at me... ahhh well... - Clint
Re: [PHP] one more mysql question
John Nichel wrote: Sebastian wrote: while were not on the subject John I have a question about your wife ... oh shit wrong list ;-) no no I meant to ask about sand - how do I make a CPU using the stuff? take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. And he might be using Apache on Linux like the majority of PHP users. More than likely outputting some HTML and maybe some JavaScript. Probably using a PC too. So what? the fact is without mysql php would be nowhere where it is today.. its like peanut butter w/o the jelly.. The fact is, without IBM, PHP would be nowhere it is today. Say, here's an idea, let's just make this the IBM and anything which relates to it list. see my reply in the other email.. im sure it will work for you. I'll be sure to tell everyone on the MySQL list that they can shut it down, since you have it covered over here. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
Hey! Stop it! I put a question on wrong place. I was nailed for it by John. I accepted I was wrong. I apologized. What do you want now? Sebastian wanted to help – in difference to you and John. Even it’s “wrong place”. I guess you would never stop and help to car in trouble on highway because you are IT or “it’s not your department”, ha? C’mon… It’s really not place to be sarcastic… -afan Jochem Maas wrote: John Nichel wrote: Sebastian wrote: while were not on the subject John I have a question about your wife ... oh shit wrong list ;-) no no I meant to ask about sand - how do I make a CPU using the stuff? take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. And he might be using Apache on Linux like the majority of PHP users. More than likely outputting some HTML and maybe some JavaScript. Probably using a PC too. So what? the fact is without mysql php would be nowhere where it is today.. its like peanut butter w/o the jelly.. The fact is, without IBM, PHP would be nowhere it is today. Say, here's an idea, let's just make this the IBM and anything which relates to it list. see my reply in the other email.. im sure it will work for you. I'll be sure to tell everyone on the MySQL list that they can shut it down, since you have it covered over here. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
they are just grumpy old men i guess.. it is not like you asked a windows question on a linux list.. i've seen stupid html questions here.. yet they get answered. i always try to help when i can and if i cant offer help i dont say anything because that wasnt the way i was raised. it is rude. at least if it was too offtopic for the list someone could of just nicely said ask on the mysql list but that wasn't case. anyway, consider this a done deal as you already received help. [EMAIL PROTECTED] wrote: Hey! Stop it! I put a question on wrong place. I was nailed for it by John. I accepted I was wrong. I apologized. What do you want now? Sebastian wanted to help – in difference to you and John. Even it’s “wrong place”. I guess you would never stop and help to car in trouble on highway because you are IT or “it’s not your department”, ha? C’mon… It’s really not place to be sarcastic… -afan Jochem Maas wrote: John Nichel wrote: Sebastian wrote: while were not on the subject John I have a question about your wife ... oh shit wrong list ;-) no no I meant to ask about sand - how do I make a CPU using the stuff? take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. And he might be using Apache on Linux like the majority of PHP users. More than likely outputting some HTML and maybe some JavaScript. Probably using a PC too. So what? the fact is without mysql php would be nowhere where it is today.. its like peanut butter w/o the jelly.. The fact is, without IBM, PHP would be nowhere it is today. Say, here's an idea, let's just make this the IBM and anything which relates to it list. see my reply in the other email.. im sure it will work for you. I'll be sure to tell everyone on the MySQL list that they can shut it down, since you have it covered over here. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
I apology for mysql question posted here, but, as I said once, I like you guys more! :) have two tables: orders and special_orders. foreign key is trans_no. I can't figure it out how to create a query that pulls orders from the orders tables that are NOT in special_orders table? I can never remember the syntax, but you want to LEFT JOIN the tables and then only return rows where the resulting special_orders column is NULL. something like this (most likely wrong syntax): SELECT o.trans_no, s.trans_no FROM orders o LEFT JOIN special_orders s ON o.trans_no = s.trans_no WHERE s.trans_no IS NULL But that should get you started... -philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
I tried this one: SELECT trans_no FROM orders WHERE trans_no IN ( SELECT trans_no FROM special_orders ) but gives me an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT trans_no FROM special_orders )' at line 5 ??? Philip Hallstrom wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) have two tables: orders and special_orders. foreign key is trans_no. I can't figure it out how to create a query that pulls orders from the orders tables that are NOT in special_orders table? I can never remember the syntax, but you want to LEFT JOIN the tables and then only return rows where the resulting special_orders column is NULL. something like this (most likely wrong syntax): SELECT o.trans_no, s.trans_no FROM orders o LEFT JOIN special_orders s ON o.trans_no = s.trans_no WHERE s.trans_no IS NULL But that should get you started... -philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
[EMAIL PROTECTED] wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) I like my wife more than I like the people on these lists, but I don't go asking her my MySQL questions. I go to the MySQL list for that. What you like doesn't make your post any less off topic, or any less against netiquitte. To me, it's even a bigger offense than the newbie wo doesn't know any better...you know you're question is off topic, and yet you ask anyway...numerous times. -- By-Tor.com ...it's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
don't get this one: from mysql.com: SELECT s1 FROM t1 WHERE s1 NOT IN (SELECT s1 FROM t2); my query: select trans_no from orders where trans_no not in (select trans_no from special_orders); and I'm getting an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select trans_to from printed_orders)' at line 1 Syntax error? ??? -afan [EMAIL PROTECTED] wrote: I tried this one: SELECT trans_no FROM orders WHERE trans_no IN ( SELECT trans_no FROM special_orders ) but gives me an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT trans_no FROM special_orders )' at line 5 ??? Philip Hallstrom wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) have two tables: orders and special_orders. foreign key is trans_no. I can't figure it out how to create a query that pulls orders from the orders tables that are NOT in special_orders table? I can never remember the syntax, but you want to LEFT JOIN the tables and then only return rows where the resulting special_orders column is NULL. something like this (most likely wrong syntax): SELECT o.trans_no, s.trans_no FROM orders o LEFT JOIN special_orders s ON o.trans_no = s.trans_no WHERE s.trans_no IS NULL But that should get you started... -philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
ok. accept critique. :( @moderator: please take my mysql questions off the php list. I apology to everybody for any inconviniance. -afan John Nichel wrote: [EMAIL PROTECTED] wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) I like my wife more than I like the people on these lists, but I don't go asking her my MySQL questions. I go to the MySQL list for that. What you like doesn't make your post any less off topic, or any less against netiquitte. To me, it's even a bigger offense than the newbie wo doesn't know any better...you know you're question is off topic, and yet you ask anyway...numerous times. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
[EMAIL PROTECTED] wrote: I tried this one: SELECT trans_no FROM orders WHERE trans_no IN ( SELECT trans_no FROM special_orders ) but gives me an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT trans_no FROM special_orders )' at line 5 ??? Philip Hallstrom wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) have two tables: orders and special_orders. foreign key is trans_no. I can't figure it out how to create a query that pulls orders from the orders tables that are NOT in special_orders table? I can never remember the syntax, but you want to LEFT JOIN the tables and then only return rows where the resulting special_orders column is NULL. something like this (most likely wrong syntax): SELECT o.trans_no, s.trans_no FROM orders o LEFT JOIN special_orders s ON o.trans_no = s.trans_no WHERE s.trans_no IS NULL But that should get you started... -philip try this (untested): SELECT * FROM trans_no LEFT JOIN special_orders ON (trans_no.id = special_orders.id) WHERE special_orders.id IS NULL; just change id to the primary key... -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. the fact is without mysql php would be nowhere where it is today.. its like peanut butter w/o the jelly.. see my reply in the other email.. im sure it will work for you. [EMAIL PROTECTED] wrote: ok. accept critique. :( @moderator: please take my mysql questions off the php list. I apology to everybody for any inconviniance. -afan John Nichel wrote: [EMAIL PROTECTED] wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) I like my wife more than I like the people on these lists, but I don't go asking her my MySQL questions. I go to the MySQL list for that. What you like doesn't make your post any less off topic, or any less against netiquitte. To me, it's even a bigger offense than the newbie wo doesn't know any better...you know you're question is off topic, and yet you ask anyway...numerous times. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] one more mysql question
Sebastian wrote: take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. And he might be using Apache on Linux like the majority of PHP users. More than likely outputting some HTML and maybe some JavaScript. Probably using a PC too. So what? the fact is without mysql php would be nowhere where it is today.. its like peanut butter w/o the jelly.. The fact is, without IBM, PHP would be nowhere it is today. Say, here's an idea, let's just make this the IBM and anything which relates to it list. see my reply in the other email.. im sure it will work for you. I'll be sure to tell everyone on the MySQL list that they can shut it down, since you have it covered over here. -- By-Tor.com ...it's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php