PHP SQL error

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