how to create sql database for articles (was "SQL & PHP help")
I hae an online articles template and was wondering how I would go about creating an sql database for the articles. Also how do I pull these articles into the page when I click on the page of the category.
I use Maestro Visual SQL. Would the best way be to create one table for each category then have colums - Unique ID, Article Name, Date Added, Text (as a blob). I would like to be able to add the details into the SQL database and have the pages populated from the dbase but I know no PHP coding and I don't want to learn it. Is there an automatic way or a simpler way of making this happen?
you'd create a categories table and add records to the table. The fields in the table could be:
id - A unique identifier
cat_name - A text name of the category
date_added - The date it was added
description - A text description of the category
live - a Boolean value to turn it on or off (0=off/ 1=on)
Describe what you're trying to do in a bit more detail and I'll try to code it for you.