PHP SQL error

  • État: Closed
  • Prix: $10
  • Propositions reçues: 3
  • Gagnant: bojke89

Résumé du concours

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.

Compétences recommandées

Tableau de clarification publique

  • ashishgajera
    ashishgajera
    • il y a 9 ans

    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")

    • il y a 9 ans
  • orochipoubelle
    orochipoubelle
    • il y a 9 ans

    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

    • il y a 9 ans
  • bojke89
    bojke89
    • il y a 9 ans

    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'

    • il y a 9 ans
    1. bojke89
      bojke89
      • il y a 9 ans

      np. perunga let me at chat :)

      • il y a 9 ans
    2. ConsultAnnyTech
      ConsultAnnyTech
      • il y a 9 ans

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

      • il y a 9 ans
  • anthonyrios37
    anthonyrios37
    • il y a 9 ans

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

    • il y a 9 ans
    1. perunga
      Titulaire du concours
      • il y a 9 ans

      agregame eskype nyusalex

      • il y a 9 ans
    2. anthonyrios37
      anthonyrios37
      • il y a 9 ans

      Alexander? Ya le envie.

      • il y a 9 ans
  • nafiz351
    nafiz351
    • il y a 9 ans

    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

    • il y a 9 ans
    1. perunga
      Titulaire du concours
      • il y a 9 ans

      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.

      • il y a 9 ans

Montrer plus de commentaires

Comment commencez des concours

  • Publiez votre concours

    Publiez votre concours Rapide et facile

  • Obtenez des tonnes de propositions

    Obtenez des tonnes de propositions De partout dans le monde

  • Attribuez la meilleure proposition

    Attribuez la meilleure proposition Télécharger les fichiers - Facile !

Publier un concours maintenant ou rejoignez-nous maintenant !