query("SELECT * FROM designers WHERE id='".myaddslashes(trim($_GET['id']))."';")); echo ""; echo ""; if($_GET['state']!="") { echo ""; echo ""; $rs=$db->query("SELECT city FROM designers WHERE state='".myaddslashes(trim($_GET['state']))."' GROUP BY city;"); echo ""; if($_GET['city']!="" && $_GET['state']!="") { echo ""; echo ""; $rs=$db->query("SELECT * FROM designers WHERE country='".myaddslashes(trim($_GET['country']))."' AND state='".myaddslashes(trim($_GET['state']))."' AND city='".myaddslashes(trim($_GET['city']))."';"); echo ""; } } }?>

Designers In Your Area

Country:
United States | Canada
\n"; echo "".$row['company_name'].""; echo "
\n"; echo $row['first_name']." ".$row['last_name']."
\n"; echo $row['mailing_address']."
\n"; echo $row['city'].", ".$row['state'].", ".$row['postal_code']."
\n"; echo substr($row['phone'],0,3)."-".substr($row["phone"],3,3)."-".substr($row["phone"],6,4)."
\n"; if($row['web_address']!="") echo "".$row['web_address']."
\n"; if($row['email']!="") echo "".$row['email']."
\n"; }?> "; $rs=$db->query("SELECT state FROM designers WHERE country='".myaddslashes(trim($_GET['country']))."' GROUP BY state"); echo "
State/Province"; $row=mysql_fetch_array($rs); echo "".$row['state'].""; while($row=mysql_fetch_array($rs)) { echo " | ".$row['state'].""; } echo "
City"; $row=mysql_fetch_array($rs); echo "".$row['city'].""; while($row=mysql_fetch_array($rs)) { echo " | ".$row['city'].""; } echo "
Designer"; while($row=mysql_fetch_array($rs)) { if($row['company_name']=="") $row['company_name']=$row['first_name']." ".$row['last_name']; echo "".$row['company_name']."
"; } echo "

DESIGNERS: If you wish to have your contact enlisted in our database, please provide your details including phone numbers, fax numbers, email, website etc. to sales@printoutlet.us. We will ask that you include our link on your website in exchang for your listing on our database.

Printoutlet provides you with a list of designers that are available for you to contact for designing your brochure, flyer, insert, sell sheet, leaflet, business card, post card, rack card or any other printed piece that you may want printoutlet to print for you. We also offer design services to you directly if you wish us to design and print your requirements.

Printoutlet does not promote, nor support, guarantee price, delivery, satisfaction or quality of the work that is performed on any recommended designers that are listed in the attached database.
close(); include("includes/specialpage_footer.php"); ?>