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

Top entries from this contest

View More Entries

Public Clarification Board

  • ashishgajera
    ashishgajera
    • 2 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")

    • 2 years ago
  • orochipoubelle
    orochipoubelle
    • 2 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

    • 2 years ago
  • bojke89
    bojke89
    • 2 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'

    • 2 years ago
    1. bojke89
      bojke89
      • 2 years ago

      np. perunga let me at chat :)

      • 2 years ago
    2. ConsultAnnyTech
      ConsultAnnyTech
      • 2 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.

      • 2 years ago
  • anthonyrios37
    anthonyrios37
    • 2 years ago

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

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

      agregame eskype nyusalex

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

      Alexander? Ya le envie.

      • 2 years ago
  • nafiz351
    nafiz351
    • 2 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

    • 2 years ago
    1. perunga
      Contest Holder
      • 2 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.

      • 2 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!