Jump to content

Checking mysql_num_rows result with if statement


DarkPrince2005

Recommended Posts

Can anyone tell me what \i'm doing wrong?

 

$responded = mysql_query("select * from case_response where case_id = '".$case['Case ID']."'");
				  $responded_result = mysql_fetch_array($responded,MYSQL_ASSOC);
				  
				  $pictures = mysql_query("select * from case_pictures where case_id = '".$case['Case ID']."'");
				  
				  
				  $pdf = mysql_query("select * from case_pdf where case_id = '".$case['Case ID']."'");
				  $pdf_result = mysql_fetch_array($pdf,MYSQL_ASSOC);
				  If(mysql_num_rows($pictures) = 0){
				  echo"
				  <tr>
					<td colspan='2'>".htmlentities($responded_result['case_response_comment'])."</td>
				  </tr>
				  <tr>
					<td><table cellpadding='0' cellspacing='0' border='0'><tr>";
					while($pictures_result = mysql_fetch_array($pictures,MYSQL_ASSOC)){
					echo "<td><img src='".htmlentities($pictures_result['path'])."' width='150' /></td>";

					}
					echo "</tr></table></td>
				  </tr>";
			      }

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.