I am facing an issue with my ajax request.
Actually, I am unsure of how to fetch multiple records.
I attempted the following:
$rqt = "SELECT a,b,c from table";
$res = mysql_query($rqt);
while ($data = mysql_fetch_assoc($res)):
$objet = $data;
endwhile;
//requesting
return $objet;
However, it only outputs one row in PHP even though there are several records in the database.
The second issue is related to displaying these records.
In jQuery, I tried this:
$.ajax({
type: "POST",
url: "requetes_ajax/fetch_debours_detail.json.php",
data: "groupe="+groupe_debours,
success: function(data){
$('.remove').remove()
console.log(data);
$.each(data, function (key, value) {
$('#fetchdebours tr:last').after('<tr class="remove"><td>'+data.libelle_debours+'</td><td>'+data.date+'</td><td>'+data.debours_montant_ht_tva+'</td><td>'+data.debours_montant_ht_no_tva+'</td><td>'+data.debours_montant_ttc+'</td></tr>')
//alert(key + ': ' + value);
});
}
});
The problem here is that instead of displaying all records in one row, it populates items both horizontally and vertically, resulting in as many rows as columns.
Any assistance on this matter would be greatly appreciated.