Merhabalar ana iki tablom var birinci tablo
1- ea_appointments - randevular
2- ea_odemetablosu -ödemeler
bir türlü yapamadım
alt alta örnek
müşteri adı | hizmet türü | tarihi | Tutar
<table id="example" class="table table-striped table-bordered" style="width:100%">
<thead>
<tr>
<th>Müşteri Adı</th>
<th>Hizmet Tür</th>
<th>Tarih</th>
<th>Randevu Tutar</th>
</tr>
</thead>
<tbody id="customer-appointments">
<?php
$id =($_GET["id"]);
$sorgu = mysql_query("select * from ea_appointments
inner join ea_odemetablosu on ea_odemetablosu.id_users_customer=ea_appointments.id_users_customer
inner join ea_users on ea_users.id=ea_appointments.id_users_customer
inner join ea_services on ea_services.id=ea_appointments.id_services
where ea_appointments.id_users_customer='".$id."'");
while($hizmet = mysql_fetch_assoc($sorgu)) {
?>
<tr>
<td><?=($hizmet[first_name]);?> <?=($hizmet[last_name]);?></td>
<td><?=($hizmet[name]);?></td>
<td><?=($hizmet[end_datetime]);?></td>
<td><?=($hizmet[ucret]);?></td>
</tr>
<?php } ?>
</tbody>
</table>