I have a php file that contains the queries as strings. I have wrote the following query:
SELECT message_no, sender, destination, time_received, type, reference_no, message FROM messages WHERE message LIKE '%:substring%';
:substring is then assigned a value from $substring.
The query works when i run it directly in cmd however it does not work within the php web application.
All messages with the substring value within $substring should be displayed.
I believe there must be a problem with this part:
Any help would be much apprieciated.