assigning variable names on the fly, backed myself in to a corner

From: Date: Mon, 12 Feb 2001 20:58:29 +0000
Subject: assigning variable names on the fly, backed myself in to a corner
Groups: php.windows 
Request: Send a blank email to php-windows+get-5532@lists.php.net to get a copy of this message
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 - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Ipsa scientia potestas est

« previous php.windows (#5532) next »