if ($data is Null value...?

salsa_dancer

I am trying to return a result based on another field being empty.. have tried all sorts to get it to work... can anyone help... I know it will be something simple....

echo " $data->BusinessName \n";

					[COLOR=red]if ( $data->BusinessName = '' ")[/COLOR] {
						echo " ".$data->FirstName; echo " "; echo "<font color=\"000000\">$data->LastName</font><br>\n"; 
					}

SicChild

empty(); ?

is_null(); ?

salsa_dancer

neither of those worked... 🙁

SicChild

Well you must be doing something wrong? why do you have $data->, is it an object? You're posting a form aren't you?

salsa_dancer

here is the full code..... have marked in red the bit where I want it to return the first and last name ONLY if the businessname is empty....

$result = mysql_query( $query, $link );

}
echo "\n \n";
while ($data = mysql_fetch_object( $result )) {
$data++;
?>

<?php
echo " $data->businessName \n";
if ( $data->FirstName <> ''){
echo " ".$data->FirstName; echo " "; echo "$data->LastName \n";
}
if ( $data->Address <> ''){
echo $data->Address;
}
if ($data->Address_2 <> ''){
echo ", ".$data->Address_2;
}
if ($data->Address_3 <> ''){
echo ", ".$data->Address_3;
}
if ($data->city <> ''){
echo ", ".$data->city;
}
if ($data->county <> ''){
echo ", ".$data->county;
}
if ($data->PostalCode <> ''){
echo ", ".$data->PostalCode;
}
if ($data->Country <> ''){
echo ", ".$data->Country;
}
if ($data->HomePhone <> ''){
echo " \nTelephone: ".$data->HomePhone;
}
if ($data->WorkPhone <> ''){
echo " \nTelephone 2: ".$data->WorkPhone;
}
if ($data->Salutation <> ''){
echo " \n Styles Taught: ".$data->Salutation;
}
if ($data->qualifications <> ''){
echo " \nMember of: ".$data->qualifications;
}
if ($data->website <> ''){
echo " \nWebsite: <a target=\"_blank\" href=\"$data->website\">".$data->website."</a>\n";
}
if ($data->email <> ''){
echo " \nEmail: <a href=\"mailto:\"$data->email\">".$data->email."</a> \n";
}
}

?>

dalecosp

originally posted by salsa_dancer
I know it will be something simple

Yes, 'tis...

one = is the ASSIGNMENT operator
the COMPARISON operator is two ==

😉

wreed

also I think you want

$variable == ""

I think you dont need any space between the quotes, but I may be wrong there...

dalecosp

Originally posted by wreed
also I think you want
$variable == ""
I think you dont need any space between the quotes, but I may be wrong there... [/B]

No space if checking for null, quite right. A space, and you would be checking for, uh, a space 🙂

salsa_dancer

it works!!! Joy!!!!!

I am going to be able to launch this thing on Thursday now!!

Thanks for all your help everyone...

wreed

I tell you man PHP is awesome, I swear its so much easier to understand than ASP....glad we can help ya man.

dalecosp

Originally posted by salsa_dancer
it works!!! Joy!!!!!

Ahh....

It's the little things in life... like comparison operators 😉

salsa_dancer

can you help me with this problem... trying to get the mailto: command to work but it keeps coming up blank in the 'to' line of the email software... the URL link works ok..


if ($data->website <> ''){
							echo "<br>\n<font color=\"#6f6f6f\">Website:</font> <a target=\"_blank\" href=\"$data->website\"><font color=\"#008000\">".$data->website."</font></a>\n";
						}
						if ($data->email <> ''){
							echo "<br>\n<font color=\"#6f6f6f\">Email:</font> <a href=\"mailto:\"$data->email\"><font color=\"#008000\">".$data->email."</font></a>\n";
						}

wreed

Try that, I defined the variable in my test page and use that code and it worked.....


if ($data->website <> ''){
                            echo "<br>\n<font color=\"#6f6f6f\">Website:</font> <a target=\"_blank\" href=\"$data->website\"><font color=\"#008000\">".$data->website."</font></a>\n";
                        }
                        if ($data->email <> ''){
                            echo "<br>\n<font color=\"#6f6f6f\">Email:</font> <a href=\"mailto:".$data->email."\"><font color=\"#008000\">".$data->email."</font></a>\n";
                        }

salsa_dancer

thats great! it works a treat.... thank you..