[PHP] Help with writing multiple records to a table

2002-08-30 Thread Duffy Betterton 
  br
  Nailers amp; Supplies 
  input type=checkbox name=category[] value=18
  br
  Painters amp; Supplies 
  input type=checkbox name=category[] value=19
  br
  Party 
  input type=checkbox name=category[] value=21
  br
  Pipe Threaders 
  input type=checkbox name=category[] value=22
  br
  Power Tools amp; Blades 
  input type=checkbox name=category[] value=23
/td
td valign=top Pressure Washers 
  input type=checkbox name=category[] value=24
  br
  Pumps amp; Hoses 
  input type=checkbox name=category[] value=25
  br
  Roofing 
  input type=checkbox name=category[] value=27
  br
  Safety 
  input type=checkbox name=category[] value=28
  br
  Scaffolding amp; Accessories 
  input type=checkbox name=category[] value=29
  br
  Shop Tools 
  input type=checkbox name=category[] value=30
  br
  Surface Preparation 
  input type=checkbox name=category[] value=32
  br
  Surveying 
  input type=checkbox name=category[] value=33
  br
  Steel amp; Carbide 
  input type=checkbox name=category[] value=31
  br
  Trailer amp; Towing 
  input type=checkbox name=category[] value=34
  br
  Ventilation 
  input type=checkbox name=category[] value=35
  br
  Welding 
  input type=checkbox name=category[] value=36
/td
  /tr
/table
br
Additional Comments: br
textarea name=comments cols=60 rows=4/textarea
br
  /div
  p align=left 
input type=submit name=Submit value=Submit
br
  /p
  div align=left Thank you for your time!br
Visit our website at www.mtadistributors.com /div
/form
?php } ? ?php include footer.php; ? 


Duffy Betterton
Director of Publications
615-277-3265
[EMAIL PROTECTED]
www.mtadistributors.com


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

[PHP] Does this call for an array?

2002-08-28 Thread Duffy Betterton 

Here is what I would like to do. I have a simple form that asks for
information from a customer. One of the questions is Which categories of
products are you interested in? I want to store all the data in a table
called pf_survey. All the categories(42) are already listed in a
separate table called categories. I don't think I want to repeat a list
of columns in the pf_survey table if they are already in the categories
table. The categories table is simply category_id and category_name. If
my form has a checkbox by each category name with the corresponding
category_id in the value field - how do I concatenate all the boxes
checked in order to put more than one category_id in the pf_survey
category_ids field? 

Does this call for an array? Does it even make sense to do it like this?
Thank you for any help.

Duffy Betterton
Director of Publications
615-277-3265
[EMAIL PROTECTED]
www.mtadistributors.com


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