saving with dynamic databasing.

Doesnt loop saving statement

[nanat]

how can u save multiple data?

<?php

$result = mssql_query("select * from LevelOne where f0_SubGroupId='37' and IsActive='Y'");
$exist = mssql_num_rows($result);

if($exist > 0)
{
$number = 1;
for ($i = 0; $i < $exist; $i++)
{
$GID = mssql_result($result, $i, "m0_LeveloneId");
$FOID = mssql_result($result, $i, "f0_SubGroupId");
$SubGDes = mssql_result($result, $i, "LeveloneDescription");
$IsActive = mssql_result($result, $i, "IsActive");
$unit = mssql_result($result, $i , "Unit");

?>
<tr>

<td nowrap="nowrap" style="background-color:#D3D4D6; border: solid 1px #000; border-color:#FFFFFF; color:Black; font-family:Arial, Helvetica, sans-serif; font-size:11px" >
<?=$number?> <?=$SubGDes?> <?=$GID?> </td>
<td><input type="text" size="6" name="cost[]"></td>
<input type="hidden" name="txtactive[]" value="<?=$IsActive?>">
<td><?=$unit?></td>
<td>Qty/Cost</td>
<td>&nbsp;</td>

<?

$pd=13;
$ctr=1;

for($t = 0; $t < $pd; $t++)
{

?>
<td><input type="text" size="6" name="txtlval[]"><?=$FOID?><?=$GID?>
<input type="hidden" name="txtlvlno[]" value="<?=$GID?>"/>
<input type="hidden" name="txtlv1id[]" value="<?=$FOID?>">
<input type="hidden" name="txtpd[]" value="<?=$ctr?>">
<input type="hidden" name="txtsubId[]" value="<?=$SubGDes?>" />

</td>
<?

$ctr++;
}

$number++;
}


?> <tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="button" id="button" value="Submit" /></td>
<td><input type="reset" name="button2" id="button2" value="Reset" /></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<?
}
else
{
echo '<font color="red">Access Denied Or no Entry</font>';

}

?>

Saving

<?php

include ("connect.php");

$tp = count($_POST["cost"]);
$tp2 = count($_POST["txtlv1id"]);

for($i =0; $i < $tp; $i++)
{

$running = $_POST['txtlv1id'][$i];
$value = $_POST['txtlval'][$i];
$cost = $_POST['cost'][$i];
$tp = $_POST['txtpd'][$i];

echo $i,$running, $value, $cost, $tp;

}

?>

what wrong with my saving statement? it doesn't loop..

[vincevincevince]

In the original, you have nested loops ($exist, then $pd); this needs to be replicated in reading the data.

To help your understanding, try this:
print "<plaintext>";
print_r($_POST);