empty product

Hello,

I"m using Data Assist to create a search and results page for my Product Database.

When I search by product Name, the correct product name and corresponding image display on the page for each product search result.
I have it set up to display 10 records at a time.

BUT
If record number 3 is empty, it displays an empty space on the page. Or if several records are not there, it also displays empty space. It make the page look bad.
(For example, looking at the ProductIDs in my database the count goes 1,2,3,7,9,10 Displaying these first set of records on the page results in two blank spaces.)

I will be adding and deleting products from my database from time to time.
When one of these products are deleted/removed from the database, why does it show as blank?

if the record is deleted from the database completely, it should not be causing the blank rows.

This would only happen if there are blank records in the database.

The rows displayed on the results page are driven by the records in the database, Double check in the database that there are no rows with blank data.

I checked the database.
The rows are removed completely.

see screen shot attached.

thanks
Danielle

send a copy of your results page and a link where i can see the problem.

Jason,
On the SEARCH page, I slected Category: Perennials A-Z and I click SEARCH button.
Search page link: plants_Search.php


The results page link:
plants_Results.php?S_ProductName=&S_ProductCartDesc=&S_ProductCategoryID=1&Search.x=24&Search.y=19&Search=Search

If you scroll to the bottom of the page you'll see the empty white spaces/boxes.


Attached is my results page php file.

Thanks,
Danielle

it's not that there are empty records, it is your layout causing the last row to not position correctly.


in the style.css file, change:
#outerWrapper #contentWrapper #content #SearchList dl{
clear: both;
float: left;
width: 230px;
margin: 10px 10px;
padding: 0;
display: inline; /* fixes IE/Win double margin bug */
}


to:
#outerWrapper #contentWrapper #content #SearchList dl{
/*clear: both;*/
/*float: left;*/
width: 230px;
margin: 10px 10px;
padding: 0;
/* display: inline; fixes IE/Win double margin bug */
}