Line | |
---|
1 | <? |
---|
2 | require_once('../db-config/connect-mysql.php'); |
---|
3 | $query = "SELECT data_type.serial AS type_id, maincase_new.owner_org, maincase_new.loc1_lon, maincase_new.loc1_lat, maincase_new.description, maincase_new.website FROM data_type, maincase_new, maincase_detail WHERE maincase_detail.maincase_id = maincase_new.serial AND maincase_detail.type_id = data_type.serial AND type_id =" . $_GET['type_id'] . " AND owner_org = '" . $_GET['owner_org'] . "' ORDER BY loc1_lon, loc1_lat"; |
---|
4 | if ($database_connect) mysql_select_db($database_connect) or die('USE '.$database_connect.' failed!'); |
---|
5 | $result = mysql_query($query) or die("Query failed! $query"); |
---|
6 | $rows = mysql_num_rows ($result); |
---|
7 | if ($rows != 0) |
---|
8 | { |
---|
9 | echo "[\n"; |
---|
10 | for ($i=0 ; $i < $rows ; $i++) |
---|
11 | { |
---|
12 | $col= mysql_fetch_row($result); |
---|
13 | echo "{ \"type_id\" : " . $col[0] . ", \"owner_org\" : \"" . $col[1] . "\", \"loc1_lon\" : \"" . $col[2] . "\", \"loc1_lat\" : \"" . $col[3] . "\", \"description\" : \"" . $col[4] . "\", \"website\" : \"" . $col[5] . "\"},\n"; |
---|
14 | } |
---|
15 | echo "]"; |
---|
16 | } |
---|
17 | ?> |
---|
Note: See
TracBrowser
for help on using the repository browser.