Re: [PHP] one more mysql question

2005-08-15 Thread John Nichel
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?

Re: [PHP] one more mysql question

2005-08-15 Thread John Nichel
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

Re: [PHP] one more mysql question

2005-08-15 Thread Jochem Maas
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

Re: [PHP] one more mysql question

2005-08-15 Thread Jochem Maas
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

RE: [PHP] one more mysql question

2005-08-15 Thread Shaw, Chris - Accenture
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

Re: [PHP] one more mysql question

2005-08-15 Thread John Nichel
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,

RE: [PHP] one more mysql question

2005-08-15 Thread Jim Moseby
-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

Re: [PHP] one more mysql question

2005-08-15 Thread Torgny Bjers
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

Re: [PHP] one more mysql question

2005-08-15 Thread Esteamedpw
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

Re: [PHP] one more mysql question

2005-08-13 Thread Jochem Maas
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

Re: [PHP] one more mysql question

2005-08-13 Thread [EMAIL PROTECTED]
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

Re: [PHP] one more mysql question

2005-08-13 Thread Sebastian
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.

[PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
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? Thanks for

Re: [PHP] one more mysql question

2005-08-12 Thread Philip Hallstrom
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

Re: [PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
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

Re: [PHP] one more mysql question

2005-08-12 Thread John Nichel
[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

Re: [PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
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

Re: [PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
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

Re: [PHP] one more mysql question

2005-08-12 Thread Sebastian
[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

Re: [PHP] one more mysql question

2005-08-12 Thread Sebastian
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]

Re: [PHP] one more mysql question

2005-08-12 Thread John Nichel
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?