i have developed a php project with xampp 8.1.10 now when i upload it to cpanel the project duplicates data. below is the query
$conn=db();
$query = mysqli_query($conn,"SELECT * FROM items
JOIN item_unit ON item_unit.unitId=items.unitId
JOIN stock_category ON stock_category.categoryId=items.categoryId
JOIN warehouse ON warehouse.warehouseId=items.warehouseId
WHERE warehouse.branchId=$branchId ORDER BY itemName ASC $limit");
if(!$query || mysqli_num_rows($query) <= 0){
}else{
return $query;
}
this is the offline project results
this is the online project results
the projects tends to duplicates items fives times each and i do not know what is the problem
i have not tried anything. i was expecting thr project to behave the same as offline