How to put P instead of 1 and A instead of 0

Question

I am querying my database as below:

<?php while($date <= $end) { $ttl++; $student_array = array(); $stu_name_td = ''; mysqli_data_seek($result,0); while($innerrow = mysqli_fetch_array($result)) { $atd_query = "SELECT * FROM attendance WHERE AttDate = '".date('Ym-d', $date)."' AND sl_no = '".$innerrow['sl_no']."'"; $present_stu_res = mysqli_query($link, $atd_query); $test = mysqli_num_rows($present_stu_res) > 0 ? 1 : 0; } echo "<th>".date('j/m/Y', $date)."</th>"; $date = strtotime("+1 day", $date); } ?> 

How can I display P in place 1 and A instead of 0 in my report?

Answer 1

Change your code as:

 (mysqli_num_rows($present_stu_res) > 0) ? "P" : "A";