Help with EZ Auto

[revfive]

Ok, I keep getting

 

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 'range as value, range as text FROM jos_ezautos_price ORDER by ordering' at line 1 SQL=SELECT range as value, range as text FROM jos_ezautos_price ORDER by ordering

 

on the search page.

 

I have found the code that it refers to, but not sure how to fix it

 

$sql = "SELECT range as value, range as text FROM #__ezautos_price ORDER by ordering";

 

any help would be awesome!!

[PFMaBiSmAd]

range is a reserved mysql keyword. You either need to rename your column to something else or enclose it in back-ticks `` every time you use it in a query.