Robincog
asked on
Help with a simple database lookup
Hi - I have a fairly simple database of two sets of numbers - group and ID. I need to make a webpage that the user would enter the group number and it would show the applicable IDs associated with the group. The database is currently in Excel, but it can be exported to anything. I don't know SQL so I am not sure if this is possible in just HTML. Thanks for the help. == Rob ==
ASKER
Like using an get command in XML?
Anyway - linux box server, Java2SDK only no servlets, standard stuff as well perl, C, PHP4 - all could be solutions if needed, but I was also wondering if there was a much more simple, though less elegant HTML solution?
== Rob ==
Anyway - linux box server, Java2SDK only no servlets, standard stuff as well perl, C, PHP4 - all could be solutions if needed, but I was also wondering if there was a much more simple, though less elegant HTML solution?
== Rob ==
If there is not too much data, you can use a flat text file to store your data.
Then use php to read the file and only return the data that has been asked.
XML will be much heavyer.
Then use php to read the file and only return the data that has been asked.
XML will be much heavyer.
ASKER
There is a minimum of 3,000 records (1,500 of each), and a max of 22,000 (11,000 of each) but the first column is only six digits and the second is eight. I could sub-divide the records into major groups 1-2, 3-4, 5-6, etc if that makes it into a managable size for the lookup.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AJAX can be a solution for you. But all depends on your approach