functionality question / opinions on change sought

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
m3rajk
DevNet Resident
Posts: 1191
Joined: Mon Jun 02, 2003 3:37 pm

functionality question / opinions on change sought

Post by m3rajk »

ok. the question is if there's a function, either in sql or php, that will check for a specific table name and return true or false depending on if it exists or not.

for those that will be kind enough to give opinions/advice, i should mention what i have then go to why i'm asking the above question.

in order to bring my php knowledge current and show and increase my experience with sql, i created a db heavy site that started as a forums and built on otherthings including profiles and blogs. the blogs are done as one table right now. while this is fine when the site is small, it's obviously not scalable. so i want to move to each user having his/her own table, but that's going to create an immensly large overhead that's unnecessary since not all users will use the blogs.

i want to have a blog page that prompts a user to create their own blog if they don't have one but wants to have one, and lets others know the specified user has no blog if they don't have one. i've already figured out a way to name them all uniquely.
both username and user id number are unique/ i can create a blog and blog comment table that is based on one or both of those. i already figured out which feilds from the huge table i'll need and how to do the rest, just not ehe best way to tell who has one and who doesn't. if you have opinions on how to do the rest, i'm also interested in what that is and why since you may have thought of soemthing i haven't, and i may then be able to improve my design.
Post Reply