php compare current date with dates stored in database

Question

I am trying coding a php script where i want to extract a date field from a database table,store this date compare it with todays. To see if the data. from database has passed or not compared to todays date.

1. the code i have written for this functionality looks like its not working
2. I think i am getting the date() format wrong.
3. I am not to sure about the logic if statments.

php

$sql="SELECT enddate FROM campaigns WHERE id=".$data['camp'];
    $result = mysqli_query($db, $sql);

while($info = mysqli_fetch_assoc($result)){
    if(date("Y-m-d") > $result){
        exit;
        echo "Success";
    }
    elseif(date("Y-m-d") < $result){
        return true;
        echo "Failure";
    }
}

Answer 1

Use strtotime()

while($info = mysqli_fetch_assoc($result)){
    if(strtotime(date("Y-m-d")) > strtotime($result)){
        exit;
        echo "Success";
    }
    elseif(strtotime(date("Y-m-d")) < strtotime($result)){
        return true;
        echo "Failure";
    }
}