update_sql ( "update countries set active=" . $_GET ['show'] . " where id=" . $_GET ['id'] ); //$db->print_last_query(); // $location=$_GET['location']; print ""; exit (); } if (isset ( $_GET ['d'] )) { $r = $db->select ( "select id,path from countries where id=" . $_GET ['d'] ); if ($row ['path'] == "") unlink ( "../uploads/" . $row ['path'] ); $row = $db->get_row ( $r, 'MYSQL_BOTH' ); $db->delete ( "delete from countries where id=" . $row ['0'] ); //$db->print_last_query(); //$location=$_GET['location']; if ($_GET ['pagination']) { $pagination = $_GET ['pagination']; print ""; } exit (); } if (! empty ( $_POST ['deleted_pdts'] )) { $r = $db->select ( "select id,path from countries where id IN(" . $_POST ['deleted_pdts'] . ")" ); while ( $row = $db->get_row ( $r, 'MYSQL_BOTH' ) ) { if ($row ['path'] == "") unlink ( "../uploads/" . $row ['path'] ); $db->delete ( "delete from countries where id=" . $row ['0'] ); } //$db->print_last_query(); print ""; exit (); } ?>

Our countries

select ( "select * from countries order by sorting LIMIT $limit" ); // $db->print_last_query(); $numOfRows = $db->select_one ( "Select count(*) from countries" ); //$db->print_last_query(); while ( $row = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $p = $row ['0']; ?>

	Name	Flag	Actions

Name Sorting Flag (JPG,GIF,PNG)

insert_sql ( "insert into countries(flag,name,sorting)values('" . $path1 . "','" . $_POST ['country'] . "','" . $_POST ['sorting'] . "')" ); //$db->print_last_query(); print ""; } ?>