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>";  
                                  } 
         }