Re: lookup funcion

On 30 Jun, 13:37, Leonardo Calado <leonardo.cal...@xxxxxxxxx> wrote:
I use a on-line version of spread*** "program" using PHP arrays to
simulate cells and MySQL database to store retrieve data. But I look
for also in PHP similar to Lookup().

Thanks for you help!

Lookup is effectively the equivalent of using an SQL query to find a
record of information using a key field.

I really wouldn't try to mimic the spread*** in php/mysql. It will
be much more efficient to look at what the aim of the spread*** is
and to re-write that properly as a php/mysql application.

Either way, your equivalent of LOOKUP is a basic SQL SELECT statement.

Somewhere just recently I came across a php class that operated as a
total "in memory" spread***, complete with formulas. I'll try to
find it for you later.
.

Quantcast