trying to get all rows containing particular value based on input form from mysql database using php..for that i am using LIKE but shows only the column name ,can't able to fetch the related data ...
also tried with
surya preethaaa wrote: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
where அகல் is the word i gave in text field
Does the text after like start with two single quotes (')? Then that is your problem. Use one single quote to start and end the text.
All things are lawful, but not all things are profitable.
posted 3 years ago
output is SELECT * FROM phpp WHERE value =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
where it is wrong