snoopyxp wrote:how can I compile php with mysql on windows,
what complier do I need ?
Don't take this the wrong way, snoopyxp, but if you have to ask this question, then I can't recommend that you try it. There's no practical reason for you to be using an alpha release of MySQL, and doing so will, at least at this point in your learning, offer you no advantage.
In other words, go download the latest production
release of MySQL (currently 4.0.14), install it, and forget about alpha versions or recompiling.
If you're really convinced that you have a logical reason to do otherwise, I'm compelled to direct you to the all-knowing oracle