session_start();
include("includes/database.php");
//userSession();
?>
::: C3M :::
include('header-pc.html')?> |
Projects LIST |
|
|
|
SNo |
Name of Project/Location |
Description |
Remarks |
|
|
global $p_num;
global $page;
global $pages_num;
global $p_per_page;
global $page_first_p;
$page = (int)$_GET[page];
$p_per_page = (int)$_POST['p_per_page'];
if ( !$page )
$page = 1;
if ( !$p_per_page )
$p_per_page = 10;
$i=1;
$up="select * from tbl_projects where projects_status2 = '1' ";
$up_sql=mysql_query($up);
$pagenum=mysql_num_rows($up_sql);
$page_num= ceil($pagenum/10);
$real_first_p = (int)($page - 1) * $p_per_page;
$page_first_p = $real_first_p + 10;
$sel= mysql_query("select * from tbl_projects where projects_status2 = '1' LIMIT ".$real_first_p.",".$p_per_page."");
while($res= mysql_fetch_array($sel))
{
$sno++;
if($flag==0)
{
$flag=1;
$color="#ffffff";
}
else
{
$flag=0;
$color="#F0F0F0";
}
?>
|
|
|
$check="select intrest from tbl_userinrested where user_id='" . $_SESSION['u_id'] . "' and projects_id='" . $res['projects_id'] . "' and intrest='1'";
$ttt = mysql_query($check);
$resultarray = mysql_num_rows($ttt);
if($resultarray == 0)
{
$tochecked=false;
}
else
{
$tochecked=true;
}
?>
|
}
?>
|
PageResults: - | Total: |
|
|
|
|
|
|
|
|
|