PHP SQL error

  • Status: Closed
  • Prize: $10
  • Entries Received: 3
  • Winner: bojke89

Contest Brief

Hello
I will need help in my webpage I am getting this error

Error: 1054 - Unknown column 'A' in 'field list' SQL=INSERT INTO jos_fastball_linescore (gameid, inning, runshome, runsaway) VALUES (291, 1, A, A)

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

Recommended Skills

Public Clarification Board

  • ashishgajera
    ashishgajera
    • 11 years ago

    If you want to insert all data in table use
    INSERT INTO jos_fastball_linescore VALUES (291, 1, 'A', 'A') or if you want some field insert you take INSERT INTO jos_fastball_linescore (gameid, inning, runshome, runsaway) VALUES (291, 1, "A", "A")

    • 11 years ago
  • orochipoubelle
    orochipoubelle
    • 11 years ago

    INSERT INTO jos_fastball_linescore (gameid, inning, runshome, runsaway) VALUES (291, 1, 'A', 'A') or INSERT INTO jos_fastball_linescore (gameid, inning, runshome, runsaway) VALUES (291, 1, "A", "A") if runshome and runsaway are string

    • 11 years ago
  • bojke89
    bojke89
    • 11 years ago

    INSERT INTO jos_fastball_linescore (gameid, inning, runshome, runsaway) VALUES (291, 1, A, A)
    =>
    INSERT INTO jos_fastball_linescore (gameid, inning, runshome, runsaway) VALUES (291, 1, 'A', 'A')
    String or char must be within the characters ' Example: 'something'

    • 11 years ago
    1. bojke89
      bojke89
      • 11 years ago

      np. perunga let me at chat :)

      • 11 years ago
    2. ConsultAnnyTech
      ConsultAnnyTech
      • 11 years ago

      I hope that this is string concatenation issue. Let me access your machine, I'll not take more than 5 minutes to correct it.

      • 11 years ago
  • anthonyrios37
    anthonyrios37
    • 11 years ago

    Sr. Did you fix your problem? If not let me know it.

    • 11 years ago
    1. perunga
      Contest Holder
      • 11 years ago

      agregame eskype nyusalex

      • 11 years ago
    2. anthonyrios37
      anthonyrios37
      • 11 years ago

      Alexander? Ya le envie.

      • 11 years ago
  • nafiz351
    nafiz351
    • 11 years ago

    Use Following QUery SQL=INSERT INTO jos_fastball_linescore (gameid, inning, runshome, runsaway) VALUES (291, 1, 'A', 'A'); Because here "A" is a character type or varchar

    • 11 years ago
    1. perunga
      Contest Holder
      • 11 years ago

      Thanks nafiz, I can pay you time fixing it, I can give you the keys of the website, I have no idea hoy to fix it.

      • 11 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!