bide şimdi bu datadan gelmesi gereken örnek datayi söyle
Buyr bu da listeleme sayası, connection.php db ayar dosyası;
<html>
<head>
<title>All New Sesame 2009</title>
<link href="style/style.css" rel="stylesheet" type="text/css">
</head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<body background="images/back.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"><body>
<div align="center">
<table width="72%" border="1" bgcolor="#FFFFFF">
<tr>
<td height="85"><div align="center"><font color="#999999" size="6"><strong>All
New Sesame 2009</strong></font></div></td>
</tr>
<tr>
<td height="249" valign="top">
<div align="center">
<p><font size="3"><br>
<?php
include("connection.php");
include("test.php");?>
<table align="center">
<font size="2" color="red">Incomplete payments are shown up with red color</font></table><br>
<table width="%100" border="1" align="center">
<tr>
<td width=%10><strong>Student ID</strong></td>
<td width=%25><strong>Students Name</strong></td>
<td width=%25><strong>House Phone</strong></td>
<td width=%40><strong>Options</strong></td>
</tr>
<?php
$sayfa = !empty($_GET["sayfa"]) ? intval($_GET["sayfa"]) : 1;
$baslangic = ($sayfa - 1 ) * $limit;
$show=mysql_query("select * from students group by name order by id DESC LIMIT $baslangic,$limit");
while ($record=mysql_fetch_array($show)) {
$studentid=$record['id'];
{if($record['durum']=='Payment Completed'){ $renk='<font color="">';}else{$renk='<font color="red">';}
echo " <tr>
<td>" .$record['id'] . "</td>
<td>" .$renk. $record['name'] . "</td>
<td>". $record['housephone'] . "</td>
<td><a href=details.php?id=$studentid>Student Details</a> | <a href=edit.php?id=$studentid>Edit Student Details</a> | <a href=delete.php?studentid=$studentid>Delete Student</a> </td>
</tr>
</font>
";
}
}
?>
</table><center>
<? include("test.php");?></center>
</body>
</html>