RE: [PHP-DB] Best way to pass multiple selections to a DB
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
> 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
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
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