SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Jan 2005
    Location
    Hiding from the world
    Posts
    321
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Setting up a table in the correct way

    Hi,
    iam going to put our quaterly magazine online for people who don't want a paper copy (as we are an environmental charity).

    Iam using php and mysql, what is the best way to set up the table. i was thinking i could either have a table like

    title, mainText, issue, page


    or

    article1, article2, article3 etc all in one row.

    which is better or is there another way that i haven't thought of. Any suggestions appreciated.
    If i am a product of your imagination you should try harder!

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    definitely the first way
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Jan 2005
    Location
    Hiding from the world
    Posts
    321
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    thanks, thats what i thought. I presume i would then have to pass the variables with the get method to the sql query.

    page.php?issue=1&page=1
    If i am a product of your imagination you should try harder!

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    you could also use POST method, if the site visitor made the selection from dropdowns for example
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •