|
|
Posted by Chris on 01/01/08 04:40
Should I be using my-sql or php to design a non-relational database.
I looked at ezscripting.com but it doesn't give me the reporting
capabilities I need. Basically I need the user to be able to enter 5
fields into a database and then pull up a report. The report will be
predefined so the user won't need to enter any search parameters. The
report will be grouped by City and Sorted by 3 additional fields,
street name, street number, size. The output would be similiar to:
R&D (this is the main category)
Milpitas (the first city to be grouped on)
192 First Street 20,000 1.45 (the spaces are there
just to separate the data on the report)
32 Second Street 10,000 1.32
San Jose (second city that appears for the category)
2 First Street 5,000 1.10
etc.
The database can be a text file, access, dbase, I don't really care.
There won't be many entries so speed isn't an issue.
Thanks for the suggestions,
Chris
Navigation:
[Reply to this message]
|