Database populating 3 columns on website

peacemaker

Hi,
I am a beginner and I'm learning php/mysql. Please help. 🙂

I want my website www.thirdrain.com which will have three columns, to be populated through a mysql database. Each column should retrieve data from the DB.

How would I design the DB, tables, and the php site?

I was thinking that each column has its own table,
or
each column has its own table.ID field. The content is not that long, will be exclusively text/HTML. It might exceed 255 chars though. Can I store HTML in the database then? How many chars maximum can I store in a record field?🙁
Would it be easier to link to a .html file in the database? I'm not sure if that's possible.

Thanks for your help friends!

kevinsequeira

what exactly do u want to retrieve from the db, there are quite a few tutorials that teach u the basics - to insert/edit/delete content from db via php.
maybe u should go thru them first and then get back when u face specific problems

reg
kevin

peacemaker

Hi
I know how to do queries (insert/delete/...) from php. My problem is how to design the table cleverly.
The second problem is can I store HTML code in a db that exceeds 255 chars?

I want to have column one have the ID 1, then use that to query and retrieve what's eventuallt going to show up on the page. But i don't think that's very smart.

Does anyone know a good db design tutorial? I don't.

Thanks.🙂