<?
session_start();
?>
<html>
<?
echo"<form method='POST' action='essai.php'>";
$nb="select count(*) from Project";
$resnb=mysql_query ($nb) or die ("request1 doesn't work");
$row=mysql_fetch_row($resnb);
//$x=0;
echo"<input type='hidden' name='x' value=0>";
echo "<center>";
echo "<input name='tri'type='radio' value='W'checked>W-project";
echo "<input name='tri'type='radio' value='F'>F-project";
echo " <input type='submit' value='Display'>";
echo "</center>";
echo "</form>";
if(isset ($tri))
{
echo $x;
if ($x<0)
$x=0;
if($x+10 >= $row[0])
$x_plus=$x;
else
$x_plus=$x+10;
$x_moins=$x-10;
$req="select
Project.nbproject,nameproject,firstname,lastname,namedirectory from
Project,Users,Molfile where Project.nbusers=Users.nbusers and
Molfile.nbproject=Project.nbproject and namedirectory like '%$tri%' group
by Project.nbproject limit $x,10";
$res=mysql_query ($req) or die ("request2 doesn't work");
echo "<table width=500 border=1 align='center'>";
echo "<tr>
<td><b><center>Project code</center></b></td>
<td><b><center>Project name</center></b></td>
<td><b><center>Author</b></center></td>
<tr>";
while($ligne=mysql_fetch_array($res))
{ extract($ligne);
echo "<tr>\n
<td><center><a href =
'javascript: popup(\"essai2.php?id=$nbproject\",500,500,\"menubar=no,scrollbars=yes,statusbar=no,resizable=yes\")'>
$namedirectory</a></center></td>
<td><center>$nameproject</center></td>
<td><center>$firstname $lastname</center></td>
<tr>";
}
echo "</table>";
echo "<br><br>";
echo " <table width=500 align='center'>";
echo "<tr><td><a
href='essai.php?x=$x_moins'><center>Previous</center></a></td>";
echo "<td><a href='download.php'
target='_blank'><center>Download</center></a></td>";
echo "<td><a href='essai.php?x=$x_plus
&nbproject=$nbproject'><center>Next</center></a></td></tr></table>";
echo "<br><br>";
}
?>