if staments not working....

[hooch_au78]

howdy,

i have a page which gets inlcuded into certain pages on the site.. on the included page it does a query to a db then gets a value this part works fine. It then should check that value it gets from the db against some names do prceed aquardingly b ut for some reason it's defaulting to the 1st if statment despite the value gotten from the db
see code below...

<?

//get company from db
$res = mysql_query("SELECT company FROM users WHERE uname='$_SESSION[uname]'");
$num = mysql_numrows($res) ;
if ($num == 1) {
$company = mysql_result($res, 0, 'company');
echo $company;
}
//check to see if the company is one of these
if ($company='Company1') {
$company = "company1";
}

elseif ($company='Company2') {
$company = "company2";
}
// if not then default to this one
else {
$company = "default";
}
?>

[ahundiak]

You need to use == in a comparision.
if ($company == 'Company1')
{

[mcgruff]

Rgr.

It is kind of confusing at first but "=" doesn't mean "equals" in php: it means "assign this value to the variable".

Check out the "operators" section of the php manual (php.net - downloadable version with user comments is worth getting).

[hooch_au78]

cheers ahundiak & mcgruff i figured was something simple..

I need some more sleep i think 😃 but thanks for your help