I queried my database, which gets data that then populates a dropdown box in a form. This works quite well.
The form provides the provides the criteria for the next search, which searches against that criteria. The problem is the second search only works right for ONE-WORD data in the column. In this situation, the "column" is "city." Two-word only partially works.
For example, if I search against Chicago, all information pertaining to Chicago will be generated. But, if I search against Los Angeles I get my "no data available" message.
I put in (echo "$city"😉 to see what is actually being searched. For Chicago, I get "Chicago," but for Los Angeles, I get only "Los."
Is the space causing the problem? How can I correct this? The "city" column datatype in my DB is CHAR. I am new to PHP/MySQL but if you can just point me in the right direction, I think I can get the rest of the way. I greatly appreciate any help.
🙁
