Quote:
Originally Posted by perplexed
So whilst not displaying the results yet, the query shows up as;
Select * from database_name where artist like 'beatles' song like '%love%' order by 'folder'
This should normally display all songs by the beatles with the word 'love' anywhere in the title. (folder refers to the physcal folder i have music scores stored in)
Do you think the problem now moves on to the target (of the POST command) script of the query page? If so i can supply the script for that, it is only a few lines.
|
Not sure what you mean by 'moves on'. Your query is wrong for a start. It should be Select * from database_name where artist like 'beatles' AND song like '%love%' order by 'folder' The AND is missing. How is the query being constructed? Is error reporting on (if not, add the line error_reporting(E_ALL); at the top of your script) and have you any undefined variable errors?