Problem with Not displaying HTML if data not found
| From: | markbm | Date: | Tue, 23 Jul 2002 03:58:31 +0000 |
| Subject: | Problem with Not displaying HTML if data not found | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20721@lists.php.net to get a copy of this message | ||
I am trying to develop a page that, in certain places, I only want it to
display the <TR> and <TD>s if data is found for a given field. For example,
if I only have an image for the first floorplan of a house, I do NOT have
an image for the second floorplan of a house, then show the first floorplan
image only.....skip over that next row because the field in the db is empty.
The problem that I'm having is that the syntax that I've been using to
define "empty" in the db field does not always work. The code reads:
if ($result[FLRPLAN_2]<>" ") {
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF>");
printf ("<font size=5> <b>Second Floor Plan:<b>
</td></font>") ;
printf ("</tr>") ;
printf ("<tr>");
printf ("<td colspan=3 >") ;
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'FLRPLAN_2')."'>'";
printf (" </td>") ;
printf ("</tr> ");
};
if ($result[FLRPLAN_3]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Third Floor Plan:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'FLRPLAN_3')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
I have tried:
1. if ($result[FLRPLAN_3]<>" ") {;
2. if ($result[FLRPLAN_3]<>"") {;
3. if ($result[FLRPLAN_3]<>'') {;
4. if ($result[FLRPLAN_3]<>' ') {;
5. if ($result[FLRPLAN_3]<>NULL) {;
and none seem to work correctly (i.e. blank field in db, but HTML row shows
up with missing image......or image is in db, but no HTML row shows up. If
it helps, each of the "image" fields are varchar(125)....basically I just
have the name of the image file, and then a pointer to the web server
directory structure....
Any ideas would be greatly appreciated. Thanks.
Mark