RE: [PHP-DB] Query error
| From: | Beau Lebens | Date: | Thu, 03 Oct 2002 02:18:55 +0000 |
| Subject: | RE: [PHP-DB] Query error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22182@lists.php.net to get a copy of this message | ||
If it's on MySQL, then the problem is that it doesn't support nested queries
:)
If it's on something else, i'm afraid i don't know :/
Back to MySQL, you can get around that by doing your "select author_code
from authorxcat" component query, then put the results into 'x', 'y',
'z'
format, then do something like
"select author_code from author where author_code not in ($previousResults)"
HTH
Beau
// -----Original Message-----
// From: Wilmar Perez [mailto:wilmar.perez@caribe.udea.edu.co]
// Sent: Wednesday, 2 October 2002 10:54 PM
// To: php-db@lists.php.net
// Subject: [PHP-DB] Query error
//
//
// Hello guys
//
// Does anybody have a clue on what wrong with the following sentence?
//
// select author_code from author where author_code not in
// (select author_code from authorxcat);
//
// Thanks
//
// *******************************************************
// Wilmar Pérez
// Network Administrator
// Library System
// Tel: ++57(4)2105145
// University of Antioquia
// Medellín - Colombia
// 2002
// *******************************************************
//
//
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
//