Search results only shows 23 records

All .php files were created by DataAssist. Using the search page (siteimages_search.php) for all records with a type 1 (quilt) only 23 records show. When I look at the actual MySQL table there are 37 records where type=1. Some records had a field with a NULL value in it, I changed those values to 0, nothing changed, still only 23 records. When I try the same search on my localhost it works fine, all the records show.

send a copy of the results page so i can look at the code please.

Also, I redid all the pages and still had the problem. Here is the results page.

to troubleshot, add the following code just after the body tag:

SQL: <?php echo($query_limit_WADAsiteimages): ?><br />

this will write the query being used to the screen.

Parse error: syntax error, unexpected ':', expecting ',' or ';' in \\nawinfs02\home\users\web\b341\rh.sgregg55\siteimages_Results.php on line 283

I tried taking the SQL: off, no change

sorry, it should be:

SQL: <?php echo($query_limit_WADAsiteimages); ?><br />

This is what you get when I look at the binding for the results page:
SELECT siID, siTitle, siYear, siStatus, siNewWork, siAddDate, siType, siGroup
FROM siteimages
ORDER BY siAddDate DESC

This is what your code produced, which explains everything.
SQL: SELECT siID, siTitle, siYear, siStatus, siType, siNewWork, siGroup, siAddDate FROM siteimages WHERE ((siType = 1)) AND ((siNewWork = 1)) ORDER BY siAddDate DESC LIMIT 0, 1000

I know what to do to fix it, thanks, that is a nifty debug.

glad to hear it helped find the problem.