[eluser]Bigil Michael[/eluser]
but it shows database error
A Database Error Occurred
Error Number: 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 '' at line 1
SELECT DISTINCT state.state_name,state.state_id FROM state JOIN location ON (location.state_id = state.state_id) ORDER BY state.state_name LIMIT 10 ,