PHP SQL error

  • Status: Closed
  • Præmier: $10
  • Modtagne indlæg: 3
  • Vinder: bojke89

Konkurrence Instruktioner

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.

Anbefalede færdigheder

Offentlig Præciserings Opslagstavle

  • ashishgajera
    ashishgajera
    • 11 år siden

    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 år siden
  • orochipoubelle
    orochipoubelle
    • 11 år siden

    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 år siden
  • bojke89
    bojke89
    • 11 år siden

    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 år siden
    1. bojke89
      bojke89
      • 11 år siden

      np. perunga let me at chat :)

      • 11 år siden
    2. ConsultAnnyTech
      ConsultAnnyTech
      • 11 år siden

      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 år siden
  • anthonyrios37
    anthonyrios37
    • 11 år siden

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

    • 11 år siden
    1. perunga
      Konkurrenceafholder
      • 11 år siden

      agregame eskype nyusalex

      • 11 år siden
    2. anthonyrios37
      anthonyrios37
      • 11 år siden

      Alexander? Ya le envie.

      • 11 år siden
  • nafiz351
    nafiz351
    • 11 år siden

    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 år siden
    1. perunga
      Konkurrenceafholder
      • 11 år siden

      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 år siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!