$i = 1; while ($row = mysql_fetch_assoc($result)) { if (!isset($customer)) { $customer = $row['customers_id']; } if ($customer == $row['customers_id'] and $i != 1) { echo "<tr>"; echo "<td class=\"text-center\"><a id=\"" . $i . "\">" . $i . "</a></td>"; echo "<td class=\"text-center\"> </td>"; echo "<td class=\"text-center\"><span class=\"fa fa-mobile\"></span> " . $row['nr_tel'] . "</td>"; echo "<td class=\"text-center\">" . $row['data_zawarcia'] . "</td>"; echo "<tr>"; } else { $customer = $row['customers_id']; echo "<tr>"; echo "<td colspan=\"4\"><h4><a href=\"profil.php?id=" . $row['customers_id'] . "\"><b>" . who_is_name($row['customers_id']) . "</b></a> " . who_is_number($row['customers_id']) . " <span class=\"badge\">" . how_many_number($row['customers_id']) . "</span></h4></td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"text-center\"><a id=\"" . $i . "\">" . $i . "</a></td>"; echo "<td class=\"text-center\"> </td>"; echo "<td class=\"text-center\"><span class=\"fa fa-mobile\"></span> " . $row['nr_tel'] . "</td>"; echo "<td class=\"text-center\">" . $row['data_zawarcia'] . "</td>"; echo "<tr>"; } $i++; } ?> </tbody> </table> <?php } else {
if (!isset($_POST['InputNrTel'])) { $_POST['InputNrTel'] = ""; } $dlugosc = strlen($_POST['InputNrTel']); if ($dlugosc == 9) { $result = mysql_query("SELECT id, customers_id, nr_tel, data_zawarcia FROM tabela_um_an WHERE nr_tel = '" . $_POST['InputNrTel'] . "' AND typ_uslugi = 'KUD' AND salon = '" . $_SESSION['salon'] . "';") or die(mysql_error()); } else { $result = mysql_query("SELECT id, customers_id, nr_tel, data_zawarcia FROM tabela_um_an WHERE data_zawarcia >= '" . $_POST['InputDateFrom'] . "' AND data_zawarcia <= '" . $_POST['InputDateTo'] . "' AND typ_uslugi = 'KUD' AND salon = '" . $_SESSION['salon'] . "';") or die(mysql_error()); } if ($result) { $i = 1; while ($row = mysql_fetch_assoc($result)) { echo "<tr>"; echo "<td>{$i}</td>"; echo "<td><a href=\"profil.php?id=" . $row['customers_id'] . "\">" . who_is_name($row['customers_id']) . "</a></td>"; echo "<td class=\"text-center\">" . who_is_number($row['customers_id']) . "</td>"; echo "<td>" . $row['nr_tel'] . "</td>"; echo "<td>" . $row['data_zawarcia'] . "</td>"; echo "<td><a href=\"profil.php?id=" . $row['customers_id'] . "\" class=\"btn btn-info btn-xs\"><span class=\"glyphicon glyphicon-wrench\"></span> Opcje</a></td>"; echo "</tr>"; $i++; } } ?> </tbody> </table> <?php } ?> </div> </div>