What's a good way to detect if a TABLE is already displayed? For example...
IF TABLE $tablename does not exist create it else...keep going.
Can I use mysql_list_tables($tablename, $link)?? If so how?
Thank you in advance, Marcel Henry.
If you are going to check for a table, and create it if it does not yet exist, then why not just try executing the create table statement. If the table already exists, mysql will give an error back to you. If it did not exist, it is created and you get an OK message.
Yes but the error is halting my program...you see the table ceate fucntion is located in main and any subsequent calls to main causes the program to halt due to the error message...what I want to do is create the table if it doesn't exist but do nothing if it does exist, so as normal function can resume. Make sense?
Marcel.
And I got that one too...I'm on a roll....don't stop me now! What I did was simply on error -> create the table else continue....gee that was a real brainer. You know how you look at something too long? Anyway, thanks for your comments they made me thin it through again. 🙂
That's the way aha aha I like it aha aha...
Boogie all night!
