Well, here's what I came up with that finally worked for me:
for ( $i=1 ; $i <= $tag_count ; $i++ ) { //tag_count came from the post
page
$tag_num = "tag_num$i";
$tag_type = "tag_type$i";
$tag_cost = "tag_cost$i";
if ( $$tag_cost == "" ) { // can't have empty data per database
parameters
$$tag_cost = "0.00";
}
$tag_late = "tag_late$i";
if ( $$tag_late == "" ) { // can't have empty data per database
parameters
$$tag_late = "0.00";
}
$sql = "INSERT into cfull2.tbl_dl_tags (TAGID_NUM, CUSTID_NUM, TAG_NO,
TAG_YEAR, TYPE_CODE, COST, LATE) VALUES( $TAGID_NUM, $CUSTID_NUM,
${$tag_num}, $this_year, '${$tag_type}' , ${$tag_cost}, ${$tag_late} )";
echo $sql; //debug SQL
$stmt = OCIParse ( $connection , $sql );
OCIExecute ( $stmt , OCI_DEFAULT );
OCICommit( $connection );
OCIFreeStatement ( $stmt );
$TAGID_NUM++;
}
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
> -----Original Message-----
> From: Ignatius Teo [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 13, 2001 5:32 PM
> To: 'Asendorf, John'; 'Darvin Andrioli'; 'Ignatius Teo'; 'Php-Windows
> (E-mail)'
> Subject: RE: [PHP-WIN] assigning variable names on the fly, backed
> myself in to a corner
>
>
> No probs John. I'll take that in non-sequential small US
> denominations, thanks! :-) And of course Darvin can have half.
>
> Ignatius
>
> > -----Original Message-----
> > From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, 14 February 2001 00:33
> > To: Darvin Andrioli; 'Ignatius Teo'; Asendorf, John; 'Php-Windows
> > (E-mail)'
> > Subject: RE: [PHP-WIN] assigning variable names on the fly, backed
> > myself in to a corner
> >
> >
> > That's the ticket. Thanks a million!
> >
> > ---------------------
> > 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
> >
> >
> > > -----Original Message-----
> > > From: Darvin Andrioli [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, February 13, 2001 6:52 AM
> > > To: 'Ignatius Teo'; 'Asendorf, John'; 'Php-Windows (E-mail)'
> > > Subject: RE: [PHP-WIN] assigning variable names on the fly, backed
> > > myself in to a corner
> > >
> > >
> > > Ignatius wrote:
> > >
> > > > try assigning it to another variable first:
> > > > for ....
> > > > $tag = "$tag_num$i";
> > > > $type = "tag_type$i";
> > > > $sql = .... VALUES (..., $tag, $type....);
> > >
> > > The last statement must be:
> > > $sql = .... VALUES (..., $$tag, $$type....);
> > >
> > > so you get the value of the variable named tag_type$i,
> > > otherwise yo get only the string "tag_type value of $i"
> > >
> > > Darvin
> > >
> > >
> > > > -----Original Message-----
> > > > From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, 13 February 2001 07:58
> > > > To: Php-Windows (E-mail)
> > > > Subject: [PHP-WIN] assigning variable names on the fly,
> > > > backed myself in
> > > > to a corner
> > > >
> > > >
> > > > 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]
> > > >
> > >
> >
> > --
> > 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]
> >
>
--
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]
