Submit form(update-page) categories with check-boxes

Discussion in 'PHP' started by b.devroey, Nov 30, 2011.

  1. #1
    Hi everyone,

    I have some problems with one of my script...

    I'm trying to build an update page for my categories script, but i cant find how to write everything in a good way...
    I give you a slight preview of my thoughts...

    1. Database Structure________________

    Table=cat_name
    ID | cat_number | cat_name
    1 | 25 | food
    2 | 26 | drinks
    3 | 27 | services
    ________________________________

    Table=cat_products
    ID | attached_to_cat | prod_name
    1 | 25 | lobster
    2 | 26 | Coca
    3 | 27 | Wake-up-service
    ________________________________


    2. Update page structure_____________
    2.1 read out the category's and products...
    Food
    (checkbox) lobster

    Drinks
    (checkbox) coca
    (checkbox) fanta
    (checkbox) sprite

    Service's
    (checkbox) roomservice
    (checkbox) wakeup

    All other category's....
    (checkbox)...
    (checkbox)...

    [Submit-button]

    2.0 after submit save the checked boxes by query (ID into a field)...

    I hope someone can inform me how to do this properly...

    Kind regards,
    Bart Devroey
     
    b.devroey, Nov 30, 2011 IP
  2. Javed iqbal

    Javed iqbal Well-Known Member

    Messages:
    445
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    103
    #2
    i can do for youif you give me access to db and your php file
     
    Javed iqbal, Nov 30, 2011 IP
  3. qhm

    qhm Peon

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Where exactly are you facing problems? What do you mean by 'good way'? I'd be able to help if you explain a bit more.
     
    qhm, Dec 7, 2011 IP