\n\n";
$mysql->query( "SELECT * FROM state_list ORDER BY state_long" );
if( $mysql->mysqlRows ) {
while ($stateLoop = mysql_fetch_object( $mysql->mysqlResult ) ) {
$state_list = sprintf( "%s\n", $state_list, $stateLoop->state_short, $stateLoop->state_long );
}
}
$state_list .= "\n";
return $state_list;
}
$mysql = new MySQL();
switch( $node ) {
case( "search" ):
$query = "SELECT * FROM dialups WHERE";
if ( $city ) {
$query = sprintf( "%s city like'%%%s%%'", $query, $city );
$querySwitch++;
}
if ( $area_code ) {
if ( $querySwitch ) {
$query = sprintf( "%s and area_code='%s'", $query, $area_code );
} else {
$query = sprintf( "%s area_code='%s'", $query, $area_code );
$querySwitch++;
}
}
if ( $state ) {
if( $querySwitch ) {
$query = sprintf( "%s and state='%s'", $query, $state );
} else {
$query = sprintf( "%s state='%s'", $query, $state );
$querySwitch++;
}
}
if ( $querySwitch ) {
$query = sprintf("%s order by city asc", $query);
$mysql->query( $query );
if ( $mysql->mysqlRows ) {
while ($rLoop = mysql_fetch_object( $mysql->mysqlResult ) ) {
$results = sprintf("%s\n| %s | \n%s | \n(%s) %s | \n
\n", $results, $rLoop->state, $rLoop->city, $rLoop->area_code, $rLoop->phone_number );
}
} else {
$results = sprintf( "No numbers found for that area." );
}
}
else {
$results = sprintf( "No search parameters found." );
}
$state_list = generate_state_list();
StartPage( "search_results2.tpl" );
$tpl->assign( array( "SEARCH_RESULTS"=>$results ) );
$tpl->assign( array( "STATE_LIST"=>$state_list ) );
break;
default:
StartPage( "search_form.tpl" );
$state_list = generate_state_list();
$tpl->assign( array( "STATE_LIST"=>$state_list ) );
break;
}
FinishPage();
?>