Links Management

select ( "select * from links where cat='" . $_GET ['cat'] . "' order by name,id desc LIMIT $limit" ); } elseif (isset ( $_GET ['search'] )) { $res = $db->select ( "select * from links where name like '%" . $_GET ['search'] . "%' or description like '%" . $_GET ['search'] . "%' order by id desc LIMIT $limit" ); } else { $res = $db->select ( "select * from links order by id desc LIMIT $limit" ); } // $db->print_last_query(); if (isset ( $_GET ['cat'] )) { $numOfRows = $db->select_one ( "Select count(*) from links where cat='" . $_GET ['cat'] . "'" ); } elseif (isset ( $_GET ['search'] )) { $numOfRows = $db->select_one ( "Select count(*) from links where name like '%" . $_GET ['search'] . "%' or description like '%" . $_GET ['search'] . "%'" ); } else { $numOfRows = $db->select_one ( "Select count(*) from links" ); } //$db->print_last_query(); while ( $row = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $p = $row ['0']; $t1 = convert_date ( $row ['date_added'] ); //echo "t1 :".$t1."
"; $t2 = mktime (); //echo "renting time".$t."
"; // echo "now time".$t2."
"; $t3 = $t2 - $t1; //echo "difference time".$t3."
"; $day = ($t3 / 86400); //echo $day; $tab = explode ( '.', $day ); // echo $tab[0]; //$dur=(30); //$expiry=($dur-$tab[0]); //if($expiry<=0)echo "".$expiry.""; //else echo $expiry; $durat = ($dur * 86400); $enddat = ($t1 + $durat); ?>

	Name	Image	Link	Category	Date Added	Actions
		"; else echo ""; ?>		-->	[ Days old]