Check column value if has value = 0

Question

I went through some posts but I didn't find the answer that I was looking for. I don't use so much PHP and MYSQL in my work, but i have to create some demo for the page.

So i want to do this: With PHP i want to check in SQL database if column 'no' has value = 0, if it has then echo this, if has different value then echo this.

$query=mysqli_query($conn,"SELECT * FROM tablename WHERE no = 0");
$row=mysqli_fetch_array($query);

if($row="0")
{
    echo "not confirmed";
}
    else
{
    echo "confirmed";
}

first you `print_r($row);` and add result in this question – Bilal Ahmed Jun 09 '17 at 09:47 — Bilal Ahmed, Jun 09 '17 at 09:47
1) `$row` is __array__, 2) `=` means `assign` – u_mulder Jun 09 '17 at 09:47 — u_mulder, Jun 09 '17 at 09:47
Got it working guys by kRicha! thanks anyway! – unforgiven Jun 09 '17 at 09:52 — unforgiven, Jun 09 '17 at 09:52

score 0 · Accepted Answer · answered Jun 09 '17 at 09:49

0

For comparing you need to use this:

if ($row['no']=="0") {
    echo "not confirmed";
} else {
    echo "confirmed";
}

answered Jun 09 '17 at 09:49

kRicha

797
9
27

Great men, it is working! Cheers – unforgiven Jun 09 '17 at 09:52
@unforgiven np) just mark question as resolved) – kRicha Jun 09 '17 at 09:52

Check column value if has value = 0

1 Answers1