PHP SQL error

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

Winner

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

Winner

Post a Contest Like This

Public Clarification Board

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
- 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
- 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
View 2 more messages
1. bojke89
  - 11 years ago
  np. perunga let me at chat :)
  - 11 years ago
2. 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
- 11 years ago
Sr. Did you fix your problem? If not let me know it.
- 11 years ago
View 5 more messages
1. Contest Holder
  - 11 years ago
  agregame eskype nyusalex
  - 11 years ago
2. anthonyrios37
  - 11 years ago
  Alexander? Ya le envie.
  - 11 years ago
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. 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