Everything worked great but now random records are being produced with fields in the wrong place. Example:

ID: Color: Title: Size:
1 blue hats 10
2 red hats 10
red 3 10 hats
4 green hats 10
5 yellow hats 10
blue 6 12 hats

It's shifting the fields on some results but then other results are ok. I checked and there is no | anywhere in there to mix it up so I'm lost. It's happening on random records in the database. Any help is appreciated!

Hey there,

This is not an uncommon problem. Tracing the little bugger of a problem can be annoying though.

When this happens it is most likely a typo believe it or not.

1. Make sure in the .cfg file all the numbers are incremented properly (sounds stupid I knw, but it happens) 1 2 3 4 5 5, etc. That double of 5 can be a problem.

2. Go into your html.pl file. Make sure that the sub html_record_form and sub html_record match up. This is where you will most likely find the problem. however it is sometimes EASY to miss. (Been there) Check for typos in the names of the fields.

Hope this helps a bit.

-Norm