|
|
Posted by Jerry Stuckle on 12/20/06 03:09
larry@portcommodore.com wrote:
> Ok I am re-coding our apps in PHP and am looking for ways to make parts
> easily updateable, One of the challenges in my field (non-rpofit) are
> various lookup tables (for incomes etc).
>
> An example table would be something like a rate lookup, where you
> travel down the family size column and when you reach the right income
> you look for the rate. An example here:
>
> RATE - FAM2 -FAM3 - FAM4 - FAM5
> 100 - 1200 - 1300 - 1375 - 1380
> 123 - 1220 - 1320 - 1387 - 1392
> 143 - 1242 - 1342 - 1400 - 1412
>
> So if it were a family of 3 with 1322 the rate would be 123.
>
> To make this into a DB for lookup is a cinch, but for someone to
> enter/update this compact table into a lookup DB is a pain.
>
> Is there any libraries out there already to read a text file like the
> above (more likely CSV) or a similarly formatted spreadsheet, or one
> that presents a table entry method to expidite the entry of a table
> like this?
>
> Larry
>
Larry,
Check out fgetcsv(). It does wonders with csv files.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|