Search found 3 matches
- Tue Nov 15, 2005 5:15 pm
- Forum: PHP - Code
- Topic: PHP MySQL query
- Replies: 7
- Views: 400
Thanks for all the ideas. Just one last question: I'm just learning php and all but I find it wierd that i can't get to use % as a wildcard. When i'm testing a query in SQL this works fine: SELECT * FROM floorplans WHERE floorplans.PlanWidth Like '%' AND floorplans.PlanDepth Like '37' It returns all...
- Tue Nov 15, 2005 2:44 pm
- Forum: PHP - Code
- Topic: PHP MySQL query
- Replies: 7
- Views: 400
I see where you're going. Create a separate query depending on what fields the user fills in. This may work in this situation. What do i do when i will need to have a whole lot more fields to search by? Right now I am indeed trying to get it work with two fields. But in the end, having a floorplan d...
- Tue Nov 15, 2005 1:42 pm
- Forum: PHP - Code
- Topic: PHP MySQL query
- Replies: 7
- Views: 400
PHP MySQL query
I'm having a problem with a search and results page that i'm trying to put together. I have a database with four fields among which PlanWidth and PlanDepth. My search page has two fields: WidthSearch and WidthDepth. If i put numbers in both fields say W:35 and D:37 i get back the records that have t...