Thread: Check if database or table exists

I am learning PHP programming language and mysql .I am trying to creating pages for my project. I try to create it but fails to so. Also I want to enter doc file field that matches the record trying to enter into database. If you are having any suggestions then reply me. It can helpful to me.

Refer following code to check if database or table exists. Try to understand following code which is helpful for you. It is very simple.

Code:

The syntax for mysqldump : mysqldump --add-drop-table dbname tablename 
also
 = mysql_query ("SELECT * FROM `tableName` LIMIT 0,1"); /* >>limit<< is just to make it faster in case the db is large */
if (){
query was correct and could be executed by the server
}else{
// something wrong, so:
// create the table
}