MySQL Help, PHP and Database help

Solved/Closed
DV6500
Posts
20
Registration date
Monday August 11, 2008
Status
Member
Last seen
September 4, 2008
- Aug 31, 2008 at 09:44 PM
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
Related:

4 replies

DV6500
Posts
20
Registration date
Monday August 11, 2008
Status
Member
Last seen
September 4, 2008
11
Sep 1, 2008 at 02:47 PM
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 :)
2
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
1
daspeac
Posts
1
Registration date
Saturday November 14, 2009
Status
Member
Last seen
November 20, 2009
1
Nov 20, 2009 at 10:35 AM
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: https://sql.recoverytoolbox.com/repair-sql/ 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
1