[PHP-WIN] assigning variable names on the fly, backed myself in to a corner

[Asendorf, John]

I've written a little script that makes a form using a simple for loop:

if ( $num_reg != "" )   {         //we're doing regulars

        for ( $i = 1 ; $i <= $num_reg ; $i++ )  {
                echo "<tr><td>A<input type=\"hidden\" name=\"tag_type${i}\"
value=\"A\"></td>";
                echo "<td><input type=\"text\" name=\"tag_num${i}\"></td>";
                echo "<td><input type=\"text\" name=\"tag_cost${i}\"
value=\"\"></td>";
                echo "<td><input type=\"text\"
name=\"tag_late${i}\"></td></tr>\n";
        }       
        
        $tag_count = $num_reg;
        
}

Now what I have is a number of variables that look something like this

$tag_type1, $tag_num1, $tag_cost1, $tag_late1, $tag_type2, $tag_num2,
$tag_cost2, $tag_late2, etcetera... up to any number of tags...

now I'm trying to write a little for loop that drops this information into a
database after the POST:

for ( $i=1 ; $i <= $tag_count ; $i++ ) {  //tag_count came from the post
(dl_post_3.php)

     $sql = "INSERT into cfull2.tbl_dl_tags (TAGID_NUM, CUSTID_NUM, TAG_NO,
TAG_YEAR, TYPE_CODE, COST, TYPE) VALUES ($CUSTID_NUM, $tag_num$i, $tag_year,
'$tag_type$i' , $tag_cost$i )";

     $stmt = OCIParse ( $connection , $sql );

     OCIExecute ( $stmt , OCI_DEFAULT );
     OCICommit( $connection );
     OCIFreeStatement ( $stmt );
}


This obviously doesn't work and I'm not really sure what to do now.  Is this
a case of variable variable names?  I don't quite get those either  :)

Thanks in advance all,

John


---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Ipsa scientia potestas est


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]