if row empty not working mysql

Question

I am trying to show different image if the other is empty but the below code isn't working for me. In this case I have empty row for image two and image three has image name.

What am I missing here?

    $stmt = $mydb->prepare("select * from images where username = ? order by id desc");
echo $mydb->error;
$stmt->bind_param('s', $username->username);
$stmt->execute();
$result = $stmt->get_result();
?>
<?php while ($row = $result->fetch_assoc()) {
if($row['image_two'] = '')
{
echo $row['image_three'];
}
}?>

please think about accepting a answer so the thread closes. Thanks! — Cristian Cavalli
– Cristian Cavalli, Commented Nov 10, 2013 at 1:11
@CristianCavalli Okay I did, as it always tells me to wait I then forget. — user2926655
– user2926655, Commented Nov 10, 2013 at 1:13
remember to be careful with loose comparisons (i.e. '==') Strict comparisons like '===' are generally better, although when dealing with what php considers to be null or empty use of the empty() function is generally more reliable. — Cristian Cavalli
– Cristian Cavalli, Commented Nov 10, 2013 at 1:16

John · Accepted Answer · 2013-11-10 00:16:19Z

3

you should do it with the native PHP functions

if(empty($row['image_two']))

Returns FALSE if var exists and has a non-empty, non-zero value. Otherwise returns TRUE.

The following things are considered to be empty:

"" (an empty string)
0 (0 as an integer)
0.0 (0 as a float)
"0" (0 as a string)
NULL
FALSE
array() (an empty array)
$var; (a variable declared, but without a value)

answered Nov 10, 2013 at 0:16

John

5844 silver badges19 bronze badges

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

Comments

jeffjenx · Accepted Answer · 2013-11-10 00:13:17Z

1

You need to use double equals for comparison.

if($row['image_two'] == '')

answered Nov 10, 2013 at 0:13

jeffjenx

17.6k6 gold badges63 silver badges104 bronze badges

Collectives™ on Stack Overflow

if row empty not working mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related