SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2006
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question how to create sql database for articles (was "SQL & PHP help")

    Hi

    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?

    Thanks
    Jason

  2. #2
    SitePoint Enthusiast
    Join Date
    Sep 2005
    Location
    Midlands, UK
    Posts
    60
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,
    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.

    Cheers
    Steve


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •