PHP to output SQL field

SatuPortal_com

I have "stock" table that have 3 fields :

1 == sid == for stock-id
2 == desc == for stock description
3 == balance == for stock balance

I also have "status" table that have 4 fields:

1 == id == for status id
2 == sid == for stock id that want to monitor
3 == desc == for stock description
4 == stat == for status of the stock (good/bad status)

I want to give my php script the ability to show the description stock on "status" script when i choose the stock id (using select function) automatically before i click submit.

Can php script do this ?

tomhath

I don't understand what you mean by "show the description stock on "status" script when i choose the stock id (using select function) automatically before i click submit."

Php can be used to generate whatever HTML or Javascript you want. But once the page has been sent to the browser, php is done.

SatuPortal_com

What i mean is if i select stock id from drop down list (i use <select><option>123</option></select>) so the description will be automatically shows up.

If php can't do this, how to make this happen on php ?

Sorry with my bad english😉

BigMike

Originally posted by SatuPortal.com
What i mean is if i select stock id from drop down list (i use <select><option>123</option></select>) so the description will be automatically shows up.

If php can't do this, how to make this happen on php ?

Sorry with my bad english😉

PHP can do this, but you will need to have some client side script (like javascript) to react to the change in the drop down list.

For instance, with plain html, when you change the selection in a drop down list in a form, nothing happens. You need to trap the change with some javascript that then invokes a change in the displayed data with your php script.

Sorry I don't have any code, but hope it points you in the right direction.

Regards,

Mike

Rodders

I don't know if this will suit your needs, but I use this.....

With this your drop-down SELECT box shows the description, but it is the SID value that is sent by the form to your next PHP script.

If you want the user to select by SID and display the description separately you will need client-side code (Javascript).

SatuPortal_com

anybody can give me the example of client-side code (Javascript) for my problem ?