PHP SQL error

Status: Closed
Hadiah: $10
Penyertaan Diterima: 3
Pemenang: bojke89

Winner

Ringkasan Peraduan

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.

Kemahiran Disyorkan

Winner

Siarkan Peraduan Seperti Ini

Papan Penjelasan Umum

ashishgajera
- 11 tahun yang lalu
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 tahun yang lalu
orochipoubelle
- 11 tahun yang lalu
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 tahun yang lalu
bojke89
- 11 tahun yang lalu
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 tahun yang lalu
Lihat 2 mesej lagi
1. bojke89
  - 11 tahun yang lalu
  np. perunga let me at chat :)
  - 11 tahun yang lalu
2. ConsultAnnyTech
  - 11 tahun yang lalu
  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 tahun yang lalu
anthonyrios37
- 11 tahun yang lalu
Sr. Did you fix your problem? If not let me know it.
- 11 tahun yang lalu
Lihat 5 mesej lagi
1. Penganjur Peraduan
  - 11 tahun yang lalu
  agregame eskype nyusalex
  - 11 tahun yang lalu
2. anthonyrios37
  - 11 tahun yang lalu
  Alexander? Ya le envie.
  - 11 tahun yang lalu
nafiz351
- 11 tahun yang lalu
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 tahun yang lalu
1. Penganjur Peraduan
  - 11 tahun yang lalu
  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 tahun yang lalu