Re: [PHP] MySQL PHP issue?

2005-04-27 Thread John Nichel
Dustin Wish wrote: It is version 3.23.56 Know thy software. 3.x doesn't support sub-queries. -- 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] MySQL PHP issue?

2005-04-27 Thread Dustin Wish
SH^*&^t Thanks guys. Figured something like that. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:53 PM To: Dustin Wish; php-general@lists.php.net Subject: RE: [PHP] MySQL PHP issue? [snip] It is version 3.23.56 [/snip] Sub-que

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Jay Blanchard
[snip] It is version 3.23.56 [/snip] Sub-queries are not supported in that version of MySQL. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Dustin Wish
It is version 3.23.56 -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:44 PM To: php-general@lists.php.net Subject: Re: [PHP] MySQL PHP issue? Jay Blanchard wrote: > Asking a MySQL question on a PHP list? *slaps knee!* I bet you th

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Jay Blanchard
[snip] Jay Blanchard wrote: > Asking a MySQL question on a PHP list? *slaps knee!* I bet you think you're funny. ;) [/snip] I know that you think I am. Yuk-yuk! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL PHP issue?

2005-04-27 Thread John Nichel
Jay Blanchard wrote: Asking a MySQL question on a PHP list? *slaps knee!* I bet you think you're funny. ;) -- 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] MySQL PHP issue?

2005-04-27 Thread John Nichel
Dustin Wish wrote: Anyone have any idea what I'm doing wrong? Asking on the wrong 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] MySQL PHP issue?

2005-04-27 Thread Jay Blanchard
[snip] OK, I have check all the mysql doc and php docs on using exists in the query, but it seems I still can not get the query to work. Here it is: SELECT * FROM icisp.account WHERE id in (select oldaccountID from BillMax.account) Or Using sELECT * FROM icisp.account WHERE id exists(select ol