Page 1 of 1
How do i check if sql field is empty.
Posted: Tue Mar 21, 2006 9:43 pm
by anticore
Code: Select all
while ($row = mysql_fetch_array ($r))
{
print "<center>{$row['name']}<br><br>";
print "<IMG SRC=\"{$row['image1']}\"></center><br>";
print "<br>";
print "Year: {$row['year']}";
print "<br><br>";
print "{$row['details']}";
print "<br><center><br>";
print "<IMG SRC=\"{$row['image2']}\"><br>";
print "<IMG SRC=\"{$row['image3']}\"><br>";
print "<IMG SRC=\"{$row['image4']}\"><br>";
print " </center>";
}
I want this while script only to print image4 if it finds one. can i embed an if statement within the loop?
Posted: Tue Mar 21, 2006 10:45 pm
by feyd
yes, you can have an if statement inside a loop.
Posted: Wed Mar 22, 2006 4:28 pm
by anticore
Code: Select all
while ($row = mysql_fetch_array ($r))
{
print "<center>{$row['name']}<br><br>";
print "<IMG SRC=\"{$row['image1']}\"></center><br>";
print "<br>";
print "Year: {$row['year']}";
print "<br><br>";
print "{$row['details']}";
print "<br><center><br>";
print "<IMG SRC=\"{$row['image2']}\"><br>";
print "<IMG SRC=\"{$row['image3']}\"><br>";
if ({$row['image4']}==0)
{
print " </center>";
}else {
print "<IMG SRC=\"{$row['image4']}\"><br>";
print " </center>";
}
}
would this work?
Posted: Wed Mar 22, 2006 4:34 pm
by feyd
Have you tried it?
Posted: Wed Mar 22, 2006 4:47 pm
by anticore
yea that one didnt work to well
but this one does the job
Code: Select all
if ($row['image4']=="")
{
print " </center>";
}else {
print "<IMG SRC=\"{$row['image4']}\"><br>";
print " </center>";
}
}