Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rdavis101
Starting Member
1 Post |
 Posted - 2006-07-27 : 19:35:23
|
| SO I'm looking at the code on the net for determining whether a table exists, and I'm thinking this is a common enough issue that there's a single statement for it...but the code the author supplied is below. Comments?global $exists; $exists = 0; $dataset = mysql_query('SHOW TABLES') ; while( $row = mysql_fetch_row($dataset) ) { if ( $row[0] == "mos_tbd_tags" ) { $exists = 1; break; } } |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-27 : 19:52:05
|
| you may want to go and ask your question at http://dbforums.com since they have a dedicated MySQL forum. This site is really a SQL Server specific site and you probably won't see many responses to your question.-ec |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-28 : 11:46:15
|
| or try at www.MySQL.comMadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
does table exist code