I'm using VFP9 with MySQL database, I want to write a simple PHP to retrieve the data.

What is the PHP code for this:

user inputs 'stockid', and gets the return value 'stock name'
input => stockid
query => select stockname from stockdata where stockcode=stockid
output => stockname

thanks for the help

Jerry