If---Else Statement

[La_Parka]

		  <TD>

	  ".$this = "[b]".$field['numberreceived']."[/b]";
	  $that = ""; 
	  if ($this == $that){ print ("sent"); } 
	  else { print ("of [color=red]$this[/color]"); }"

	  </TD>


	  <TD>".$field['status']."</TD>

I'm trying to make a HTML table based on fields from a MySQL database, and I want the variable in bold to be interpreted by the processor but not displayed on the page/browser...e.g. I want the variable to be processed but I don't want it displayed until the red area.

Also the if---else statement seems to prevent the next table cell (the one with the status field) from being displayed in the web browser. How can I fix that?

Any help is appreciated, thanx

[klansman]

are you not using too many quotes??

your first <TD> is already quoted (i guess...). Then you try to concatenate the $this variable while, at the same time, calculating it's value. From my experience, that does not work!

".$this = "".$field['numberreceived']."";

honestly i don't understand the above code...

First of all, you should calculate the $this value, and only then concatenate it to whatever you are trying to print.
The double-quote before the '.$this' is a mistery for me. as i said before, i think what you are doing is filling a string (where the <TD> is included) in an echo function??

can you please show a little bit more of the code (before and after)??

[]

[La_Parka]

##############################
$query = "SELECT * FROM mytable ORDER BY name";
$result = mysql_query($query) or die ("Query failed!");
//let's get the number of rows in our result so we can use it in a for loop
$numofrows = mysql_num_rows($result);
$pageid = mysql_num_rows($id);
?> 

<?PHP
echo "<TABLE BORDER=\"0\" CELLPADDING=\"0\" CELLSPACING=\"0\">\n";
echo "<TR bgcolor=\"336622\">
		  <TD width=155><b><font color=white>Name</b></font></TD>
		  <TD width=150><b><font color=white>Claim To Fame</b></font></TD>
		  <TD width=150><b><font color=white>Greatest Acommplishment</b></font></TD>
		  <TD width=150><b><font color=white>Favorite Color</b></font></TD>
		  <TD width=150><b><font color=white>Sent/Received</b></font></TD>
		  <TD width=150><b><font color=white>Status</b></font></TD>
		  	</TR>\n";
for($i = 0; $i < $numofrows; $i++) {
    $field = mysql_fetch_array($result); //get a row from our result set
    if($i % 2) { //this means if there is a remainder
        echo "<TR bgcolor=\"#F7F7F7\">\n";
    } else { //if there isn't a remainder we will do the else
        echo "<TR bgcolor=\"white\">\n";
    }
    echo "<TD><a href=/index.php?id=".$field['id'].">".$field['name']."</a></TD>
		  <TD>".$field['claim']."</TD>
		  <TD>".$field['accomplishment']."</TD>
		  <TD>".$field['color']."</TD>


	  <TD>

	  ".$field['quantity1']."
	  ".$this = "".$field['quantity2']."";
	  $that = ""; 
	  if ($this == $that){ print ("sent"); } 
	  else { print ("of $this"); }"

	  </TD>


	  <TD>".$field['status']."</TD>
	  \n";
echo "</TR>\n";
}
//now let's close the table and be done with it!!! 
echo "</TABLE>\n";

[wilsonodk]

:eek:
You shouldn't use $this as a user defined variable,
It is a reserved word used for the OOP aspects of PHP.

Most languages i work with don't allow it to be used to avoid confusion 🙂

Also, you can't have that if...else statment inside of the echo statment.
Try and put all those multiple echo lines in seperate echo statements.
More typing, but easier to follow when you are having a problem.
Like right now. 🙂

[klansman]

yes, wilsonodk is right.

these lines:

_<TD>
".$field['quantity1']."
".$this="".$field['quantity2']."";
$that="";
if($this==$that){print("sent");}
else{print("of $this");}"
</TD>

are not allowed by the php language. you are putting an if clause within a string...

one way to do it could be:

<td>".$field['quantity1']";
if($field['quantity2']=="")
echo "sent";
else
echo "of ".$field['quantity2'];
echo "</td>";

again i warn you: do not use $this. use someting else, or do not use it at all...

good luck.

[La_Parka]

Originally posted by klansman
one way to do it could be:

<td>".$field['quantity1']";
if($field['quantity2']=="")
echo "sent";
else
echo "of ".$field['quantity2'];
echo "</td>";

[/B]

I keep getting parse error, expecting ','' or';'' at:

echo "sent";

. 🙁

[klansman]

sorry, my mistake.

the parse error lies in the first line.

wrong form is:

<td>".$field['quantity1']";

correct form should be:

<td>".$field['quantity1'];

really, really sorry!

[]