wagnerskunk
New Member
Ok so i am having a problem with figuring this problem out. I have a dynamic page that has records pulled out of a mysql database. The php code works great. The code is below\[code\]$catagory = $_GET['type'];$query = "SELECT p.name, p.price, pc.quantity, p.image, p.descr FROM products ... where category_name = $catagory "; $result = mysql_query($query);$related = array();while($row_r = mysql_fetch_assoc($result)){ $related[] = $row_r;}\[/code\]later on down the page I loop through them\[code\]<div class="main-blue"><div class="blue-items"><?php foreach ($related as $row_r) { ?> <span class="digit"><span class="digit-r"><?php print $row_r["quantity"] ?></span></span> <h3><?php print $row_r['name'] ?></h3>.....\[/code\]The problem is I have a \[code\]<div class="dropdown"><ul><li><a href="http://stackoverflow.com/questions/3622763/#" class="icon-s icon-s1">Grocery</a></li><li><a href="http://stackoverflow.com/questions/3622763/#" class="icon-s icon-s2">Pizza</a></li><li><a href="http://stackoverflow.com/questions/3622763/#" class="icon-s icon-s3">Quick Service</a></li><li><a href="http://stackoverflow.com/questions/3622763/#" class="icon-s icon-s4">Retail</a></li><li><a href="http://stackoverflow.com/questions/3622763/#" class="icon-s icon-s5">Salon</a></li><li><a href="http://stackoverflow.com/questions/3622763/#" class="icon-s icon-s6">Bar</a></li></ul>\[/code\]I need to be able to select one of the dropdowns like for example Bar I need to regrab the record from mysql and make the page load with the records for Bar without refreshing . like \[code\]$catagory = "Bar";$query = "SELECT p.name, p.price, pc.quantity, p.image, p.descr FROM products ... where category_name = $catagory "; \[/code\]