HI
i am beginner. someone built a website for me. it is written in php mySQL. the categories are retrieved and generated by the database. i would like to rewrite url for seo optimization. in my site there are 4 categories with url:

www.mysite.com/products.php?cid=1
www.mysite.com/products.php?cid=2
www.mysite.com/products.php?cid=3
www.mysite.com/products.php?cid=4

i would like to make it show up like this:
www.mysite.com/apple
www.mysite.com/banana
www.mysite.com/pear
www.mysite.com/orange

how can i do this, in a more simple way. is that simply changing .htaccess file, or is that related to rewrite mapping function. pls can you give me hint and exact example would be great. thanks