Ovako, ovo mi je kod prve stranice treneri.php:
$sql="SELECT * FROM treneri order by prezime_ime";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<table width="665" border="0" cellpadding="0" cellspacing="1" class="tabtext">
<tr>
<td width="35" height="20" valign="middle" bgcolor="#F0F0F0"><?php echo $rows['id']; ?></td>
<td width="150" height="20" valign="middle" bgcolor="#F0F0F0"><a href=treneri2.php?id=$prezime_ime><?php echo $rows['prezime_ime'] ?></a></td>
<td width="" height="20" valign="middle" bgcolor="#F0F0F0"><?php echo $rows['institucija']; ?></td>
<td width="105" height="20" valign="middle" bgcolor="#F0F0F0"><?php echo $rows['telefon']; ?></td>
<td width="105" height="20" valign="middle" bgcolor="#F0F0F0"><?php echo $rows['faks']; ?></td>
</tr>
</table>
<?php
}
mysql_close();
A ovo mi je kod stranice treneri2.php:
$sql="SELECT * FROM treneri2";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<table width="1610" border="0" cellpadding="0" cellspacing="1" class="tabtext">
<tr>
<td width="35" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['id']; ?></td>
<td width="150" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['prezime_ime']; ?></td>
<td width="303" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['institucija']; ?></td>
<td width="150" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['adresa']; ?></td>
<td width="150" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['postanski_grad']; ?></td>
<td width="120" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['drzava']; ?></td>
<td width="110" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['br_cert']; ?></td>
<td width="100" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['dat_cert']; ?></td>
<td width="105" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['telefon']; ?></td>
<td width="105" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['faks']; ?></td>
<td width="250" height="20" valign="middle" bgcolor="#F0F0F0"><? echo $rows['email']; ?></td>
</tr>
</table>
<?
}
mysql_close();
Pretpostavljam da nesto nije kako treba na prvoj stranici u dijelu:
<a href=treneri2.php?id=$prezime_ime><?php echo $rows['prezime_ime'] ?></a>
i na drugoj stranici u dijelu:
$sql="SELECT * FROM treneri2";
ili ako je lakse uraditi preko jedne tabele.
damaki