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

date posted 18th January 2008 16:01

> 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.

Sure does, bunch of f'ckers.

>Not sure about decoding the values, but if you only have a

Actually I want to encode the invoice ID to match the encoded value in the
invoice_items table so I can do a lookup on it.

> small
> number of invoices in the system have you thought about creating a
> lookup table?

Smallish number but growing and I have no way to modify the way the program
writes the data out so what im doing need to work without modifying any code
there already.

Were getting there with working out how it is done and think we should have
a working php function to do it. (See my other post) hopefully group brain
power can overcome this. (Mine certainly isn't large enough) :)