PHP Why If / Else statement not working in While loop?

Question

This is my code and I don't know why IF/ELSE statement is not working

$user_id = $_POST['user_id'];

$strSQL = "SELECT chat.user_id,max(date) max_date ,user.user_id,user.firstname,user.lastname,user.picture 
    FROM ( select from_user_id as user_id,date,isread from chat 
      WHERE to_user_id = '$user_id' 
      Union select to_user_id as user_id,date,isread from chat WHERE from_user_id = '$user_id' ) as chat join user on user.user_id = chat.user_id 
    where user.status != 'block' group by chat.user_id order by max_date DESC";
      $chatdata = array();
      $objQuery = mysql_query($strSQL);

         while($row = mysql_fetch_assoc($objQuery)){
          $frduser_id = $row['user_id'];
          $firstname = $row['firstname'];
          $lastname = $row['lastname'];
          $picture = $row['picture'];
          $strSQL2 = "SELECT isread from chat WHERE to_user_id = '$user_id' and from_user_id = '$frduser_id'
                      ORDER BY date DESC LIMIT 1";

           //array_push($chatdata, $row);
      $objQuery2 = mysql_query($strSQL2);
      if (empty($objQuery2)) {
          $row2 = 1;
          $result = array_merge($row, $row2);
          array_push($chatdata,$result);
      }else{
      $row2 = mysql_fetch_assoc($objQuery2);
       $result = array_merge($row, $row2);
      array_push($chatdata,$result);
  }
}

in IF clause statement it'is not working in if but else it's working I don't know why — Peter
– Peter, Commented Oct 19, 2015 at 6:32

Maha Dev · Accepted Answer · 2015-10-19 06:32:22Z

2

You can use mysql_num_rows to get count of rows inside results.

$objQuery2 = mysql_query($strSQL2);
$objQuery2Rows = mysql_num_rows($strSQL2);

if ( $objQuery2Rows < 1) {
      $row2 = 1;
      $result = array_merge($row, $row2);
      array_push($chatdata,$result);    
 }else{
      $row2 = mysql_fetch_assoc($objQuery2);
      $result = array_merge($row, $row2);
      array_push($chatdata,$result);
 }

answered Oct 19, 2015 at 6:32

Maha Dev

3,9653 gold badges34 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP Why If / Else statement not working in While loop?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related