SQL Query Help

Hello All,
Please give me a hand here, I need this query fixed now. This is what it looks like at the moment:




but I need it to do more than this.

1. I need to display all records that contain the text "test" somewhere in the key, name, or description fields
2. I need to limit the price to between two numbers (greater than 80 and less than 120)

Thanks in advance.

THANK YOU so much for your fast reply - now i have solved my problem and i am all the wiser on SQL syntax - All my participation points go to you, my good friend.

No problemo and thanks for the points...

If you want a small tutorial, you should have a read at http://www.mysql.com/doc/en/Retrieving_data.html

could I please have a hand on this problem as well? When I queried the database, nothing was returned to the script. I retreived the error, and it says:
fetch() without execute()

I don't have a clue what that means. Could you please give me a hand?


By the way, that's a great tutorial - it's a lot nicer than using phpmyadmin to generate queries and then subbing in the variables with perl.

It's because naming a column 'key' isn't a good idea since it's a reserved keyword in SQL (it's used for other stuff)

you should put `key` with the ` things to let your SQL server know you want the column named key instead of the keyword key.

SELECT `key`,name,description,price
FROM p
WHERE (name LIKE '%test%'
OR `key` LIKE '%test%'
OR description LIKE '%test%')
AND price>=80
AND price<=120

Though this ` thing works, I would recommend to just rename the column...