query("select cid, catTitle, catCode from cl_cats order by catTitle, catTitle, cid"); while( $row = $q->fetch() ){ // while( $row = mysql_fetch_array($q) ){ $cid[] .= $row['cid']; $catTitle[] .= $row['catTitle']; $catCode[] .= $row['catCode']; } // switch to two steps $abbr = array(); $q = $mydbh->query("select abbr from topCities group by abbr order by abbr"); while( $row = $q->fetch() ){ $abbr[] .= $row['abbr']; } $stateName = $stateAbbr = $website = array(); for( $i=0; $iquery("select state, abbr, website from topCities where abbr = '$thisAbbr' limit 1"); while( $r = $q->fetch() ){ $stateName[] .= $r['state']; $stateAbbr[] .= $thisAbbr; $website[] .= $row['website']; } } // grab state info // $stateName = $stateAbbr = $website = array(); // $q = $mydbh->query("select state, abbr, website from topCities group by abbr order by abbr"); // $q = mysql_query("select state, abbr, website from topCities group by abbr order by abbr"); // while( $row = mysql_fetch_array( $q ) ){ // while( $row = $q->fetch() ){ //$stateName[] .= $row['state']; //$stateAbbr[] .= $row['abbr']; //$website[] .= $row['website']; // } $q2 = $mydbh->query("select abbr from topCities group by abbr"); // $q2 = mysql_query("select abbr from topCities group by abbr"); $states = array(); // while( $r2 = mysql_fetch_array($q2) ){ while( $r2 = $q->fetch() ){ $states[] .= $r2['abbr']; } ?> <?php echo $pTitle;?>

Craigslist Statewide
Search Tool

Search Now, or Register

We've put together a craigslist® statewide search tool that lets you save your favorite searches, monitor for new items matching your search criteria, even block ads that you feel aren't relevant, or just don't match your search criteria.

CLRDS Offers You A Better & Faster Solution

In a nut shell, our site is an RSS reader. We fill it with the rss links for the searches you want to monitor, then pull down that information either live as you use our tools, or server-side so we can automate emails and more. You're also encouraged to save your favorite searches, so you can click a simple link to re-search, and save items for a direct link to that item you're watching.

Select a Category
Select a State to search (Members can select multiple)