DB oddity

Hi, I am using PEAR::DB, Smarty and MySQL and one one, fairly complex page have the following process: if the request came from my search page, build $sql1, query database, build temp table (my spec) loop through the results and insert the records into the temp table ($sql2, then with $sql3, return the first record. If the request is coming from a result page (displaying one of the records) go straight to $sql3 to get the requested record. All the navigation is working fine but I have a problem building the temp table. In my test database, I have six records that should be put into the temp table. They are identical apart from a couple of keys referencing different records in certain tables, just to give some variety in the results (but the details are all there). Anyway, the temp tabel is only getting four of the six records added. No errors are being generated and the site works, except for the 2 missing records. I'd post my code, but as I'm handling over 60 fields its quite long. Can anyone see anything that I am doing incorrectly in the process? If it helps, the missing records are in positions 3 and 5 of the original set. MTIA George in Oxford