SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Apache Expert i_like_php's Avatar
    Join Date
    Nov 2001
    Location
    Dallas, Texas
    Posts
    1,342
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Does This Look About Right.

    ok i am creating an .sql file for my articles script that i plan to use for my site, once i got everything planned just right. anyways, if this is in the wrong forum move it to proper one .

    ok here's everything i got so far...


    create table article (
    id
    title
    author
    published
    updated
    length
    bio
    article rating
    author rating
    articles by author
    );

    ok here's where i get stumped, adding more stuff to the sql file. some of the fields will have multiple fields, and i was wondering how do i add all of to sql file.

    like on the bio i want to be able to add a small image, along with some fields to kinda tell people who they are and whatnot.

    did i confuse anybody? i hope not, anyways i hope someone can kindly explain how to do what i'm asking.
    i love php

  2. #2
    Apache Expert i_like_php's Avatar
    Join Date
    Nov 2001
    Location
    Dallas, Texas
    Posts
    1,342
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    opps ignore the fact that i haven't declared anything in the script, keep in mind it's still a rough draft lol
    i love php

  3. #3
    SitePoint Wizard swdev's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    1,053
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ty reading the manual for whichever RDBMS server you are using. That will tell you the correct syntax for the CREATE TABLE command.

    Then go on from there.


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
  •