Please Help!!

obrienkev

Hi all,

I am really stuck on this. Basically I am creating a personal fitness site. I want to be able to create personalised programs for each person.

I want each person to have a personalised username/password to login. Once they log in there will be a page that displays their program.

For creating the program I want the following: The database will contain a table with names of methods such as jogging, swimming, etc.

Each method will be displayed on the webpage with a checkbox.
The user selects each method that they want.
When they press submit they are taken to a page that displays further options based on the choices they picked.

So for example, if they selected jogging and weights the following page would display num of laps, speed, weight-type, weight, etc.

Each of these would contain a textfield so one can enter how fast they should go, etc.

my main problem is when they select from the first set of checkboxes how do I display the data based on their selection from a database??

Or do you guys think tht there is a much simpler way of doing this??

Thanks.

Kevin.

obrienkev

Here is my php code for the first part:

$num_results = mysql_num_rows($result);

echo '<form id="FormName" action="training.php" method="post" name="FormName">';

echo 'Enter clients Name:<br /><input type="text" name="name"><br />';

for ($i=0; $i<$num_results; $i++)
   {
    $row = mysql_fetch_array($result);
    echo ($i+1).'.'.$row['method']. '<input type="checkbox" name="rep[]" value="'.$row['method'].'">';
    echo '<br />';
   }

This displays results such as running, weights, etc. each with a checkbox.

Then how do I display the next set of results based on the users selection??

Thanks.

obrienkev

Anyone Please??

Any ideas on how I should even begin this are welcome.

Thanks.

Kudose

Refer to this thread:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10295265

Near the bottom.

thorpe

its all in your db design. these are just someideas, but hopefully you can go from here.

you have a table called 'methods' in that table you have an id, and a title.

1 - jogging
2 - weights

then you have another table called 'extras', and in that table you have id, method_id, and title.

1 - 1 - laps
2 - 1 - speed
3 - 2 - weighttype
4 - 2 - weight

then, when a user selects a 'method' from with a checkbox, post its id to the next page, and pull all 'extras' from the db that have that same method_id.

eg;

$method_id = $_POST['method_id'];
mysql_query("SELECT title FROM extras WHERE method_id=$method_id");

hope that helps.