RE: [PHP-DB] Best way to pass multiple selections to a DB

2003-06-17 Thread Creative Solutions New Media
Thanks Richard and Edward,

The naming of the list box as an array works great for passing the data
around. Thanks.

As for exactly what I need to do with the data I'm not exactly sure myself.
PHP and mySQL is a bit new to me.

I may be back for more help but for now thanks for the unbelievably quick
and helpful replies

Have a DAY

Respectfully,

Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
W: 902 450 5500
C:  902 430 8498

-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: June 17, 2003 3:57 PM
To: '[EMAIL PROTECTED]'; PHP-DB
Subject: RE: [PHP-DB] Best way to pass multiple selections to a DB

Tim,

You need to name your multiple select box as an array (e.g. selectThis[]).
The values will be passed as an array to the next page. You then need to
iterate over that array and pass the values into the database.

There's plenty of info on how to pull this off in the archives on PHP.NET
just search for select box or multiple select or the like and you should get
plenty of hits with code and summaries and the whole smash.

Rich

> -Original Message-
> From: Creative Solutions New Media [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 2:53 PM
> To: PHP-DB
> Subject: [PHP-DB] Best way to pass multiple selections to a DB
>
>
> Hello,
>
> Can anyone enlighten me as to some techniques for
> transferring information
> from a multiple select list box to mySQL.
>
> Someone recommended something about using join tables for
> this (which I have
> no idea how to set up).
>
> Thanks
>
> Tim Winters
> Manager, Creative Development
> Sampling Technologies Incorporated (STI)
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> W: 902 450 5500
> C:  902 430 8498
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

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



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



Re: [PHP-DB] Best way to pass multiple selections to a DB

2003-06-17 Thread Becoming Digital
> Can anyone enlighten me as to some techniques for transferring information
> from a multiple select list box to mySQL.

Not knowing how you need to insert the values (multiple entries, values in
multiple fields), I would generate an array of the selections and loop through,
either running individual queries or building your multi-value query string.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: "Creative Solutions New Media" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 2003 14:52
Subject: [PHP-DB] Best way to pass multiple selections to a DB


Hello,

Can anyone enlighten me as to some techniques for transferring information
from a multiple select list box to mySQL.

Someone recommended something about using join tables for this (which I have
no idea how to set up).

Thanks

Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
W: 902 450 5500
C:  902 430 8498




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





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



RE: [PHP-DB] Best way to pass multiple selections to a DB

2003-06-17 Thread Hutchins, Richard
Tim,

You need to name your multiple select box as an array (e.g. selectThis[]).
The values will be passed as an array to the next page. You then need to
iterate over that array and pass the values into the database.

There's plenty of info on how to pull this off in the archives on PHP.NET
just search for select box or multiple select or the like and you should get
plenty of hits with code and summaries and the whole smash.

Rich

> -Original Message-
> From: Creative Solutions New Media [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 2:53 PM
> To: PHP-DB
> Subject: [PHP-DB] Best way to pass multiple selections to a DB
> 
> 
> Hello,
> 
> Can anyone enlighten me as to some techniques for 
> transferring information
> from a multiple select list box to mySQL.
> 
> Someone recommended something about using join tables for 
> this (which I have
> no idea how to set up).
> 
> Thanks
> 
> Tim Winters
> Manager, Creative Development
> Sampling Technologies Incorporated (STI)
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> W: 902 450 5500
> C:  902 430 8498
> 
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

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



[PHP-DB] Best way to pass multiple selections to a DB

2003-06-17 Thread Creative Solutions New Media
Hello,

Can anyone enlighten me as to some techniques for transferring information
from a multiple select list box to mySQL.

Someone recommended something about using join tables for this (which I have
no idea how to set up).

Thanks

Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
W: 902 450 5500
C:  902 430 8498




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