tom11011 Posted September 19, 2006 Share Posted September 19, 2006 Basically, there are 2 required fields, but if other fields have data in them, it should query them. Thenks in advance.[code]$query = "SELECT * FROM table WHERE sl = '$sl' and state = '$state'"; if (strlen($type) > 0) { $query = $query + " and type = '$type'"; } if (strlen($city) > 0) { $query = $query + " and city = '$city'"; } if (strlen($zip) > 0) { $query = $query + " and zip = '$zip'"; } if (strlen($status) > 0) { $query = $query + " and status = '$status'"; } if (strlen($pricemin) > 0) { $query = $query + " and price >= '$pricemin'"; } if (strlen($pricemax) > 0) { $query = $query + " and price <= '$pricemax'"; } if (strlen($squarefeetmin) > 0) { $query = $query + " and squarefeet >= '$squarefeetmin'"; } if (strlen($squarefeetmax) > 0) { $query = $query + " and squarefeet <= '$squarefeetmax'"; } if (strlen($ppsfmin) > 0) { $query = $query + " and ppsfmin >= '$ppsfmin'"; } if (strlen($ppsfmax) > 0) { $query = $query + " and ppsfmax <= '$ppsfmax'"; } $query = $query + " ORDER BY price;";[/code] Quote Link to comment Share on other sites More sharing options...
obsidian Posted September 19, 2006 Share Posted September 19, 2006 close:[code]<?php$query = "SELECT * FROM table WHERE sl = '$sl' and state = '$state'";if (!empty($type)) $query .= " AND type = '$type'";if (!empty($city)) $query .= " AND city = '$city'";if (!empty($zip)) $query .= " AND zip = '$zip'";// and so on?>[/code] Quote Link to comment Share on other sites More sharing options...
tom11011 Posted September 19, 2006 Author Share Posted September 19, 2006 thanks! worked. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.