Search : in
By :

MySQL Help, PHP and Database help

Last answer on Nov 20, 2009 3:35:35 pm GMT DV6500, on Sep 1, 2008 2:44:18 am BST 
 Report this message to moderators

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

Configuration: Windows Vista
Internet Explorer 7.0

Best answers for « MySQL Help, PHP and Database help » in :
LAMP(Apache + MySQL + PHP) quick install on Linux Show LAMP(Apache + MySQL + PHP) quick install on Linux Intro LAMP is the acronym for a free and open source software suite.usually used to define and run dynamic a web server infrastructure ,software development and establish a software...
Backup/Restore Mysql database Show Backup/Restore Mysql database Backup Restore your database Note A simple approach on how to backup and restore MySQL databases. Backup To save an existing database it is recommended that you create a dump. To dump all...
Reinitializing the root password of MySQL ShowReinitializing the root password of MySQL The root password is lost! Reinitializing the password: It's important that you are able to access and modify the admin (root) password of MYSQL, either when installing MySQL for the first...
Connecting to Oracle via php ShowConnecting to Oracle via php Settings Requirements Example of code Settings Below is an article based on an example of connection to an Oracle database through a php script. However it is not designed to configure your oracle...
MySQL - SELECT ... YESTERDAY ShowMySQL - SELECT ... YESTERDAY Make use of the following syntax: SELECT * FROM myTable WHERE field_date = DATE_SUB(CONCAT(CURDATE(), ' 00:00:00'), INTERVAL 1 DAY) In order to select previous records: SELECT * FROM myTable WHERE field_date =...
ODBC ShowWhat is ODBC? ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is...
Introduction - Databases ShowWhat is a database? A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...
Databases - Using forms ShowUsing forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...

1

Nathans008, on Sep 1, 2008 12:44:31 pm BST

Hello buddy here is a link where you will find it perhaps very useful :

http://hostingrevolution.com/mysqlandphp.htm

Reply to Nathans008

2

DV6500, on Sep 1, 2008 7:47:11 pm BST
  • +1

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 :)

Reply to DV6500

4

Boogie, on Jan 16, 2009 6:16:32 am GMT
  • +1

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

Reply to Boogie

5

ann, on Feb 9, 2009 5:52:17 am GMT
  • +1

[url=http://www.51cnnet.net]free ebook download/url

Reply to ann

6

 daspeac, on Nov 20, 2009 3:35:35 pm GMT

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

Reply to daspeac