mysql and php if($ x='z'

[webster76]

$image = mysql_query("SELECT `photo` FROM employees WHERE `id`='154' ");
while ($row = mysql_fetch_assoc($image)) {
$picture = $row['photo'];



if ($picture = 'http://yorsite.com/images/employees/154.jpg');
{
echo "Picture already exists";
}
	}

This code seem to return 'Picture already exists' no matter what the result of the query, i've tried various combination but still get he same result.

[laserlight]

if ($picture = 'http://yorsite.com/images/employees/154.jpg');

probabaly should be:

if ($picture == 'http://yorsite.com/images/employees/154.jpg')

(Note the change of = to == and the remove of the terminating semi-colon.)

[bradgrafelman]

That's because you're using the wrong operator; the '=' operator is used for assignment, e.g. changing the value of a variable.

What you need is the logical operator '==' that allows you to compare two things. See this page for more information about the different operators: [man]language.operators[/man].

EDIT: D'oh, laserlight and I posted at the same time :p

[webster76]

@

@

thank you problem solved 🙂

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.