Adding more than one record at a time
Posted: Mon Mar 01, 2004 8:56 am
Hi,
i'm trying to add more than one record at a time into my database using a single form. But i can only get one record to add into my database. Does anyone know how to add multiple records into a database at the same time?
heres my code
Cheers
<tr>
<td width="19%" height="25" bgcolor="#FFFF99">Time</td>
<td width="30%"> </td>
<td width="42%"> </td>
</tr>
<tr>
<td> <input name="Time12" type="text" id="Time12"></td>
<td><div align="center">
<select name="select9" id="select">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
<td><div align="center">
<select name="select9" id="select2">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
</tr>
<tr>
<td> <input type="text" name="textfield222"></td>
<td><div align="center">
<select name="select9">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
<td><div align="center">
<select name="select9">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
</tr>
i'm trying to add more than one record at a time into my database using a single form. But i can only get one record to add into my database. Does anyone know how to add multiple records into a database at the same time?
heres my code
Cheers
<tr>
<td width="19%" height="25" bgcolor="#FFFF99">Time</td>
<td width="30%"> </td>
<td width="42%"> </td>
</tr>
<tr>
<td> <input name="Time12" type="text" id="Time12"></td>
<td><div align="center">
<select name="select9" id="select">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
<td><div align="center">
<select name="select9" id="select2">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
</tr>
<tr>
<td> <input type="text" name="textfield222"></td>
<td><div align="center">
<select name="select9">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
<td><div align="center">
<select name="select9">
<?php
do {
?>
<option value="<?php echo $row_Members['MemberID']?>"<?php if (!(strcmp($row_Members['MemberID'], $row_Members['MemberID']))) {echo "SELECTED";} ?>><?php echo $row_Members['MemberID']?></option>
<?php
} while ($row_Members = mysql_fetch_assoc($Members));
$rows = mysql_num_rows($Members);
if($rows > 0) {
mysql_data_seek($Members, 0);
$row_Members = mysql_fetch_assoc($Members);
}
?>
</select>
</div></td>
</tr>