Hello,
I am trying to pass company registration information to a mySQL data base. The company may sign up one or more employees to attend a training.
The problem:
Currently I am capturing the employees names in a text area field and passing this information to a mySQL data base datafield called "trainees". This works great for one employee, but what if a company registers 20 employees. The "trainees" datafield can only hold so many characters.
What is a better solution to capturing multiple names and storing them into a mySQL datafield.
Here is the code showing the text area where the employees names are captured:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<table width="395" border="1" align="center" bgcolor="#BFC0B6">
<tr>
<td width="313">
<div align="center"><b><font color="#000000" size="3" face="Arial, Helvetica, sans-serif">Number
of Trainees:</font></b></div>
</td>
<td width="66">
<input type="text" name="numbertrain" size="10">
</td>
</tr>
<tr>
<td width="313">
<p align="center"><b><font color="#000000" size="3">Trainees Names:</font></b></p>
<p align="center"><b><font color="#000000" size="3" face="Arial, Helvetica, sans-serif">Enter
all trainees names: </font></b></p>
<p align="center"><font color="#000000" size="3" face="Arial, Helvetica, sans-serif"><b>(first
last) and press enter to enter the next name.</b></font></p>
</td>
<td width="66">
<textarea name="trainees" cols="30" wrap="PHYSICAL" rows="10"></textarea>
</td>
</tr>
<tr>
<td width="313"> </td>
<td width="66"> </td>
</tr>
<tr>
<td width="313">
<div align="center">
<input type="Submit" name="submit2" value="Enter information">
</div>
</td>
<td width="66">
<div align="center"> </div>
</td>
</tr>
</table>
<p> </p>
</body>
</html>
Any suggestions is greatly appreciated, and please bear mind that I am total newbie at php and mySQL.
Thank You.
