SQL Database to website

[Butters]

Hi,

Thanks to help from guys on here I've managed to get my enquiry form writing to a MySQL database with the use of php and phpmyadmin.

So, now that I am getting to grips with phpmyadmin I have anohther question.

I have created another table called 'news' with IDs and and text area for the article and a date and author field.

What I am interested in now is how to link this to a webpage.

so I have news.html (or news.php in my case) and I want the article to appear within a certain div (or at minimum withing the body tags).

How do I go about this?

Thanks

 

[Butters]

Thanks guys, Sirus / Marc. I've managed to get it working, not least becasue phpmyadmin allows me to generate the code too (although not all of it).

Its still a bit messy at the moment but I'm getting there and your help is certainly appreciated.

One other question ( i hope its easy). The idea of this news page is for me to write in simple WYSIWYG text into an HTML form, that gets entered into the news table of the database and obviously automatically displays.

So, is there a way to firstly use WYSIWYG in a text box somehow which generated the appropriate HTML to insert into the database?

AND?

I obvioulsy want an admin only to access this part of the site, so I have created another table called Admins with username and password fields. The admin access www.mysite.com/admin.php, this links to a form where the user enters their name and password. I need help making this page and also, this should link to this WYSIWYG form.

Hope that makes sense.