i have table in database stores events , date expire. want display events on website display current events first expired events after?   i have tried following sql   $sql = "select noticeid, notice, noticedesc, noticeimg, noticedate, expirydate tbl_notices group noticeid ,expired order expirydate asc";   but returns expired results first due expirydate being ordered asc in query.   my tbl_notice structure looks this   noticeid => int(4) notice => varchar(100) noticedesc => text noticedate => timestamp noticeimg => varchar(40) expirydate => datetime expired => int(1) 0 current or 1 expired   my php code is   $sql = "select noticeid, notice, noticedesc, noticeimg, noticedate, expirydate tbl_notices group noticeid ,expired order expirydate asc"; $result = mysqli_query($conn,$sql);          if ($result->num_rows > 0)         {             // output data of each row             while($row = $result->fetch_assoc())             {         ...
 
Comments
Post a Comment