-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
* and then CC Zona declared.... > In article <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] (Nick Wilson) wrote: > > > What would be the easiest way to see if a MySQL table exists with PHP? > > I can do it by checking against mysql_list_tables() but that seems a > > little clumsy. Is there a better way? > > See MySQL's documentation of the "CREATE TABLE" and "DROP TABLE" syntax: > both support table existance checks. > > create table if not exists mytablename... > drop table if exists mytablename... Yeah, but I don't want to create or drop the table, I just want to check it exists. Thanks anyway. - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZYtKHpvrrTa6L5oRAstZAKCbKPBSjja+WkBB6xuV3p/CL5+u3ACgrHVS HzIhSNIpfVAVtEtOnLpvYMU= =D7Ja -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php