if statement help

[jrmontg]

I have this to display information on my page:

<table width="100%" border="0">
<?php do { ?>
<tr>
<td>
<a href="selectsub.php?%27SubCategoryKey=<?php echo $row_rsSystem['SubCategoryKey']; ?>"><?php echo $row_rsSystem['SubCategoryName']; ?></a>
</td>
</tr>
<?php } while ($row_rsSystem = mysql_fetch_assoc($rsSystem)); ?>
</table>

My problem is that ['SubCategoryName'] is sometimes NULL. Is it possible to redirect this to another page if it is null?

Thanks

[rachel2004]

Yes, it's possible. But before you try to perform the action with an "if" statement, consider whether you really need to see NULL values when you run your query.

You may be better off breaking this into two queries to avoid the overhead of having to do a conditional check on each value of SubCategoryName to see if it is NULL.

Of course, this is all dependent on how you want to lay everything out for your visitors.

[kimachi_com]

1. What sort of query and dataset is being returned here? It may be possible to use a statement that does not return null values if they are not needed, if they are however I would also ask:

2. When you say "possible to redirect this to another page" what more precisely do you mean by that?

3. Thanks

[jrmontg]

Nevermind, I changed up my database a little and it seemed to work itself out. Thanks for the responses