Radio / Checkboxes for MySQL

Everything working well... but selection page.
Retrived everything to show on the selections page...
Tryna use radio buttons to select fixtures and checkboxes to select players... anyone has an idea on how to go about doing that?
Sir please help. I can create, view, edit & delete records... login page works well to. Its just the selection page

I did similar thing...
but best advice would be to go look at last years Javascript book.
You also you might want to google, Posting checkboxes into an array.

I do however want to warn you that I am stuck on same path...
Validation has caused me some headaches....
not sure how to count how many users are selected and then restrict this (i.e. before post)

so currently my team can take 0, 3 or 100 members in the team....
forcing me to do some ugly things db side to cope. (deleting team before re-entering team... whether it is an update or fresh create)

This part is specifically not covered in the tut letter as I want you to figure it out.

Google for guidance e,g, http://www.html-form-guide.com/php-form/php-form-checkbox.html http://www.phpfreaks.com/tutorial/working-with-checkboxes-and-a-database

@42609852 last night i managed to get the radio buttons working... selects one "Fixture" from the available, also the checkboxes "BUT" there's a problem, the checkbox selections will only return the "last player" say i select 5... only the 5th player gets pulled and displayed. now i used foreach just to check if the right ids are assigned to the player's checkboxes... works well "when i echo the foreach loop the correct ids are displayed e.g. a 5 player selection will display the ids 1, 6, 7, 10, 12 "I used PHP only no javascripts"
@Mac I'll check the links hope to figure it out soon thanks!

You can send the checkboxes via an array by making them the same name (and an array) ...

Language: HTML
name=';Selected[]';

this then send them as an array...
and you can just save it in an array

I think the way you where sending it only sends the last value...

ahhh go read the html-form-guide... shows how to do it and is very clear

Just read both posts "interesting" . I was using

Language: PHP
name=';Selected[]';

i think my problem was, not using the IN clause and a bit of validation.
phpfreaks explains the subject very-well!!!
now just have to transform from to THANKS!!!

I managed to get the radio buttons and checkboxes to retrieve data from both tables "fixtures and players" and preview/check if that's want the team manger wants. now I need clarity on...
• The third table is for team selections. Give a name of your choice. It must have the following fields:
• selection_id (primary key, auto increment)
• fixture_id
• fields as required by the team (e.g fullback (TEXT), wing (TEXT) etc.)
where should the selections be inserted?

should I create fields for the Fixture, player's name, surname and position in the selections table? please help. Almost done just need clarity.

I think this table is to join the other two tables,
and it does not matter how you join them... but think this is what Mac wants to test....

we should figure out how to do this.
there is multiple way's of doing this, find what works best for your site.

(might want to go check normalisation in your SQL book from last year (but dont think this is needed though, but does make it easier)

Yes. This has been discussed in another thread.