Database Woes.

[abudhu]

Hi:

So, google has failed me. So I turn to my fellow peers.

Scenario: I have a huge database with names, current year standing, big brother, little brother, major, minor, classes taken, classes enrolled in.

What I want: A random user to be able to search a name, a class, a ____, and have it return a finding in the format of a database table.

What I found: It exist. As located here:
http://www.linuxfromscratch.org/cgi-bin/newlfscounter.cgi

You can see, if you type in a name, or a ID number or a ____ it returns a find in a table-like manner. ID/Name/Version

What I need: What that website has. I can't find a script anywhere on the internet for free, or even for money that can do that.

Ultimate Goal: For the user to search a name/whatever and have it display in table format the findings.

Thanks for any help I get. This is driving me nuts now.

[fturtle]

something like this would be pretty simple to write in php. the trouble with downloading an existing script is matching whatever table structure is in their existing query (unless you just rewrite their query, in which case you could just script it yourself anyway).

so when you say you have a huge database, that means it's already in a table somewhere that you can query? on an SQL server or something?

[emurphy1]

I have a huge database with names, current year standing...
How big is the database? Depending on the table structure it is likely that you will want to add indexes to improve searching which leads to faster queries. If you are using Oracle, SQL-Server or MySQL 5.x the best index to use is a clustered-index which will reorder your table based on the columns you are indexing. You'll want to index the columns most likely to be used in a SELECT query.

[abudhu]

Its a MySQL Database. I also realize an easy way would be to do it in PHP, but the problem is I wouldn't know where to start. So if one of you could meet me and walk me through it would be awesome.

[abudhu]

I have the database completed. In the future I'll probably add 2 more rows, but that won't be any time soon. So if either of you want to stop by the MLL tomorrow from 10-11:30 or 2-5 I'd be very happy.

The way I am working right now is through PhpMyAdmin to edit and create the mySQL database.

[lmc]

Have you looked at SQLite? This was installed recently on the U system.
It allows five different output formats: "line", "column", "list", "html", and "insert".
Here's a reference: http://www.sqlite.org/sqlite.html
A UA researcher in Chemistry wrote this 15-page tutorial:
http://www.u.arizona.edu/~nikolai/IT/php_db/php_db.php
You create the database with a PHP script or with the sqlite executeable.
Lucy Carruthers CCIT Research Support lmc@u.arizona.edu