MySQL Help, PHP and Database help [Solved/Closed]

Posts
20
Registration date
Monday August 11, 2008
Status
Member
Last seen
September 4, 2008
- - Latest reply: daspeac
Posts
1
Registration date
Saturday November 14, 2009
Status
Member
Last seen
November 20, 2009
- Nov 20, 2009 at 10:35 AM
Hello,
I am building a form/blog/personal site for a small company. I was wondering if someone could help me in setting up my database. i have thought of a few options but i am not quite sure what one is the best.

each user have a person page, they need all their information stored, mail, bulletins, friends, etc.

i have my MySQL server setup as such:
SCHEMA(users) -> TABLE(Username) -> COLUMNS(disname, email, mail_from, bulletin_from, etc.)
The problem i am having with this is when send a new email or bulletin it adds a new row leaving NULL spaces.

For example:
Friends---------mail_message-----bulletin_message
Bob-------------null-------------------null
Tom------------null-------------------null
Joe-------------null--------------------null
null-------------Hello this is...----- null
null-------------My name is...----- null
null-------------null-------------------This is a bullet...
null-------------Hello this is...------null


see how everytime i post a new message or add a friend or post a bulletin it drops it down a row instead of filling in the NULL space. i dont like this and i beleive its slowing my server down a bit.

My other idea was to setup MySQL server such as:
SCHEMA(Username) --> TABLE(Mail, Bulletins, UserData, etc.) --> COLUMNS(Data)
idk how well this works and if it slows down my server any when i try to access multiple SCHEMAs at once.

Please can someone help me and aid me twards a better solution :)

Thanks,
DV6500
See more 

4 replies

Best answer
Posts
20
Registration date
Monday August 11, 2008
Status
Member
Last seen
September 4, 2008
13
2
Thank you
Thanks, i think i figured out how im going to set it up:

SCHEMA(MAIL, BULLETINS, USERS) -> TABLE(MAIL STUFF, BULLETIN STUFF, USER INFO) -> COLUMN(DATA)

thanks allot :)

Say "Thank you" 2

A few words of thanks would be greatly appreciated. Add comment

CCM 1946 users have said thank you to us this month

1
Thank you
Hi,

I've recently set up my personal blog at http://blogangmundo.com/lemurian but I set it up using Joomla! (http://joomla.org). It works under the same environment of MySQL and PHP but I find that you can get websites with more sophistication up and running very quickly. Of course, there are trade-offs like features that you may want to put in but may not be directly available as an extension in Joomla but if you have very good background in MySQL and PHP, I suppose you can easily modify the codes to satisfy your specific needs. I have also started to blog about the Joomla system at http://blogangmundo.com/lemurian/technology/6.html. Maybe you'd like to check it out from time to time and be able to get some things you might find useful in your project. Wish you luck and all the best on your endeavors.

Cheers,

Boogie
Posts
1
Registration date
Saturday November 14, 2009
Status
Member
Last seen
November 20, 2009
1
1
Thank you
Hi there, just wanted to advise a good way out if backups are failing. Try the mssql fix program and open affected database, it can be found here: http://www.recoverytoolbox.com/fix_mdf_file_sql_server.html. Feel free parsing affected database, Recovery Toolbox for SQL gives very good chances to restore the entire database. Hope it helps and becomes a good alternative to your method
Posts
13
Registration date
Monday July 7, 2008
Status
Member
Last seen
October 2, 2008
14
0
Thank you
hello buddy here is a link where you will find it perhaps very useful :

http://hostingrevolution.com/mysqlandphp.htm