this is just a convience thing so i dont have to hardcode this. but is there a php or SQL command i can use to return the names of all the tables in my database? there is a point in my project that i need to search many tables, but if i remove tables or create tables i dont want to have to go back in my code to hardcode different tables or remove tables from my code. anyone have any ideas? i thought about just having a table in my DB that kept the names of all the rest of my tables, but i want to avoid that if possible. thanks