Hello there I am a fairly new in MySQL/PHP/Javascript programming. I'm writing a web based gymnast profile management system for my final year project.

Here's my problem.
I have 5 MySQL InnoDB tables: tests, testunits, points, testsgymnast and gymnast

I am able to retrieve a selected test which has particular units and each unit has a point associated with it using AJAX/PHP triple drop down list which is part of my Input Form called 'Create Gymnast Profile'.

My problem is that I don't know how to complete the creation of a gymnast profile by assigning multiple tests to a gymnast profile (name,dob,age,dob,coach, etc) either using PHP/MySQL or PHP/Ajax/MySQL or PHP/Javascript/MySQL.

In other words when I am running a report my system should be able to retrieve the following data
gymnast name, no. of tests this gymnast is doing each having units and points associated to it.

I am currently able to associate a gymnast with a particular test only without the units and points.

I appriciate all help given and welcome everyone how can give me an advise/solution/source code.

Here's a piece my code you get a better idea of my problem:

<form  class = "create_profile" name = "add_gym" action = "create_GYMNAST_record.php" method = "post" onsubmit='return validateUserFormOnSubmit(this)'>
		<p><h3>Create Gymnast Profile</h3></p>
	 <!--<fieldset><legend>Fill out the form to create a gymnast profile:</legend>-->
		<p>Gymnasts Firstname: <input type="text" name="g_fname" size="15" maxlength="30"/></p>
		<p>Gymnasts Surname: <input type="text" name="g_sname" size="15" maxlength="30"/></p>
		<p>Gymnasts D.O.B (yyyy-mm-dd): <input type='text' name='birthday' id='birthday' size='15' maxlength='30' onBlur = "calcAge(add_gym)"/>&nbsp;
		&nbsp;&nbsp;&nbsp;Gymnasts Age: <input type="text" name="age" id="age" size="3" maxlength="3" readonly="readonly"/></p>
		<p>Gymnasts Height(cm): <input type="text" name="height" id="height" size="5" maxlength="5" onBlur="Calculate()"/></p>
		<p>Gymnasts Weight(kg): <input type="text" name="weight" id="weight" size="5" maxlength="5" onBlur="Calculate()"/>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;H/W Index:<input type="text" name="hw" size="5" maxlength="5" readonly="readonly" onBlur="Calculate()"/></p>
		<p>Coach Firstname: <input type="text" name="c_fname" size="15" maxlength="30"/><p>
		<p>Coach Surname: <input type="text" name="c_sname" size="15" maxlength="30"/><p>
		<p>Club name: <input type="text" name="clubname" size="15" maxlength="30"/><p>
		 echo "<p>";
		 echo "Tests : <font id=tests><select>\n";
		 echo "<option value='0'>============</option> \n" ;
		 echo "</select></font>\n";
		 echo "Units : <font id=units><select>\n";
		 echo "<option value='0'>=== none ===</option> \n" ;
		 echo "</select></font>\n";
		 echo "Points: <font id=points><select>\n";
		 echo "<option value='0'>=== none ===</option> \n" ;
		 echo "</select></font>\n";
		<p><input type="submit" name="Submit" value="CreateRecord" onclick = 'return showMessage()'>
		<input type="reset" name = "clearForm" value="Reset" onclick = 'return formReset()'/></p>

Thank you in advance.

Hi and welcome to daniweb. To start off with I noticed that you are asking us to answer your homework for you. Well unless you show reasonable effort then you won't get anyone elses replies. I would suggest having a go at it and if there are any troubles then post those problems here. And if there are error messages then post the error messages here too. But this is a big assignment and I don't think any single person will answer the entire thing for you. Good luck :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.