Re: Re: Table exists?

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 * and then CC Zona declared.... > In article <20020209182841.GB3122@explodingnet.com>, > nick@explodingnet.com (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-----