Boolean column creating problem

[s4salman]

I am using this sql to filter records :

 

$query = "select * from mobileprices where range='5000'"

but i am getting this error message :

mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/dracra/public_html/a.com/range.php

 

range field contains product prices range and filled with 5000, 10000, 15000, 20000 etc.

I tried the following code to update the range values from numeric to text in phpmyadmin sql area :

 

UPDATE mobileprices
SET range='five'
WHERE range='5000'

 

but i am getting this error message :

 

#1064 - 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='five' WHERE range='5000'' at line 2

 

I am confused as there are thousands of records and manually updating it one by one will take so much time.

Anyone could help me out as how i can change numeric with text in range.

 

or there is any way by that sql could accept this :

 

$query = "select * from mobileprices where range='5000'"

 

I need a solution, so please help me !!

[jcbones]

range is a MySQL reserved keyword, wrap it in backticks  `range`='5000'

[s4salman]

got this working

 

UPDATE prices
SET `range`='twentyfive'
WHERE `range`='25000'

 

 

thanks