PHP isn't the only option, but it's probably the best choice on X10. Second is Perl. There's also ASP.Net, Python and Perl. ASP.Net and Python each has it's own difficulties here when it comes to MySQL, otherwise I'd recommend Python over Perl.
The W3Schools PHP+MySQL tutorial is terrible...