I have a small PHP program, written by another programmer, running on browser.

the original query is searching from stockname.
I asked him to change to search from stockid.
he said too difficult to do it, he suggested me to change the main query.

but in my case, an item can have many stockid for one stockname.
so I need to add a query to convert the stockid to stockname.

Jerry


>Why do you need PHP, if you can do it in VFP? And if you do, where are you planning to run PHP?
>
>>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