[RESOLVED] Trapping a null record

dcjones

Hi all,

Having a problem with trapping a null record in a database. I have the following code

<?php do { ?>
<tr>
<td class="itembox"> <?php echo $row_membersdetails['name_f']; ?><a href="intelligence_members_profile_details.php?recordID=<?php echo $row_membersdetails['member_id']; ?>">&nbsp; </a> </td>
<td class="itembox"><a href="intelligence_members_profile_details.php?recordID=<?php echo $row_membersdetails['member_id']; ?>"><?php echo $row_membersdetails['name_l']; ?></a>&nbsp; </td>
<td class="itembox"><?php echo $row_membersdetails['country']; ?>&nbsp; </td>
<td class="itembox"><?php echo $row_membersdetails['occupation']; ?>&nbsp; </td>
</tr>
<?php } while ($row_membersdetails = mysql_fetch_assoc($membersdetails)); 
								   if (strlen ($row_membersdetails['occupation']) == 0)
echo "There is currently no registered menber with the expertise you have selected.";
?>

I think I have the "if (strlen ($row_membersdetails['occupation']) == 0)" in the wrong place,

can anyone help with this.

NogDog

<?php } while ($row_membersdetails = mysql_fetch_assoc($membersdetails));

I think you want a "{" instead of a ";" at the end of that line (and make sure you have a matching closing "}" later).

dcjones

Hi and thanks for your reply.

I have tried the reply with no luck. I played around but I keep getting errors.

I get

Parse error: parse error, unexpected '(', expecting ';'

any ideas.

dcjones

Hi all.

Resolved.

I used the following code. I tested for null data in the "occupation" feild and if it is empty display the error message, and it works fine.

<?php do { ?>
								    <tr>
                                    <td class="itembox">
									 <?php echo $row_membersdetails['name_f'];  ?><a href="intelligence_members_profile_details.php?recordID=<?php echo $row_membersdetails['member_id']; ?>">&nbsp; </a> </td>
                                    <td class="itembox"><a href="intelligence_members_profile_details.php?recordID=<?php echo $row_membersdetails['member_id']; ?>"><?php echo $row_membersdetails['name_l']; ?></a>&nbsp; </td>
                                    <td class="itembox"><?php echo $row_membersdetails['country']; ?>&nbsp; </td>
                                    <td class="itembox"><?php 
									if (strlen($row_membersdetails['occupation']) == 0) {
										echo "Expertise not found";
										} else {
									echo $row_membersdetails['occupation']; }?>&nbsp; </td>
                                  </tr>
                                  <?php } while ($row_membersdetails = mysql_fetch_assoc($membersdetails));

							  ?>

Thanks for your input, without it I would struggle.