saini

What's not pretty in that code? Ok, I found out that DW went crazy and changed string type. I corrected the string type but the same result. Anyway, i changed post to get method to visually control everything. I am on my way and getting results. Hope I will get it over and change get to post again. Thanks anyway.

Here is the complete code: $colname_rsSearch = "-1"; if (isset($_POST['country'])) { $colname_rsSearch = (get_magic_quotes_gpc()) ? $_POST['country'] : addslashes($_POST['country']); } $colname9_rsSearch = "-1"; if (isset($_POST['startdate'])) { $colname9_rsSearch = (get_magic_quotes_gpc()) ? $_POST['startdate'] : addslashes($_POST['startdate']); } $colname10_rsSearch = "-1"; if (isset($_POST['enddate'])) { $colname10_rsSearch = (get_magic_quotes_gpc()) ? $_POST['enddate'] : addslashes($_POST['enddate']); } $colname6_rsSearch = "-1"; if (isset($_POST['tourtype'])) { $colname6_rsSearch = (get_magic_quotes_gpc()) ? $_POST['tourtype'] : addslashes($_POST['tourtype']); } $colname7_rsSearch = "-1"; if (isset($_POST['tourtype'])) { $colname7_rsSearch = (get_magic_quotes_gpc()) ? $_POST['tourtype'] : addslashes($_POST['tourtype']); } $colname8_rsSearch = "-1"; if (isset($_POST['tourtype'])) { $colname8_rsSearch = (get_magic_quotes_gpc()) ? $_POST['tourtype'] : addslashes($_POST['tourtype']); } $colname5_rsSearch = "-1"; if (isset($_POST['tourtype'])) { $colname5_rsSearch = (get_magic_quotes_gpc()) ? $_POST['tourtype'] : addslashes($_POST['tourtype']); } $colname3_rsSearch = "-1"; if (isset($_POST['mindays'])) { $colname3_rsSearch = (get_magic_quotes_gpc()) ? $_POST['mindays'] : addslashes($_POST['mindays']); } $colname4_rsSearch = "-1"; if (isset($_POST['maxdays'])) { $colname4_rsSearch = (get_magic_quotes_gpc()) ? $_POST['maxdays'] : addslashes($_POST['maxdays']); } $colname1_rsSearch = "-1"; if (isset($_POST['city'])) { $colname1_rsSearch = (get_magic_quotes_gpc()) ? $_POST['city'] : addslashes($_POST['city']); } mysql_select_db($database_tour, $tour); $query_rsSearch = sprintf("SELECT tour.*, hotdeals.* FROM (tour LEFT JOIN hotdeals ON hotdeals.tour_hotdeals=tour.id_tour) WHERE (country_tour = %s AND city_tour = %s) OR days_tour>=%s OR days_tour<=%s OR (type_tour LIKE %s OR type2_tour LIKE %s OR type3_tour LIKE %s OR type4_tour LIKE %s) OR start_hotdeals>=%s OR end_hotdeals<=%s ORDER BY tindex_tour ASC", GetSQLValueString($colname_rsSearch, "text"),GetSQLValueString($colname1_rsSearch, "int"),GetSQLValueString($colname3_rsSearch, "text"),GetSQLValueString($colname4_rsSearch, "text"),GetSQLValueString($colname5_rsSearch, "text"),GetSQLValueString($colname6_rsSearch, "text"),GetSQLValueString($colname7_rsSearch, "text"),GetSQLValueString($colname8_rsSearch, "date"),GetSQLValueString($colname9_rsSearch, "int"),GetSQLValueString($colname10_rsSearch, "text")); $query_limit_rsSearch = sprintf("%s LIMIT %d, %d", $query_rsSearch, $startRow_rsSearch, $maxRows_rsSearch); $rsSearch = mysql_query($query_limit_rsSearch, $tour) or die(mysql_error()); $row_rsSearch = mysql_fetch_assoc($rsSearch); The first table named tour has tour description. The second table named hotdeals has dates that are associated with the tour. If you click any tour on site, the description is on the page. On the right hand side, you can see a table with dates, this is what I have in hotdeals table. I may be missing parenthesis, but that's where I always get the problems.

I have a search form that searches 2 tables. I am not getting results correctly. The form is at zetourz.com/search.php If I just select Country and city, it should give out all rows with that country & city, but I am somehow not getting that as expected. The query I have is mysql_select_db($database_tour, $tour); $query_rsSearch = sprintf("SELECT tour.*, hotdeals.* FROM (tour LEFT JOIN hotdeals ON hotdeals.tour_hotdeals=tour.id_tour) WHERE (country_tour = %s AND city_tour = %s) OR name_tour LIKE %s OR days_tour>=%s OR days_tour<=%s OR type_tour LIKE %s OR type2_tour LIKE %s OR type3_tour LIKE %s OR type4_tour LIKE %s OR start_hotdeals>=%s OR end_hotdeals<=%s ORDER BY tindex_tour ASC" Please help find the problem.

[!--quoteo(post=380002:date=Jun 4 2006, 11:05 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jun 4 2006, 11:05 PM) [snapback]380002[/snapback][/div][div class=\'quotemain\'][!--quotec--] While it is possible to accomplish this with a great deal of OR conditions, the better way would be to have another table where you can associate each tour with multiple type. This would make the querying very simple. [/quote] I would love too, but already everything is complcated. Can't use another table for tour types. Any ideas how to do it with OR's? Trying for 3 days here but can't get it right. The problem is some fields are NULL, so results go vary.

I have a table with 4 fields. -------------------------tour------------------------------------ type_tour | type2_tour |type3_tour | type4_tour ------------------------------------------------------------------ running | climbing | walking | fishing -------------------------------------------------------------------- running | fishing | NULL | NULL -------------------------------------------------------------------- climbing | running | fishing | NULL --------------------------------------------------------------------- walking | fishing | running | NULL --------------------------------------------------------------------- fishing | running | NULL | NULL ---------------------------------------------------------------------- walking | NULL | NULL | NULL -------------------------------------------------------------------- Is it possible to query mysql such as: show all rows where type_tour or type2_tour or type3-tour or type4_tour is equal to entered value (entered value can be any one) So, if query is running, I get rows 1,2,3,4,5 if query is walking, I get rows 1,4,6 and so on. Please help. I went again through mysql documentation, but it seems I am missing something. Thanks.