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...

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.

Read more

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

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

    • 1 year ago
  • orochipoubelle
    orochipoubelle
    • 1 year 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

    • 1 year ago
  • bojke89
    bojke89
    • 1 year 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'

    • 1 year ago
    1. bojke89
      bojke89
      • 1 year ago

      np. perunga let me at chat :)

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

      • 1 year ago
  • anthonyrios37
    anthonyrios37
    • 1 year ago

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

    • 1 year ago
    1. perunga
      perunga
      Contest Holder
      • 1 year ago

      agregame eskype nyusalex

      • 1 year ago
    2. anthonyrios37
      anthonyrios37
      • 1 year ago

      Alexander? Ya le envie.

      • 1 year ago
  • nafiz351
    nafiz351
    • 1 year 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

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

      • 1 year ago

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!