Search found 3 matches

by ThEeNd
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...
by ThEeNd
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...
by ThEeNd
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...