Loading

Check each row not null

Smr

Hi,I have one table. it contains 5 columns, 11 rowsthe problem is i want to check the 5th column in the table contain value which is 'Done'.if any row does not contain the 'Done' value in 5th column, it will return error.How to do this?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Md Sarfaraj5y ago
Hello Smr,
Use the sql query for checking like,
select * from table_name where 5thcolumn_name = "Done";

Execute this query, if this return one then it means it contains done value else there is no done value.

This is an example code:
$query_one     = "SELECT `id` FROM " . T_REPORTS . " WHERE `post_id` = {$post_id} AND `user_id` = {$user_id}";
    $sql_query_one = mysqli_query($sqlConnect, $query_one);
    if (mysqli_num_rows($sql_query_one) >= 1) {
        return true;
    }
+1