Not sure what to do But Im Sure Simple

[gadgettdx]

Ok heres the dilema. In my database I work with recipes. I have up to 10 ingredients with my recipes. Sometimes 3 or 4 or 8 or 10. Now... When I dispaly them i want to have it so that once it gets to a null value it stops. and then goes all the way past that section down to the next... Ive thought of some lengthy LENGTHY LENGTHY ways to do that... But I know there has to be a simpler way..> I am a newbie... So anyhelp would be greatly appreciated. Thanks a billion in advance
Sincerely
John

[flipis]

Say you have the following:

$query = mysql_query($sql,$Conn);
$num_fields = mysql_num_fields($query);
$num_rows = mysql_num_rows($query);

for($i=0;$i<$num_rows;$i++){
for($n=0;$n<$num_fields;$n++){
$result=mysql_result($query,$i,$n);
if($result == '' || $result == NULL){
continue;
}else{
echo "Field $n Row $i -->".$result."<BR>";
}
}
}

fLIPIS