\n"); print ("

\n"); print ("U.S. Locations

\n"); print ("
\n"); print ("\n"); $queryState = "SELECT * FROM States WHERE StateAbbr = '$state'"; //connect and do query $link=mysql_connect("localhost", "minigraph", "m7l8t9"); $resultState = mysql_db_query("Minigraphics", $queryState, $link); while ($row1=mysql_fetch_array($resultState)) { print("\n"); print("\n"); print("\n"); } $query = "SELECT pp_locations.*, State, StateAbbr FROM pp_locations, States WHERE pp_locations.StateID = States.StateID and States.StateAbbr = '$state'"; $Result=mysql_db_query("Minigraphics", $query, $link); //print out results to page while ($Row=mysql_fetch_array($Result)) { print("\n"); print ("\n"); print ("\n"); print ("\n"); print ("\n"); print ("\n"); if ($Row[Phone] == NULL) { print ("\n"); } print ("\n"); print ("\n"); } mysql_close($link); print ("\n"); print ("\n"); print ("\n"); print ("\n"); print ("\n"); print ("\n"); print ("

$row1[State]
$Row[StoreName]	$Row[Street]	$Row[City]	$Row[State]	$Row[Zipcode]		$Row[Phone]
\n"); } print ("BACK \n"); print ("Copyright © 2000 MiniGraphics. All Rights Reserved. \n"); print ("2975 Exon Avenue | Cincinnati, Ohio | 45241 \n"); print ("Orders: (800) 442-7035 | Office: (513) 563-8600 | Fax: (513) 563-6650 \n"); print ("Email: minig@one.net\n"); print ("

\n"); print ("\n"); print ("\n"); print ("\n"); ?>