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]
