Form data problem/question

I implemented a search query on my database that would list all songs of a certain primary and secondary genre for visitor to easily find something they would like to listen to. However, I have noticed that one of my genres doesn't do anything when you try to search for it. I have negated the problem of spelling errors, by implementing a drop down menu on my insert record admin page to insert the genre text data. Now I am just stuck with the remaining bewilderment.

Top of the page - try Light Instrumental (you can see clearly in my top 5 latest version below it, that there is a genre match...)
Working Demo

Any thoughts?

No thoughts on this one?

maybe the name is too long have you tried changing it to "Light Instr." instead ... ?

I thought of that one too. I thought maybe using the GET with its character limitations might have been the issue. It was "minimalistic Instrumental" then I changed it to "Light Instrumental," this morning I tried your suggestion and it still won't pass the results to the page. Sort of confusing. My queries are Dreamweaver created and it is filtering the genre column in my table by the URL parameter passed from the drop down value on submit. Everyone of the options seem to be going good, but this one just doesn't want to show its face.

have you tried running the query inside phpMyAdmin or MySqlQueryBrowser to see what it returns?

I tried running the same query script that dreamweaver genrerated in my phpMyAdmin Process window with resulting error messages. I am sure this is because I am structuring the SQL statement incorrectly and not accouting for variables that the PHP/URL form action is passing. Here is what I have for my query in dreamweaver.


of course genre is the actual table column, whereas colname is a variable from my form results. How would I structure this, if you need any other info I can try my best to get it. I am just one of those guys who learns enough to get by - getting by in this case is slowly making the site better.

Thanks for your help

that seems right ... but when you run that query remember that colname will need to be in quotation marks ('), so it'd be something like this ...

so try doing this in phpMyAdmin and see what happens:

Worked like a charm. Too bad it doesn't on the site. Although everything else is coming out just fine. It's only this one value... maybe it's some tiny Dreamweaver thing I am overlooking.

wow ... this is truly strange ... what does the code look like on that search page? or at least that part that reads the data out of the DB and onto the page ...

The Dreamweaver generated PHP portion dealing with this query: