how to merge veriables?

[Dave]

This seems relatively simple, and I'm sure I've done it in the past, but
I can't seem to come up with a solution.

the following variables are sent via form using textbox inputs:
$var_1 = 'var1';
$var_2 = 'var2';
$var_3 = 'var3';

I want to use the variable values to create mySQL column names like so:

$arr = array($var_ ????)
foreach ($arr as &$value) {
mysql_query ("ALTER TABLE table_name ADD $value varchar(100) NOT
NULL");
}

The "????" indicates where I think I am getting stuck on how to capture
the form data into an array. The variables are identical character
length and numbered sequentially, so it is possible to do something like:

$i = 1;
while ($var_???? >= 1) {
mysql_query ("ALTER TABLE table_name ADD $value varchar(100) NOT
NULL");
i++
}

Again, the "????" indicates where I think I'm getting stuck on how to
cycle through the $var_x list.

I know this probably rudimentary and I feel dumb for not being able to
find the solution without coming here. I would really appreciate some
direction.

Thanks in advance
-Dave

[Jerry Stuckle]

Dave wrote:

This seems relatively simple, and I'm sure I've done it in the past, but
I can't seem to come up with a solution.

the following variables are sent via form using textbox inputs:
$var_1 = 'var1';
$var_2 = 'var2';
$var_3 = 'var3';

I want to use the variable values to create mySQL column names like so:

$arr = array($var_ ????)
foreach ($arr as &$value) {
mysql_query ("ALTER TABLE table_name ADD $value varchar(100) NOT
NULL");
}

The "????" indicates where I think I am getting stuck on how to capture
the form data into an array. The variables are identical character
length and numbered sequentially, so it is possible to do something like:

$i = 1;
while ($var_???? >= 1) {
mysql_query ("ALTER TABLE table_name ADD $value varchar(100) NOT
NULL");
i++
}

Again, the "????" indicates where I think I'm getting stuck on how to
cycle through the $var_x list.

I know this probably rudimentary and I feel dumb for not being able to
find the solution without coming here. I would really appreciate some
direction.

Thanks in advance
-Dave

<input type="text" name="name[]" ... >

For each of the inputs. The brackets indicate all the values are to be
passed in the array named "name".
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Dave]

Dave <???@???.???> wrote in news:Tp********************@giganews.com:

This seems relatively simple, and I'm sure I've done it in the past,
but I can't seem to come up with a solution.

the following variables are sent via form using textbox inputs:
$var_1 = 'var1';
$var_2 = 'var2';
$var_3 = 'var3';

I want to use the variable values to create mySQL column names like
so:

$arr = array($var_ ????)
foreach ($arr as &$value) {
mysql_query ("ALTER TABLE table_name ADD $value varchar(100)
NOT
NULL");
}

The "????" indicates where I think I am getting stuck on how to
capture the form data into an array. The variables are identical
character length and numbered sequentially, so it is possible to do
something like:

$i = 1;
while ($var_???? >= 1) {
mysql_query ("ALTER TABLE table_name ADD $value varchar(100)
NOT
NULL");
i++
}

Again, the "????" indicates where I think I'm getting stuck on how to
cycle through the $var_x list.

I know this probably rudimentary and I feel dumb for not being able to
find the solution without coming here. I would really appreciate some
direction.

Thanks in advance
-Dave

I forgot to give the example I was thinking of when I typed the subject,
but I have a variable set for the actual number of variables. In
otherwords, if there are going to be 3 columns in the table, there is a
variable set to "3" like so:
$col_num = "3";
$i = 1;
while ($col_num >= i) {
$col_name = ('$col_num_' . $i);
mysql_query("ALTER TABLE table_name ADD $col_name varchar(100) NOT
NULL");
i++;
}

When I echo $col_name I am getting "$col_num_1", "$col_num_2" and
"$col_num_3". It's not returning the value of $col_num_1 but the actual
text "$col_num_1".

Again, thanks in advance.

[Dave]

Jerry Stuckle <js*******@attglobal.net> wrote in
news:Vr********************@comcast.com:

<input type="text" name="name[]" ... >

For each of the inputs. The brackets indicate all the values are to
be passed in the array named "name".

This got it!

Thanks Jerry!