>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

Here is some code from a running PHP app.
queryDB is a MYSQLPDO function

    $query = "SELECT storecode FROM store WHERE storecode=:storecode AND PW=:PW";
    $params = array("storecode"=>$user,"PW"=>$password);
     $stores = $db->queryDB($query,$params);