Hello,
today's problem - my table only shows recipent which are in group, not ones without a group. I think I made wrong query to database.
$q = "SELECT * FROM recipent, group WHERE group.id_group=recipent.group_id";
$w = mysql_query($q) or die ('Error: '. mysql_error());
?>
<hr />
<table method='get'>
<tr><th></th><th>
<a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=imie">Imię</a>
</th><th>
<a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=nazwisko">Nazwisko</a>
</th><th>
<a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=telefon">Telefon</a></th><th><a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=mail">Mail</a> </th>
<th>
<a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=miasto">Miasto</a></th><th><a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=ulica">Ulica</a> </th>
<th>
<a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=kodpocztowy">Kod Pocztowy</a></th>
<th>
<a href="<?php echo $_SERVER['PHP_SELF'];?>?sortuj=grupa_id">Grupa</a></th></tr>
<?php
while ($record = mysql_fetch_assoc($w)) {
?>
<tr>
<td><input type="checkbox"/></td>
<td><?php echo $rekord['imie'];?></td>
<td><?php echo $rekord['nazwisko'];?></td>
<td><?php echo $rekord['telefon']; ?></td>
<td><?php echo $rekord['mail'];?></td>
<td><?php echo $rekord['miasto'];?></td>
<td><?php echo $rekord['ulica']; ?></td>
<td><?php echo $rekord['kodpocztowy']; ?></td>
<td><?php echo $rekord['nazwa']; ?></td>
<td><a href="odbiorcy_edytuj.php?akcja=edytuj&id_klient=<?php echo $rekord['id_klient'];?>"><?php echo "Edytuj"?></a></td>
<td><a href="odbiorcy_usun.php?akcja=usun&id_klient=<?php echo $rekord['id_klient'];?>"><?php echo "Usuń"?></a></td>
</td>
</tr>
<?php
}
?>
</table>
And code bellow is cell where group name is displayed.
<td><?php echo $rekord['nazwa']; ?></td>
