Re: [PHP-DB] Really embarassing newbie question...
Hi, Use this: $query="describe TableName"; $result=mysql_query($query) or die (mysql_error()); This is one good way to prevent update or delete or mass up the table without known. Kelvin. ""~BD~"" <[EMAIL PROTECTED]> wrote in message 02a601c0ced3$34cdd5a0$22041dd8@winbox">news:02a601c0ced3$34cdd5a0$22041dd8@winbox... > Sorry to do this to ya... > I"ve been involved with PHP for a total of two days now, and I'm kinda > stumped. I've been looking in docs for about 4 hours now for this, and I'm > sure I'm slipping right by the obvious answer somewhere, but > > What's the best (recommended) way to determine if a table exists in a > database? Is it to try a query on it, and check the returned error? that's > the way I'm set up now, but I can't help but think there's got to be a > better way... > > TIA, > ~BD~ > > > > http://www.bustdustr.net > Home of Radio Free Bd > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Really embarassing newbie question...
Doh! Sorry about that - yes, it's MySQL. And I complete blew by mysql_list_tables - I mis-read what I thought it did, then didn't look at it any further... I told you it was embarrasing... Thanks! http://www.bustdustr.net Home of Radio Free Bd > You didn't mention what DBMS you are running... Assuming it is MySQL, check > page 686 in the PHP Manual, you're looking for mysql_list_tables() > > Enjoy... > > -Original Message- > From: ~BD~ [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 26, 2001 9:33 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Really embarassing newbie question... > > > Sorry to do this to ya... > I"ve been involved with PHP for a total of two days now, and I'm kinda > stumped. I've been looking in docs for about 4 hours now for this, and I'm > sure I'm slipping right by the obvious answer somewhere, but > > What's the best (recommended) way to determine if a table exists in a > database? Is it to try a query on it, and check the returned error? that's > the way I'm set up now, but I can't help but think there's got to be a > better way... > > TIA, > ~BD~ > > > > http://www.bustdustr.net > Home of Radio Free Bd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Really embarassing newbie question...
You didn't mention what DBMS you are running... Assuming it is MySQL, check page 686 in the PHP Manual, you're looking for mysql_list_tables() Enjoy... -Original Message- From: ~BD~ [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:33 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Really embarassing newbie question... Sorry to do this to ya... I"ve been involved with PHP for a total of two days now, and I'm kinda stumped. I've been looking in docs for about 4 hours now for this, and I'm sure I'm slipping right by the obvious answer somewhere, but What's the best (recommended) way to determine if a table exists in a database? Is it to try a query on it, and check the returned error? that's the way I'm set up now, but I can't help but think there's got to be a better way... TIA, ~BD~ http://www.bustdustr.net Home of Radio Free Bd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Really embarassing newbie question...
Sorry to do this to ya... I"ve been involved with PHP for a total of two days now, and I'm kinda stumped. I've been looking in docs for about 4 hours now for this, and I'm sure I'm slipping right by the obvious answer somewhere, but What's the best (recommended) way to determine if a table exists in a database? Is it to try a query on it, and check the returned error? that's the way I'm set up now, but I can't help but think there's got to be a better way... TIA, ~BD~ http://www.bustdustr.net Home of Radio Free Bd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
