'shoe') AND (type<>'print') AND (type<>'sock') AND (type<>'tote')) ORDER BY item"); $maevn = mysql_query("SELECT * FROM Maevn ORDER BY item"); $med = mysql_query("SELECT * FROM MedCouture ORDER BY item"); $mer = mysql_query("SELECT * FROM Merrell ORDER BY item"); $new = mysql_query("SELECT * FROM NewBalance ORDER BY item"); $smit = mysql_query("SELECT * FROM Smitten WHERE (collection <> 'Accessory') ORDER BY item"); $urbane = mysql_query("SELECT * FROM Urbane ORDER BY item"); $wink = mysql_query("SELECT * FROM Wink ORDER BY item"); mysql_close(); header('Content-Type: text/xml;charset=utf-8'); $file = "sitemap.xml"; $pf = fopen ($file, "w"); if (!$pf){echo "cannot create $file\n"; return; } fwrite ($pf,' https://pkwscrubs.easycgi.com/pkwscrub/'); while ($row = mysql_fetch_array($car)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Carhartt\n"); } while ($row = mysql_fetch_array($che)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Cherokee\n"); } while ($row = mysql_fetch_array($dansko)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/dansko.php?item=" . $row['item'] . "\n"); } while ($row = mysql_fetch_array($greys)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Greys\n"); } while ($row = mysql_fetch_array($koi)) { if ($row['type'] == 'print') { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/print.php?item=" . substr($row['item'],0,3) . "&vendor=Koi\n"); } else {fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Koi\n"); } } while ($row = mysql_fetch_array($landau)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Landau\n"); } while ($row = mysql_fetch_array($maevn)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Maevn\n"); } while ($row = mysql_fetch_array($med)) { if ($row['type'] == 'print') { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/print.php?item=" . $row['item'] . "&vendor=MedCouture\n"); } else {fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=MedCouture\n"); } } while ($row = mysql_fetch_array($mer)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/merrell.php?item=" . $row['item'] . "\n"); } while ($row = mysql_fetch_array($new)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/newBalance.php?item=" . $row['item'] . "\n"); } while ($row = mysql_fetch_array($smit)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Smitten\n"); } while ($row = mysql_fetch_array($urbane)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Urbane\n"); } while ($row = mysql_fetch_array($wink)) { fwrite ($pf, "https://pkwscrubs.easycgi.com/pkwscrub/include/php/detail.php?item=" . $row['item'] . "&vendor=Wink\n"); } fwrite ($pf, "\n"); fclose ($pf); ?>