"; } ?>

The following countries are members of the Organization for Economic Cooperation and Development.

1	Australia
2	Austria
3	Belgium
4	Canada
5	Czech Republic
6	Denmark
7	Finland
8	France
9	Germany
10	Greece
11	Hungary
12	Iceland
13	Ireland
14	Italy
15	Japan
16	Korea, South
17	Luxembourg
18	Mexico
19	Netherlands
20	New Zealand
21	Norway
22	Poland
23	Portugal
24	Slovakia
25	Spain
26	Sweden
27	Switzerland
28	Turkey
29	United Kingdom
30	United States
Source: Organisation for Economic Co-operation and Development

"; $sql_table_check = "SHOW TABLES LIKE '".$table."'"; $table_check_result = mysql_query($sql_table_check); if($table_check_result) { if( mysql_num_rows($table_check_result)) { //if($table!="") //{ //$indexArray = split("-",$r); //$theCondition="theIndex = 1000000"; //for($a=1;$a$line[1]"; //$relatedLink=str_replace('^^','',$relatedLink); //echo "

$relatedLink

"; //} //} //} //} $querydb="select tblDatabaseDriven.fileName, tblDatabaseDriven.condition, tblDatabaseDriven.related, tblDatabaseDriven.dataTable, tblDatabaseDriven.measure2, tblDatabaseDriven.columns, tblDatabaseDriven.display,tblDatabaseDriven.location FROM tblDatabaseDriven where tblDatabaseDriven.fileName=\"$file\""; $resultdb=mysql_query($querydb); $relatedKey=-1; if($resultdb) { $linedb=mysql_fetch_array($resultdb); //$file=$linedb[0]; $theCondition=$linedb[1]; $relatedKey=$linedb[2]; $dataTable=$linedb[3]; $measure2 = $linedb[4]; $tableColumns = $linedb[5]; $display=$linedb[6]; $location=$linedb[7]; } $seeRelated=""; if($relatedKey>0) { $queryRelated="select tblRelated.name, tblRelated.value FROM tblRelated where related=".$relatedKey; $resultRelated=mysql_query($queryRelated); $seeRelated=""; while(($lineRelated=mysql_fetch_array($resultRelated))) { $relatedFile=$lineRelated[0]; $relatedTitle=$lineRelated[1]; $seeRelated=$seeRelated."

".$relatedTitle."

"."\n"; } } if($location=="europe") { $locationCondition=" AND (fb2.value LIKE \"%Europe,%\" OR fb2.name=\"Russia\" OR fb2.name=\"Turkey\") "; } if($location=="asia") { $locationCondition=" AND (fb2.value LIKE \"%Asia,%\" AND fb2.name!=\"Russia\" AND fb2.name!=\"Turkey\") "; } if($location=="africa") { $locationCondition=" AND (fb2.value LIKE \"%Africa,%\") "; } if($location=="oceania") { $locationCondition=" AND (fb2.value LIKE \"%Oceania,%\") "; } if($location=="south america") { $locationCondition=" AND (fb2.value LIKE \"%South America,%\") "; } if($location=="central america") { $locationCondition=" AND (fb2.value LIKE \"%Central America,%\") "; } if($location=="north america") { $locationCondition=" AND (fb2.value LIKE \"%North America,%\" OR fb2.name=\"Mexico\") "; } if($location=="middle east") { $locationCondition=" AND (fb2.value LIKE \"%Middle East,%\") "; } if($location=="caribbean") { $locationCondition=" AND (fb2.value LIKE \"%Caribbean,%\") "; } if($location=="americas") { $locationCondition=" AND (fb2.value LIKE \"%America,%\") "; } //include("lr_324/wa2.php"); //$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value tblDataCodes.fips FROM $table, fb0, fbURLs tblDataCodes WHERE (fb0.name=$table.name AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb0.value=\"independent\") order by $table.value $order)"; $query_b=mysql_query("SELECT * from $table LIMIT 1"); $columns = mysql_num_fields($query_b); for ($i = 0; $i < $columns; $i++) {$field_array[] = mysql_field_name($query_b, $i);} if($orderby==="value"){$orderby=$table.".value";} if(!(strpos($measures,"Country")===false) && in_array("name",$field_array) && in_array("value",$field_array)) //if(strpos($measures,"Country")===0 && in_array("name",$field_array) && in_array("value",$field_array)) //if(strpos($table,"fb")===0) { // This statement differs from the one below by the condition ($table.value > 0 OR CHAR_LENGTH($table.value)>0 ) //$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND ($table.value > 0 OR CHAR_LENGTH($table.value)>0 )AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND ($table.value > 0)AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; } else { $columnCheck=true; $theColumns=""; $arrayOfMeasures=split("--",$measures); foreach ($arrayOfMeasures as $aMeasure) { $theColumns=$theColumns.", ".$aMeasure; if(!in_array(strtolower($aMeasure), $field_array)){$columnCheck=False;} } $theColumns=substr($theColumns,1); echo""; if(strlen($tableColumns)>1) { $columnCheck=true; $theColumns=$tableColumns; } $orderPhrase=""; if(strlen($orderby)>1) { $orderPhrase="order by $orderby $order"; } if($columnCheck) { if(strlen($theCondition)>3) { $query1 = "SELECT $theColumns FROM $table where $theCondition $orderPhrase"; } else { $query1 = "SELECT $theColumns FROM $table $orderPhrase"; } } else { if(strlen($theCondition)>1) { $query1 = "SELECT * FROM $table where $theCondition $orderPhrase"; } else { $query1 = "SELECT * FROM $table $orderPhrase"; } } } if($table=="table_expensive_streets") { $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, $table.location FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $table.value $order"; } if($measures=="Population - Muslim and other faiths") { $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, fb70.value FROM $table, fb0, fbURLs, tblDataCodes, fb2, fb70 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name AND fb0.name=fb70.name AND (fb70.value LIKE \"Muslim%\" OR fb70.value LIKE \"Sunni%\") ". $dependencyCondition . $locationCondition .") order by $table.value $order"; } if($measures=="Population - Christian and other faiths") { $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, fb70.value FROM $table, fb0, fbURLs, tblDataCodes, fb2, fb70 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name AND fb0.name=fb70.name AND (fb70.value LIKE \"Christian%\" OR fb70.value LIKE \"Roman%\" OR fb70.value LIKE \"Protestant%\" OR fb70.name LIKE \"Nigeria\" ) ". $dependencyCondition . $locationCondition .") order by $table.value $order"; } define("sql_error_reporting",true); //result1 = mysql_query($query1) or mail("info@aneki.com", "countries2 error", "Sql error of ".$_SERVER["SCRIPT_NAME"].". Call to `$table` in ".__FILE__." ".$_GET["file"]." on line: ".__LINE__."
".mysql_error()."
SQL:
$query1
"); $result1 = mysql_query($query1); echo""; if($result1) { $decimal='.'; $separator=','; $position=0; $num_rows=0; if($number=="all") { $num_rows = mysql_num_rows($result1); } else { $num_rows = $number; } if($table=="table_expensive_streets") { echo""; $theRows=""; while (($line = mysql_fetch_array($result1)) && ($position<$num_rows) ) { $position=$position+1; $modulus=($position%2)+1; $theNumber=number_format($line[1],$places,$decimal,$separator); //$countryLink=str_replace("http://www.aneki.com/","/",$line[5]); if($cntdn=="y") { $theRows="".$theRows; } else { $theRows=$theRows.""; } } echo"$theRows"; echo"

	Country	Location	Rent (US $/sq.ft/yr)
$position.	$line[3]	$line[5]	$unit$theNumber
$position	$line[3]	$unit$theNumber

"; } else { //echo"