helwo Posted March 28, 2006 Share Posted March 28, 2006 I have two fields in a table that I need filtering. The fields are passed but it does not filter subcat2_id?can anyone help?[code]<?php$colname_store_items = "1";if (isset($_GET['subcat2_id'])) { $colname_store_items = (get_magic_quotes_gpc()) ? $_GET['subcat2_id'] : addslashes($_GET['subcat2_id']);}$colname_store_items = "1";if (isset($_GET['subcat_id'])) { $colname_store_items = (get_magic_quotes_gpc()) ? $_GET['subcat_id'] : addslashes($_GET['subcat_id']);}mysql_select_db($database_vacuumshop, $vacuumshop);$query_store_items = sprintf("SELECT * FROM store_items WHERE subcat_id = %s AND store_items.subcat2_id", $colname_store_items);$store_items = mysql_query($query_store_items, $vacuumshop) or die(mysql_error());$row_store_items = mysql_fetch_assoc($store_items);$totalRows_store_items = mysql_num_rows($store_items);?>[/code] Quote Link to comment https://forums.phpfreaks.com/topic/5995-pass-2-url-filter/ 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.