SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Apr 2005
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    sql syntax error

    i have userid which is the primary key in members and is a foreign key in booking

    i have movieID which is a primary key in movie and a foreign key in booking

    and the rest the values i wanna put in booking table Showing num, credit card, expiry num

    the problem i m having is that the user types there name in a txt box types which then matches the userid with username in memeber and then saves puts userid in booking.

    the same thing for movieid..user picks movie, movie name gets matched to movie id in movie table and then movie id is put in booking table

    and the rest of the values that are in the txt box Showing num, credit card, expiry num get put in booking table as well...! the problem im having is i keep getting wrong syntax..! this the only problem i have and then i ve finished, could neone help me plz plz

  2. #2
    SitePoint Zealot Sriram_anp's Avatar
    Join Date
    Oct 2004
    Location
    los angeles
    Posts
    116
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If it's a syntax error, post the code.

  3. #3
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    why has this guy crossposted oin nearly every forum?

  4. #4
    SitePoint Wizard
    Join Date
    Oct 2001
    Posts
    2,686
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


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
  •