Read database on drop down change 1

[petermeachem]

The page I'm working on has a grid with a column of drop downs, a description column and a fee column. What I need to do is to populate the description and fee when the dropdown changes. Do I have to retrieve the whole page again to get it to refresh? and where do I find an event for the dropdown.
Sorry if this appears a bit simple and obvious to you, it doesn't to me.

http://www.therockalltimes.co.uk/

http://english2american.com/

And particularly

http://www.therockalltimes.co.uk/2003/03/10/war-warning.html

 

[rhowes]

Hi

What you are referring to is called Remote Scripting or RPC (Remote Procedure Call). Here is a good link:

http://developer.apple.com/internet/javascript/iframe.html

Hope this helps.
Cheers,

Richard

 

[petermeachem]

Blimey. I shall need to read that more than once.

Thanks for the quick response.

http://www.therockalltimes.co.uk/

http://english2american.com/

And particularly

http://www.therockalltimes.co.uk/2003/03/10/war-warning.html

 

[rhowes]

HI,

You're welcome, we aim to please here in sunny South Africa!

There is also a great library to do this here:

http://www.ashleyit.com/rs/main.htm

Regards
Richard
(Johannesburg, Aouth Africa)

 

[petermeachem]

So do we in sunny England, possibly just a bit colder than SA. I think I can do what I want with javascript. Use php to create the javascript stuff and use that to fill in the description and price.
All those other countries still playing cricket are they?

http://www.therockalltimes.co.uk/

http://english2american.com/

And particularly

http://www.therockalltimes.co.uk/2003/03/10/war-warning.html

 

[rhowes]

Yip, they're playing... what was that game again - OH yes, cricket? At least England had the excuse of almost making it despite giving away 4 points - we just threw ours away.

As for doing it in Javascript with PHP providing the data - yes you can. The down side is you either have to send all the data to the client initially (OK of it's not much), or refresh the page to reload the data.

The advantage of remote scripting is you can get data from the server based on user selection or interaction *without* reloading the page. More importantly its a new, rare technology that makes you look super cool and places your site/app in a very exclusive club ;-)

Some day all sites and web-based apps will be built that way.

Cheers
Richard

 

[petermeachem]

Ok, well in that case I'll do both. Javascript first off and clever stuff next. Possibly loading all the data might be a bit slow. I've always wanted to look super cool. This must be my big chance.

Thanks for your help.

http://www.therockalltimes.co.uk/

http://english2american.com/

And particularly

http://www.therockalltimes.co.uk/2003/03/10/war-warning.html

 

[ThomasJSmart]

also as it is a new technology it can be a bit buggy, some browsers can get a bit itchy about it too I learned a bit yesterday, today i learned a lot, imagine what i'll learn tomorrow!