Welcome to WebmasterWorld Guest from 54.159.250.110

Forum Moderators: open

Message Too Old, No Replies

Best way to search mysql db entries?

   
12:17 am on Dec 19, 2009 (gmt 0)

5+ Year Member



Greetings friends!

I have a MySQL DB containing contact information. Number, Address, Name, Initials.

I would like to ask for your suggestion in what would be the best approach to get search results from MySQL DB, which script would be the best to use.

Since i do not have programming knowledge to script my own application.

Looking forward to hearing your voices!

Regards
John! :)

9:28 pm on Dec 19, 2009 (gmt 0)

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member



PhpMyAdmin seems to be the one of choice.

Though it's extremely easy to code up a basic "database manager" script.

10:28 am on Dec 20, 2009 (gmt 0)

5+ Year Member



Hi again rocknbil, yes i do have a php script to search mysql db< but i was jus thinking are there very efficient scripts to get relevent and sorted data extraction from db.

i actualy has data on an excel sheet, and i imported them to mysql. i would like to search the mysql db in an efficient way. Or do you suggest any other method for searching entries in my excel file?

A better alternative to index a excel content?

8:48 am on Dec 22, 2009 (gmt 0)

5+ Year Member



sorted data extraction from db?

[tablesorter.com...]

data on an excel sheet, and i imported them to mysql?

[webmasterworld.com...]

you can upload data from excel to database by saving the file into CSV..