Hot Springs of the United States

2) echo "


\n"; ?>

Select a state:  

'; $o='name'; if ($_REQUEST['sort']=='name') $o='name'; else if ($_REQUEST['sort']=='lat') $o='lat'; else if ($_REQUEST['sort']=='long') $o='long'; else if ($_REQUEST['sort']=='temp') $o='temp'; #$o="to_number(temp,'999')"; else if ($_REQUEST['sort']=='county') $o='county'; else if ($_REQUEST['sort']=='quadrangle') $o='quadrangle'; $q="select * from hotsprings where state = '$state' order by $o;"; $r=pg_exec($db,$q); $rows=pg_numrows($r); printf("Number of hot springs found: %d

\n",$rows); ?> Add Link\n"; echo ' '; for ($i=0;$i<$rows;$i++) { $d=pg_fetch_array($r,$i,PGSQL_ASSOC); if (strlen(trim($d['name']))<1) $d['name']="Un-named"; echo "\n"; #printf('', #$d['lat'],-$d['long'],$d['name']); printf('', $i,$d['lat'],$d['long'],$i,urlencode($o),$d['name']); printf("\n",$d['state']); printf("\n",$d['temp']); printf("\n",$d['lat']); printf("\n",$d['long']); printf("\n",$d['county']); if (strlen(trim($d['quadrangle']))<1) $d['quadrangle']=' '; printf("\n",$d['quadrangle']); if ($_SERVER['REMOTE_ADDR']=='') { printf("\n", $d['lat'], $d['long'], $d['state'], $i, urlencode($o)); } echo "\n"; } ?>
>Name State >°F >Lat >Long >Region >Quadrangle
%s%s%s%s%2.3f%3.3f%s%sAdd Link

[Hot Springs Forum]     [Hot Springs Photos]     [Deep Creek Hot Springs]