\n"; ?> http://www.partystuff.co.za/ daily 0.9 weekly 0.8 http://www.partystuff.co.za/products/rent/index.html weekly 0.8 http://www.partystuff.co.za/specials/rent/Specials.html weekly 0.8 http://www.partystuff.co.za/products//rent/.html weekly 0.7 http://www.partystuff.co.za/show_product///rent//.html weekly 0.6 'Disabled' ORDER BY seq, title"; $presult=mysqli_query($myDB, $query); while($prow=mysqli_fetch_row($presult)){ $query="SELECT * FROM $db_products WHERE catid='" . $crow[0] . "' and subid='$prow[0]' and status <> 'Disabled' ORDER BY seq, title"; $pdresult=mysqli_query($myDB, $query); while($pdrow=mysqli_fetch_row($pdresult)){ ?> http://www.partystuff.co.za/product_details////rent///.html weekly 0.6 http://www.partystuff.co.za/products/sale/index.html weekly 0.8 http://www.partystuff.co.za/specials/sale/Specials.html weekly 0.8 'rent' ORDER BY seq, category"; $result=mysqli_query($myDB, $query); while($row=mysqli_fetch_row($result)){ ?> http://www.partystuff.co.za/products//sale/.html weekly 0.7 http://www.partystuff.co.za/show_product///sale//.html weekly 0.6 'Disabled' ORDER BY seq, title"; $presult=mysqli_query($myDB, $query); while($prow=mysqli_fetch_row($presult)){ $query="SELECT * FROM $db_products WHERE catid='" . $crow[0] . "' and subid='$prow[0]' and status <> 'Disabled' ORDER BY seq, title"; $pdresult=mysqli_query($myDB, $query); while($pdrow=mysqli_fetch_row($pdresult)){ ?> http://www.partystuff.co.za/product_details////sale///.html weekly 0.6