Re: FN-FORUM: Anyone up for a little number puzzle?

date posted 18th January 2008 15:46

Hi Sam,

Sam M - www.wiredeyes.com wrote:
> The tables are linked together using the invoice id field but the original programmer has encoded the invoice id from the invoice table and saved the encoded version in the invoice items table. The whole php application has been zend encoded so I can't check the code for the answer.
>

So the programmer has encoded the invoice_id in the items table such
that you can't actually join it to the invoice using SQL? Sounds pretty
broken. Not sure about decoding the values, but if you only have a small
number of invoices in the system have you thought about creating a
lookup table?

cheers,
Richard