\n"; echo ""; // then add sorting options echo ""; if($by == 'countriesE' && $order == 'ASC') echo ''; else echo ''; if($by == 'imports11' && $order == 'DESC') echo ''; else echo ''; if($by == 'FSIscore' && $order == 'DESC') echo ''; else echo ''; if($by == 'GPIRank12' && $order == 'DESC') echo ''; else echo ''; if($by == 'FHStatus' && $order == 'DESC') echo ''; else echo ''; print(" "); // all done now. echo ''; while($row = mysql_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $stct=$stct+1; } print("

About Us           Useful links/Search           Social Media Links          Archives          Editorial & Research Services          Return to Homepage
Freedom, Stability and Peace Status of US Oil Suppliers Click on column headers to resort
Row Number	Countries	Countries	US Oil Imports 2011	US Oil Imports 2011	Failed State Index score	Failed State Index score	Global Peace Index	Global Peace Index	Freedom House Status	Freedom House Status
" . $stct . "	" . $row['countriesE'] . "	" . $row['imports11'] . "	" . $row['FSIscore'] . "	" . $row['GPIRank12'] . "	" . $row['FHStatus'] . "
Sources: Oil Imports, Energy Information Administration of the US Department of Energy; Failed State Index, Fund for Peace; Freedom Status, Freedom House; Global Peace Index, Institute for Economics and Peace.

"); ?>