The Science Network

Home Friends Groups Mail Log Out

"; if (!$db) /* conditional statement */ { die('Connection to Database down: '. mysql_error()); /* print if connection is not established */ } mysql_select_db("ScientistNet", $db); /*select database */ if (!(isset($pagenum))) { $pagenum = 1; } //checking the number of page $email =$_SESSION['email']; //$email = 'mm@hot.com';// change to session $_SESSION['email'] $sql =mysql_query("SELECT timestamp, subject ,name ,m.id as mailid , opened FROM Mail m , Scientist s WHERE s.id = m.recipient AND s.email='$email' ORDER BY timestamp") or die(mysql_error()); $page_rows=4; $rows = mysql_num_rows($sql); $last = ceil($rows/4); if ($pagenum < 1) { $pagenum = 1; } elseif ($pagenum > $last) { $pagenum = $last; } $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; // get inbox info $sql_p = $sql =mysql_query("SELECT timestamp, subject , name , m.id as mailid , opened FROM Mail m , Scientist s WHERE s.id = m.recipient AND s.email='$email' ORDER BY timestamp") or die(mysql_error()); ?> "; echo ""; while($info = mysql_fetch_array( $sql)) // display mail result in table { echo ""; echo ""; echo ""; echo ""; echo ""; $mail = $info['mailid']; echo ""; echo ""; echo ""; } echo ""; echo "

From	Subject	Date	Opened	Read
"; Print $info['name']; echo "	"; Print $info['subject']; echo "	"; Print $info['timestamp']; echo "	"; if( $info['opened'] == 'T') // change the staus when the message is read $opened = 'yes'; else $opened = 'no'; Print $opened; echo "	"; echo "

"; echo " --Page $pagenum of $last--

"; /* -nivagation option */ if ($pagenum == 1) { } else { echo " <<-First "; echo " "; $previous = $pagenum-1; echo " <-Previous "; } /* display previous page */ if ($pagenum == $last) { } else { $next = $pagenum+1; echo " Next -> "; /* display next page */ echo " "; echo " Last ->> "; /* display last page */ } mysql_close($db); ?>