Have php/mysql experience & want to make a few $$$?

[Gigantopithecus]

.

 

[fs5]

if you want to do it yourself and are any bit tech savvy you could try to use phpmyadmin.
It is a basic web interface into any mysql database. Simply export your excel file to .csv and then import it w/ phpmyadmin. Then it gives you a nice query page to look up information int he tables.

http://www.phpmyadmin.net/home_page/index.php

demos available on that site also.

 

[esun]

Can I do it in Perl instead of PHP? If so, let me know. I like coding in Perl so it'd be more for fun than for pay (though a little compensation would be nice). Seems like an easy project, anyway.

 

[imported_quasi]

Yeah, sounds like a relatively easy project with PHP and MySQL. As for updating and expanding the databases, it wouldn't be too hard to create a form that will insert new data into the table (or you could just do it in phpmyadmin).

 

[esun]

You actually could just update the Excel file and run a script to extract the data again. Perl has some libraries for getting data from an Excel file, so assuming the format was relatively unchanged it should be pretty easy. (Presumably you wouldn't want to do the search queries directly on it, though, since that'd be slow.)

 

[LeetestUnleet]

I second the phpMyAdmin idea.

 

[imported_KuJaX]

The problem is that I don't think he wants to sit there within phpmyadmin (doesn't know any mysql query codes???)

I think, what he is asking, is that he wants a page where he can select the criteria visually (drop down boxes) and click "search" and it will bring the query to him. I may be wrong.

 

[oz838]

List the column titles/headers, and some sample data please, so that somebody can start on the project immediately.

 

[oz838]

please email me some sample data in the excel format so that I can get started right away.

Regards,
Oz838

ozchien@gmail.com