Database to website

[Zane]

Hi all

i had a idea for a website and i have been trying to think of the best way to do it.... whats going to happen is that lots of info is going to be entered into different tables in a database and i want to get all the info onto a website (different info on different pages)

the info will be split into different tables of information and i want to be able to get these tables to show on different pages on the site...

i was just wondering if anyone know how to do this and if there is a certain database i will need to use (im guessing will have to make a SQL database) if thats correct i have no idea how to then get it to show on a website so im asking how to do it Very Happy (would you inbed it in some way?)

if possible i would also like it preferably if the website automatically updated when the database was changed and updated (but i can live without it)

i understand this maybe way to hard for someone like me whole if new to all this... if it is and i have to pay someone to help/do it for me... does anyone have any idea how much it would cost to get someone to install a database on an already designed and coded site? or just fto have the site fully done by someone?

thanks for you help and if u dont understand a part of what i ment just ask.

 

[Dan]

Do you know what you want in the database?..

 

[Zane]

yes... have not collected all the information because i do not want to collect it all into something like excel then have to retype it all into another database/program

is thats not what you mean... could you explain abit.. im very sorry again im new to all this

 

[Keral_Patel]

First of all. Even if you collect it in excel you can export it into MySQL with just one click.
So easy.

Next about your web site design and database integration. Here
"if possible i would also like it preferably if the website automatically updated when the database was changed and updated (but i can live without it)"

Yes this is always going to be live as soon as you enter a new entry or update an entry it will start reflecting live on the website from that moment.

The idea behind this is to take the MySQL database. Modify the structure a bit. Assign Primary key that is 1 or 2 and so on.... Say for example 1000 as you have 1000 entries.

And display them 1 by 1 on each page which makes 1000 different pages. Using mod_rewrite you can acheive this with a single page code of PHP.

If you decide to take 10 entries on one page and do the paging. Then the query will fetch 10 - 10 entries and display 10 entries on one page. making 100 pages. 1st page will have entries from 1 to 10, 2nd page will have 10 entries from 11 to 20 and so on....

 

[dairyman]

Why noy use a CMS? I would suggest to try cmsmadesimple (http://cmsmadesimple.org)
its very simple. I havent yet found a good cms that display custom data ( atleast a little bit of work needs to be done to mould it to work for your needs)