MySQL Query on the Fly

------_=_NextPart_001_01C793D0.9648FB05
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Good Morning,

=20

I've been searching and toying with this solution for some time but
can't find that right answer. Looking for solutions/suggestions to the
following:

=20

I created a program that will allow people to track sales and depending
on what they've sold, they will either get a set bonus, or a bonus based
on a percentage. I have no problem creating a drop down box for them to
select from, and I could probably create a select button that would do
the action, but I'd rather have it in one step. So what I'm trying to
do is somehow when they select from the drop down (via a JavaScript
onchange or something) I'd like it to pull data from the MySQL database.
I'd like it to pull the amount and then each or per based on the ID of
what they've selected from the drop down. If it was always based on
each sale or based on a percentage, that would be easy as I could code
that into the drop box, but I'd like to keep it based on the ID so that
it can pull out of the database the name, and then when changed pull the
info. Any ideas? Thanks in advance for the help. If you have any
questions or it seems like I left something out, please let me know.

=20

=20

Thank you for your time,

____________________________________________
Todd Dorschner


------_=_NextPart_001_01C793D0.9648FB05--

Re: MySQL Query on the Fly

You have to use an iframe to do what you want. Once the user select
something, you referesh the iframe and you pass specific parameters to it
based on the user's choice.

--
itoctopus - http://www.itoctopus.com
""Todd A. Dorschner"" wrote in message
news:D9FE3F12A157DC4D98C60D060F6ABAD79A6925@slcudc01.slcu.lo cal...
Good Morning,



I've been searching and toying with this solution for some time but
can't find that right answer. Looking for solutions/suggestions to the
following:



I created a program that will allow people to track sales and depending
on what they've sold, they will either get a set bonus, or a bonus based
on a percentage. I have no problem creating a drop down box for them to
select from, and I could probably create a select button that would do
the action, but I'd rather have it in one step. So what I'm trying to
do is somehow when they select from the drop down (via a JavaScript
onchange or something) I'd like it to pull data from the MySQL database.
I'd like it to pull the amount and then each or per based on the ID of
what they've selected from the drop down. If it was always based on
each sale or based on a percentage, that would be easy as I could code
that into the drop box, but I'd like to keep it based on the ID so that
it can pull out of the database the name, and then when changed pull the
info. Any ideas? Thanks in advance for the help. If you have any
questions or it seems like I left something out, please let me know.





Thank you for your time,

____________________________________________
Todd Dorschner

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: MySQL Query on the Fly

You can the entire thing in Java script with Style sheets. Depends on
what he wants to do. iframes could be far simpler. :)


itoctopus wrote:
> You have to use an iframe to do what you want. Once the user select
> something, you referesh the iframe and you pass specific parameters to it
> based on the user's choice.
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: MySQL Query on the Fly

That's one of the uses of Ajax.

http://www.xajaxproject.org/

http://wiki.xajaxproject.org/Tutorials:Learn_xajax_in_10_Min utes

You don't "have to use an iframe".

Regards,
Dwight

> -----Original Message-----
> From: Todd A. Dorschner [mailto:DorschnerT@shorelinecu.org]
> Sent: Friday, May 11, 2007 8:31 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] MySQL Query on the Fly
>
> Good Morning,
>
>
>
> I've been searching and toying with this solution for some time but
> can't find that right answer. Looking for solutions/suggestions to the
> following:
>
>
>
> I created a program that will allow people to track sales and depending
> on what they've sold, they will either get a set bonus, or a bonus based
> on a percentage. I have no problem creating a drop down box for them to
> select from, and I could probably create a select button that would do
> the action, but I'd rather have it in one step. So what I'm trying to
> do is somehow when they select from the drop down (via a JavaScript
> onchange or something) I'd like it to pull data from the MySQL database.
> I'd like it to pull the amount and then each or per based on the ID of
> what they've selected from the drop down. If it was always based on
> each sale or based on a percentage, that would be easy as I could code
> that into the drop box, but I'd like to keep it based on the ID so that
> it can pull out of the database the name, and then when changed pull the
> info. Any ideas? Thanks in advance for the help. If you have any
> questions or it seems like I left something out, please let me know.
>
>
>
>
>
> Thank you for your time,
>
> ____________________________________________
> Todd Dorschner

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php