Listing recipents with groups

[tomaszko]

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>

 

[fenway]

You need a LEFT JOIN.