Originally Posted by Chuck S
that would all depend on what your trying to do.
It would depend on what your postcodes lengths are
The zipcode field is varchar 5 you might need to change it but it all depends on your specific error.
I see, well, they are maximum of 4 in length, but some people will have AL1 and others may have AL12 so a maximum of 4 and a minimum of 3 in length. So One assumes that varchar 4 will do the trick then.
By the way Chuck, the error is only occuring when I search from the postcode box on: search.php.
This is the error I receive:
"We're sorry, but the system experienced an unrecoverable error. Please try again later.
(AL1,AL10,AL2,AL3,AL4,AL5,AL6,AL7,AL8,AL9,BN27,BN6,BN7,BN8,BR1,BR2,BR3,BR4,BR5,BR6,BR7,BR8,CB1,CB10,CB11 etc.... etc....
AND approved=1 ORDER BY zipcode
Result: Unknown column 'AL1' in 'where clause'
Database handle: Resource id #21