PHP MYSQL Variable returns error

Question

Simple question, but my searching is not finding an answer. I am trying to use a variable in a MySQL search and I keep getting an error. I know the variable value is good because when I pass it directly it works. Here is the error I get

"Error: something went wrong: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Bank of CanadaGROUP BY YEAR(date), MONTH(date) DESC' at line "

$query = "SELECT * FROM current_rates WHERE 
financial_institution =". $lenderName .
"GROUP BY YEAR(date), MONTH(date) DESC";

you need a space before GROUP. and please for the question properly — user6763587
– user6763587, Commented Dec 11, 2017 at 4:44
Thank you made the change and still gett error. My variable is set to lenderName = 'Royal Bank of Canada'; and the error message drops the first word for some reason. — user7748962
– user7748962, Commented Dec 11, 2017 at 4:46

Pupil · Accepted Answer · 2017-12-11 04:46:36Z

5

Strings in MySQL must be enclosed with single quotes.

Otherwise, they will be considered as reserved words/column names.

The corrected SQL should be:

$query = "SELECT * FROM current_rates WHERE 
 financial_institution ='". $lenderName .
 "' GROUP BY YEAR(date), MONTH(date) DESC";

Also, as per answer from Bhaumik Mehta, you need to add a space before GROUP BY tag.

answered Dec 11, 2017 at 4:46

Pupil

24k6 gold badges49 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

oreopot · Accepted Answer · 2017-12-11 04:46:33Z

3

Try this query:

1) You need to enclose $lenderName in '' as the it is a string value.

2) You need to have space before GROUP BY keyword

$query = "SELECT * FROM current_rates WHERE financial_institution ='". $lenderName ."' GROUP BY YEAR(date), MONTH(date) DESC";

answered Dec 11, 2017 at 4:46

oreopot

3,4592 gold badges23 silver badges31 bronze badges

Comments

Nazish Fraz · Accepted Answer · 2017-12-11 05:48:30Z

0

please given one space between name and group

$query = "SELECT * FROM current_rates WHERE financial_institution ='".$lenderName."' GROUP BY YEAR(date), MONTH(date) DESC";

answered Dec 11, 2017 at 5:48

Nazish Fraz

941 silver badge9 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL Variable returns error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related