Yes its me again! I just was writing my 2nd and 3rd pages with php for my website, and I did take the hidden input way to pass that variable past the second page. That works fine, I tested it on the top of the page with something like, <? echo you are in the $dept1 department looking at $cat1";?>
now, when i try to list the products in that area it doesn't pull any from the database. I've connected to the database and all that good stuff, then my code from there on is:
$result = mysql_query("select * from products where department like '$dept1' and category like '$cat1'");
while ($row = mysql_fetch_array($result)) {
$cat = $row["name"];
echo "<option value=\"$cat\">\"$cat\"\n";
<rest of page stuff>
now on the two pages before, it runs smoothly, but here it doesn't.
I'll be the first one to admit I've only been at php/mysql for a few months.
matt
