[Resolved] if else condition

[MiriamHaden]

Hi im trying modify the following code below to achive following conditional results:
any help appreciated.

what I want is that :-

when $x_showlogo == 1 then show $x_Logo1
else if $x_showlogo == 2 then show $x_Logo2
else show $x_image1

//database field showlogo...when this is 1 show logo1 ,when 2 show log2
<?php
if (($x_showlogo != NULL) && ($x_showlogo <> "")) {
$sSqlWrk = "SELECT * FROM image";
$sTmp = $x_showlogo;
$sTmp = addslashes($sTmp);
$sSqlWrk .= " WHERE (id = " . $sTmp . ")";
$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
$sTmp = $rowwrk["showlogo"];
}
@phpmkr_free_result($rswrk);
} else {
$sTmp = "";
}
$ox_showlogo = $x_showlogo; // Backup Original Value
$x_showlogo = $sTmp;
?>
<?php echo $x_showlogo; ?>
<?php $x_showlogo = $ox_showlogo; // Restore Original Value ?>

//and:-

<?php
if (($x_Logo1 != NULL) && ($x_Logo1 <> "")) {
$sSqlWrk = "SELECT * FROM image";
$sTmp = $x_Logo1;
$sTmp = addslashes($sTmp);
$sSqlWrk .= " WHERE (id = " . $sTmp . ")";
$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
$sTmp = $rowwrk["Logo"];
}
@phpmkr_free_result($rswrk);
} else {
$sTmp = "";
}
$ox_Logo1 = $x_Logo1; // Backup Original Value
$x_Logo1 = $sTmp;
?>
<?php $sTmp = $x_Logo1; ?>
<?php if (($sTmp != NULL) && $sTmp <> "") { ?>
<img src="../Client/images/<?php echo $sTmp; ?>" width="330" height="76" border="0">
<?php } else { ?>
<?php echo $x_Logo1; ?><?php } ?>
<?php $x_Logo1 = $ox_Logo1; // Restore Original Value ?>

//as well as:-

<?php
if (($x_Logo2 != NULL) && ($x_Logo2 <> "")) {
$sSqlWrk = "SELECT * FROM image";
$sTmp = $x_Logo2;
$sTmp = addslashes($sTmp);
$sSqlWrk .= " WHERE (id = " . $sTmp . ")";
$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
$sTmp = $rowwrk["Logo2"];
}
@phpmkr_free_result($rswrk);
} else {
$sTmp = "";
}
$ox_Logo2 = $x_Logo2; // Backup Original Value
$x_Logo2 = $sTmp;
?>

<img src="../Client/images/<?php echo $x_Logo2; ?>" width="130" height="130" border="0">
<?php $x_Logo2 = $ox_Logo2; // Restore Original Value ?>

thanks in advance

[bodzan]

...place the code between [ php ] [ /php ] tags, please? Except the extra spaces...

[MiriamHaden]

heres code this is after variables set up in top of page and other fields callled at bottom before close php hope this what you asked for

