regarding making connection to mysql from a C program on windows

hi all,

can any one please tell me "how to make a conncetion to mysql database
from a C program on windows " .
Please help me by giving possible code for making a
conncection,selecting data etc.

i.e. what library files i need to include,what are the functions needed
to be called?...

Thanking you
santhu