selecting values

[JoseSilva]

Hi

1. I have a sql table called BUYERS

2. In one menu called CLIENTES where I do insert into that table, clientes name. This is no problem.

3. In other menu called BUSINESS I need to start to insert (NOT UPDATING) the first business movement of one of clients already in the DB BUYERS, For that I need to appear in a field of the php file all the client names in order to select the one that i'm interestead, instead of writing the full name again.

I hope you do undersatand what I mean.

thanks

[ariell]

Hi Jose,

then run a SELECT query on CLIENTS (maybe as a DISTINCT query to retrieve unique values) and connect the result to a drop-down box in HTML. You open a SELECT and "as long as there are results from the query) add an OPTION with the client's name.

Hope I understood what your problem is (was).

Best from the south.