psm 996 -- The real question is: Does MySQL support "sub query", the short answer is 3.x.x does not, 4.x.x is supposed to. The longer answer(and work arounds) to the 3.x.x question can be found here: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
David ************************************************* BASIC DBD/DBI Connect Function: ************************************************* /usr/local/bin/perl -w use strict; use diagnostics; use DBI; $dbh = DBI->connect("DBI:mysql:$dbname",$login,$password) or die "Can't connect to $dbh: $dbh->errstr\n"; $sth = $dbh->prepare("SELECT * FROM catalog") or die "Can't connect to $dbh: $sth->errstr\n"; $sth-> execute() or die "Can't connect to $dbh: $sth->errstr\n"; $sth -> finish(); $dbh->disconnect(); --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php