Spacing issue with results page in DA

Hi, I'm trying to remove the spacing between records on my results pages, please advise on how to control or remove the "white" space between records.

I've attached my search and results pages with the WA_DataAssist and WADbSearch files

Thanks

Erick

Do you have a link to where I can take a look at your hosted pages? It would help me understand what you're trying to do if I could see the pages live.

I've just uploaded the files and connected the database, the url is: index.php

Once you're there you'll see a drop down on upper right side of the website that say's "Select Your Search", pick "Search Categories" from the drop down, then click the "Search Categories" (the button on the right), at that point all of the files should be retrieved. If you notice the wide spacing in between each section, this is what I'm trying to control, I would like to reduce this space to to no more than a the space between standard paragraphs.

Thanks

the space is being added between them due to blank columns in your data base.

you will need to add an if statemetnt around the <tr> code to only display the row if there is a value in that column in the database.


For example, change:

<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">

            <td bgcolor="#FFFFFF" class="WADAResultsTableCell"><strong><?php echo $row_WADAnorthstar['line_name1']; ?></strong> <?php echo $row_WADAnorthstar['line_desc1']; ?> <?php echo $row_WADAnorthstar['class1']; ?></td>

          </tr>

to:

<?php if(($row_WADAnorthstar['line_name1'] != "" && $row_WADAnorthstar['line_name1'] != NULL) || ($row_WADAnorthstar['line_desc1'] != "" && $row_WADAnorthstar['line_desc1'] != NULL)) { ?>

<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">

            <td bgcolor="#FFFFFF" class="WADAResultsTableCell"><strong><?php echo $row_WADAnorthstar['line_name1']; ?></strong> <?php echo $row_WADAnorthstar['line_desc1']; ?> <?php echo $row_WADAnorthstar['class1']; ?></td>

          </tr>

<?php } ?>