hi...
i have a problem
This is my code
<?php require_once('Connections/repi.php'); ?>
<?php
mysql_select_db($database_repi, $repi);
$query_tahap = "SELECT * FROM subject";
$tahap = mysql_query($query_tahap, $repi) or die(mysql_error());
$row_tahap = mysql_fetch_assoc($tahap);
$totalRows_tahap = mysql_num_rows($tahap);
?>
<? session_start(); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<BODY >
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="left">
<th height="33%" colspan="3" nowrap="nowrap"><?php include 'header.php';?></th>
</tr>
<tr align="left">
<th height="33%" colspan="3" nowrap="nowrap"><?php include 'navigator_bar.php';?></th>
</tr>
<tr align="left" valign="top">
<td width="17%" height="34%"><span class="style1">
<?php include 'menu.php'; ?>
</span></td>
<td width="61%"><div align="center">
<table width="100%" height="80" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td>Senarai Subjek </td>
</tr>
<tr>
<td> </td>
</tr>
<?php do { ?>
<tr>
<td><a href=senarai_subj.php?tahap=<?php echo $row_tahap['TAHAP']; ?>><?php echo $row_tahap['TAHAP']; ?></a></td>
</tr>
<?php } while ($row_tahap = mysql_fetch_assoc($tahap)); ?>
<tr>
<td> </td>
</tr>
</table>
</div></td>
<td width="22%"><span class="style1">
<?php include 'menu2.php';?>
</span></td>
</tr>
<tr align="left" valign="top">
<td height="34%" colspan="3"><?php include 'footer.php';?></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($tahap);
?>
It show a redundant data from the same field in the table.
i just want to show the different data just 1 represent for all the redundant data.
please help me..