HTML pages conversion to Mysql

[Calranthe]

I have just got myself a new host for my site, the old one was just basic html and going nowhere fast.

I run an adult story archive, about 3399 basic html story pages, now the new site has Mysql and PHP, I would like to know how hard is it going to be to make use of the above systems to convert a site based on 8 index pages with stories archives like this:

(Title)
By Author name email link Story description
Part one (linked url 7K. (9-Jul-02)

I would love to be able to setup my site so that registered people could leave reviews at the end of stories, authors could update there own stories (atm I upload all stories) and a search function.

I've been told all these goals are achievable any advice of where to start or how to go about this is greatfully appreciated.

[BoR|S]

Okey, this is how I think the project should look like:

Database
Will include one table with the following fields:
- id (The unique number of the story)
- Name (The name of the story)
- Author (The name of the author)
- Email (The email of the author)
- Car (The category of the story)
- Promo (The first paragraph of the story, it's optional, but it is a good thing to use)
- Story (The story itself)
- Hits (The number of the time the story was requested)
- Score (The overall rating of the story given by the reader)
- Status (The story ONLINE/OFFLINE indicator)

Pages
- index.php (The main page, will include the 5 new stories (and will show it's promo) and the 5 stories with the highest score)
- cat.php (The page on which the various categories of the stories are shown with number of stories in each category)
- story.php (The page that will show the story)
- rank.php (The page that will process the rating)
- add.php (The page through which the users will be able to submit their own stories)
- queue.php (The page through which the admin gives the submited stories the ONLINE status or declines them)
- edit.php (The page through which the admin edits the ONLINE stories).

[Calranthe]

Does anyone know of a nice friendly MySQL and php tutorial ?

[Calranthe]

Interesting, thankyou Boris
Changes of design
Database
Will include one table with the following fields:
- id (The unique number of the story)
- Title (The name of the story)
- Author (The name of the author)
- Email (The email of the author)
- Domain (Three different domains)
- Cat (The category of the story)
- Desc (Short description of story)
- Rating (The short info of story rating from mildly romantic to hardcore)
- Story (The story itself)
- Date (Do i need this to order site chronological wise)
- Hits (The number of the time the story was requested)
- Review (Reader added feedback)
- Status (The story ONLINE/OFFLINE indicator)

Pages
- index.php (The main page, linkage to the different categories including date last updated and number of stories)
- cat.php (show full list of stories in a particular category)
- story.php (The page that will show the story seperated into parts with review section at the bottom)
- review (section to add a review to a story)
- register.php (where all authors and readers who wish to review/add story must gain a username/password)
- add.php (The page through which the users will be able to submit their own stories)
- queue.php (The page through which the admin gives the submited stories and reviews the ONLINE status or declines them)
- edit.php (The page through which the admin edits the ONLINE stories and reviews also an author is able to edit own story)
- seach.php (search for a specific author or story type)


Is there anything i've missed?

Now all I need is to know how to use php/Mysql to create this.

[gdadp]

I, like you have recently started with PHP/MySql.
I have learned a lot at www.freewebmasterhelp.com
hope to see your site in lites someday soon :D

[BoR|S]

w3schools is a good source, but it's good for the most basic knowledge...