in reply to i could not abl to get proper result belowed mntioned code..

Hi senthil_v

Could you show us what you've tried so far ?
Did you have a look at the documentation of CGI and DBI ?
$> perldoc CGI $> perldoc DBI or $> perldoc DBD::mysql
These might help too for getting more effective help: On asking for help and How (Not) To Ask A Question

LuCa