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
