Frank king

I wanna create a gui interface to show my MySQL database, table by table.
I am a completely newbie with it, is there any fast way to create this kind of GUI?

anybody here have the "trigram match" source code?

I Have searhed it with google, but got nothing..

can you help me out? it is kinda ugent..


thx

A great thanks for your advice:

I just did a brief study on metaphone search.

however, I am not sure how this kind of search can help me with correcting typos..

like "risl" in metaphontic search is "RSL"

while "risk" is "PSK"

how can I match them together and suggest the user with "are you searching 'risk'?"

thanks

I am using Mysql as my database. thoe searching text alorithm also provided in this software?

I have a database build by MYSQL includes list of book names and price.

when key in a book name, system will return it selling price.

however, if user keyed in name wrongly, for exmaple. "risl management" instead of real name "risk management", my system won't know how to handle this type of problem.

another problem is : if user doesn't key in the full name of the book, how the system could know which book the user is looking fot?

can any predefined searching method in MYSQL help me or any search algorithm can solve this kinds of problems??

thanks, waiting for your help asap.
[ October 13, 2004: Message edited by: Bear Bibeault ]

I have a database includes list of book names and price.

when key in a book name, system will return its selling price.

however, if user keyed in name wrongly, for exmaple. "risl management" instead of real name "risk management", my system won't know how to handle this type of problem.

another problem is : if user doesn't key in the full name of the book, how the system could know which book the user is looking fot?

any search algorithm can solve this kinds of problems??

thanks, waiting for your help asap.

I have a database includes list of book names and price.

when key in a book name, system will return it selling price.

however, if user keyed in name wrongly, for exmaple. "risl management" instead of real name "risk management", my system won't know how to handle this type of problem.

another problem is : if user doesn't key in the full name of the book, how the system could know which book the user is looking fot?

any search algorithm can solve this kinds of problems??

thanks, waiting for your help asap.

then for search alorithm, what kind of search alorithm is appropriate?
I am not very familar with those search alorithm. can you suggest me one, then I can research on that topic.


thanks

dear folks here, I am student from singapore. currently I am doing a software design project. one of the crucial parts is to identify the post address that the user keyed in. a simple example, user keys in "city hall xx club" then my java program should be able to varify whether such a place exists.

in order to achieve that, I got to build a database covers certain part of singapore landscape with post address form. however, I am not very clear how to build a such kind of database to store large amount and correlated post address.

second, any efficient search alorithm to make the search pocess smooth and fast. problem like "what if user keyed in a wrong character, how can I figure out the correct or highly possible post address?"

thanks a lot

[edited to remove urgent from subject]
[ October 11, 2004: Message edited by: Jeanne Boyarsky ]

dear folks here, I am student from singapore. currently I am doing a software design project. one of the crucial parts is to identify the post address that the user keyed in. a simple example, user keys in "city hall xx club" then my java program should be able to varify wether such a place exists.

in order to achieve that, I got to build a database covers certain part of singapore with post address. however, I am not very clear how to build a such kind of database to store large amount and correlated post address.

second, any efficient search alorithm to make the search pocess smooth and fast. problem like "what if user keyed in a wrong character, how can I figure out the correct or highly possible post address?"

thanks a lot