<?php
if (($x_showlogo != NULL) && ($x_showlogo <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_showlogo;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["showlogo"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_showlogo = $x_showlogo; // Backup Original Value
$x_showlogo = $sTmp;
?>
                                            <?php echo $x_showlogo; ?>
                                            <?php $x_showlogo = $ox_showlogo; // Restore Original Value ?>
                                          </td>
                                          <td bgcolor="#CCCCCC">&nbsp;</td>
                                          <td bgcolor="#CCCCCC">&nbsp;</td>
                                        </tr>
                                        <tr>
                                          <td colspan="2" bgcolor="#C0C0C0"> Logo 1 
                                                <?php
if (($x_Logo1 != NULL) && ($x_Logo1 <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_Logo1;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["Logo"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_Logo1 = $x_Logo1; // Backup Original Value
$x_Logo1 = $sTmp;
?>
                                                <?php $sTmp = $x_Logo1; ?>
                                                <?php if (($sTmp != NULL) && $sTmp <> "") { ?>
                                                <img src="/images/<?php echo $sTmp; ?>" width="280" height="76" border="0"><br>
                                                <?php } else { ?>
                                                <?php echo $x_Logo1; ?>
                                                <?php } ?>
                                                <?php $x_Logo1 = $ox_Logo1; // Restore Original Value ?>
                                          </td>
                                          <td bgcolor="#CCCCCC">
                                            <?php
if (($x_Logo2 != NULL) && ($x_Logo2 <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_Logo2;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["Logo2"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_Logo2 = $x_Logo2; // Backup Original Value
$x_Logo2 = $sTmp;
?>
                                            <img src="/images/<?php echo $x_Logo2; ?>" width="130" height="130" border="0">
                                            <?php $x_Logo2 = $ox_Logo2; // Restore Original Value ?>
 </td>
                                          <td bgcolor="#CCCCCC">Image Sys
                                                <?php
if (($x_ImageSys != NULL) && ($x_ImageSys <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_ImageSys;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["Ad-Meny"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_ImageSys = $x_ImageSys; // Backup Original Value
$x_ImageSys = $sTmp;
?>
                                                <img src="/images/<?php echo $x_Image2; ?>" width="110" height="110" border="0">
                                                <?php $x_ImageSys = $ox_ImageSys; // Restore Original Value ?>
                                          </td>
                                        </tr>
                                        <tr>
                                          <td bgcolor="#C0C0C0">&nbsp;</td>
                                          <td bgcolor="#CCCCCC"> </td>
                                          <td bgcolor="#CCCCCC">&nbsp;</td>
                                          <td bgcolor="#CCCCCC"><?php
if (($x_Image2 != NULL) && ($x_Image2 <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_Image2;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["image2"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_Image2 = $x_Image2; // Backup Original Value
$x_Image2 = $sTmp;
?>
<img src="/images/<?php echo $x_Image2; ?>" width="110" height="110" border="0">
<?php $x_Image2 = $ox_Image2; // Restore Original Value ?>

[bodzan]

...read here what I meant...

Scroll down to the end of the page and you'll see the [ php ] [ /php ] tags explanation...

It is BB codes to help highlight the code...

It is very hard to see anything in other people's code when it is not highlighted...

Please, be kind and do as asked so I could try to help you... Thanx...

[MiriamHaden]

Please xcuse me I mis-understood,,hope you you can see code now,here original post
what I want is that :-
when $x_showlogo == 1 then show $x_Logo1
else if $x_showlogo == 2 then show $x_Logo2
else show $x_image1
//database field showlogo...when this is 1 show logo1 ,when 2 show log2

<?php
if (($x_showlogo != NULL) && ($x_showlogo <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_showlogo;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["showlogo"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_showlogo = $x_showlogo; // Backup Original Value
$x_showlogo = $sTmp;
?>
        <?php echo $x_showlogo; ?>
        <?php $x_showlogo = $ox_showlogo; // Restore Original Value ?>

//and:-

<?php
if (($x_Logo1 != NULL) && ($x_Logo1 <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_Logo1;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["Logo"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_Logo1 = $x_Logo1; // Backup Original Value
$x_Logo1 = $sTmp;
?>
<?php $sTmp = $x_Logo1; ?>
<?php if (($sTmp != NULL) && $sTmp <> "") { ?>
<img src="../Client/images/<?php echo $sTmp; ?>" width="330" height="76" border="0">
<?php } else { ?>
<?php echo $x_Logo1; ?><?php } ?>
<?php $x_Logo1 = $ox_Logo1; // Restore Original Value ?>

//as well as:-

<?php
if (($x_Logo2 != NULL) && ($x_Logo2 <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_Logo2;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["Logo2"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_Logo2 = $x_Logo2; // Backup Original Value
$x_Logo2 = $sTmp;
?>
<img src="../Client/images/<?php echo $x_Logo2; ?>" width="130" height="130" border="0">
<?php $x_Logo2 = $ox_Logo2; // Restore Original Value ?>

all help apreciated thanks in advance.

[bodzan]

...loose the redundant escape tags in places like:

?>
        <?php echo $x_showlogo; ?>
        <?php $x_showlogo = $ox_showlogo; // Restore Original Value ?>

Should be:

//no closing escape tag
echo $x_showlogo;
$x_showlogo = $ox_showlogo; //Restore Original Value 
?>

Then, if I understood you correctly do something like:

echo $x_showlogo;
if($_showlogo==1){
//do what you want i.e. show $x_Logo1
}
else if($_showlogo==2){
//show $x_Logo2
}
else{
//show $x_image1
}
$x_showlogo = $ox_showlogo; //Restore Original Value 
?>

Apply same logic wherever you need it...

This is really the basic PHP so I'm confused what is the problem? If you want me to do all the work for you and hardcode it then you're mistaken... This place is called PHP Help and not PHP Scripts On Demand forum...

I'm sorry if I appear too harsh but the best way to learn is by doing all the hard work yourself. I helped you to figure out what the logic would look like now you fill in a blanks...

I hope I helped you in some way... Good luck with the rest...

[MiriamHaden]

Please excuse me Bodzan ,I didn't mean to offend,especially since you have been kind enough to help in the past .I'm a newbie and theres has been similar queries such as mine but not quite the same complexity.Thanks very much so far for the help youve given it has been extremly helpful. However I'm still having problems with the code mainly because as each field converts its veriables to a temp field $sTmp and after removing escape tag to make one statement I think the logic is confused.
I put the show logo routine at the end and the logo1/2 at the top
thinging that thier returns will be available in the if else for show logo but it still doesnt work .

 <?php
if (($x_Logo2 != NULL) && ($x_Logo2 <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_Logo2;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["Logo2"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_Logo2 = $x_Logo2; // Backup Original Value
$x_Logo2 = $sTmp;
?>
             <img src="../images/<?php echo $x_Logo2; ?>" width="200" height="200" border="0">
                                            <?php $x_Logo2 = $ox_Logo2; // Restore Original Value 

if (($x_showlogo != NULL) && ($x_showlogo <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_showlogo;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["showlogo"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_showlogo = $x_showlogo; // Backup Original Value
$x_showlogo = $sTmp;

 echo $x_showlogo; 
if($sTmp == 1){ 
echo TEST LOGO1 HERE; 
} 
else if($sTmp == 2){ 
echo "<img src=\"../images/$x_Logo2; \"border=\"0\"width=\"200\"height=\"200\"align=\"top\"alt=\"Details\">  ";  //This RETURN here is what I want 

} 
else{ 
echo WHATEVER IMAGE HERE;
} 
$x_showlogo = $ox_showlogo; //Restore Original Value 
?>

Thanks again in advance and hope I haven't offended anybody
Miriam

[bodzan]

No appologies needed MiriamHaden just trying to make a point there...

So what is exactly the problem with this script of yours?

Rewrite this line to this:

echo "<img src=\"../images/$x_Logo2\"border=\"0\"width=\"200\"height=\"200\"align=\"top\"alt=\"Details\">";

Also what do you mean it is not working? Does it give any errors? If it is please post them...

Also if I see correctly you do a thing where first you add a value to a certain variable then return that value to it. Like:

$sTmp = $x_Logo2; 
.
.
.
$x_Logo2 = $sTmp;

Why do you do that? What are you trying to accomplish?

[MiriamHaden]

well I tried your solution but it doesnt return the image just a black space.....I have the same image earlier in the code just to see what I'm supposed to return..

<?php
if (($x_Logo2 != NULL) && ($x_Logo2 <> "")) {
	$sSqlWrk = "SELECT *  FROM `image`";
	$sTmp = $x_Logo2;
	$sTmp = addslashes($sTmp);
	$sSqlWrk .= " WHERE (`id` = " . $sTmp . ")";
	$rswrk = phpmkr_query($sSqlWrk,$conn) or die("Failed to execute query" . phpmkr_error() . ' SQL:' . $sSqlWrk);
	if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) {
		$sTmp = $rowwrk["Logo2"];
	}
	@phpmkr_free_result($rswrk);
} else {
	$sTmp = "";
}
$ox_Logo2 = $x_Logo2; // Backup Original Value
$x_Logo2 = $sTmp;
?>
             <img src="../member/images/<?php echo $x_Logo2; ?>" width="130" height="130" border="0">
                                            <?php $x_Logo2 = $ox_Logo2; // Restore Original Value 

so <img src="../member/images/<?php echo $x_Logo2; ?>" width="130" height="130" border="0">
displays fine
but
putting into your solution:-
else if($sTmp == 2){

echo "<img src=\"../member/images/$x_Logo2\"border=\"0\"width=\"200\"height=\"200\"align=\"top\"alt=\"Details\">";
blank space.

the assignment you ask what i was doing for is probably redundat tags i havent cleaned properly up ....been editing down from already generated code.
thx again

[bodzan]

echo "<img src=\"../member/images/".$x_Logo2."\"border=\"0\"width=\"200\"height=\"200\"align=\"top\"alt=\"Details\">";

It might make a difference...

[MiriamHaden]

No that didn't work either its still blank...not return $x_Logo2
:-(

[bodzan]

$x_Logo2 = $ox_Logo2;

I figure this: for the showing the first image it shows properly so so far all is well, right? But then comes this line that clearly does something to the $x_Logo2 and makes it not shows an image you need so I'm guessing that is the line where lies the problem... Do the echo of $x_Logo2 just beneath it and check it out...

Also check Output source i.e. in browser where it shows a blank page go and see the View Page Source option and it might get you an idea wht goes wrong...

[MiriamHaden]

Ok Bodzan I removed the line $x_Logo2 = $ox_Logo2 and it works like a dream...thanks again with your patients and help:-)

[bodzan]

...just don't forget to mark thread resolved through the link on the bottom of the page that says Mark thread resolved...