creating vars on the fly

[Mike B]

Hi everyone,
I have a project that I'm working in which the user is allowed to
create and add columns to certain tables in mysql. After they add
them, I need to be able to display them in a form so I can use them.
Now, that part isn't a problem, but what I'm having a problem w/ is
that when I submit them through the form, how can I process all the
fields dynamically. The user could add 20 fields so how in my code
could I handle that. If anyone could help me out I would appreciate
it or if you need more info or I'm not making sense let me know.
LAMP environment, PHP 4.2.3 MySQL 4.0.12

TIA
Mike B

[Ken Robinson]

me***********@yahoo.com (Mike B) wrote in
news:70**************************@posting.google.c om:

Hi everyone,
I have a project that I'm working in which the user is allowed to
create and add columns to certain tables in mysql. After they add
them, I need to be able to display them in a form so I can use them.
Now, that part isn't a problem, but what I'm having a problem w/ is
that when I submit them through the form, how can I process all the
fields dynamically. The user could add 20 fields so how in my code
could I handle that. If anyone could help me out I would appreciate
it or if you need more info or I'm not making sense let me know.
LAMP environment, PHP 4.2.3 MySQL 4.0.12

Here's some code that should help you.
$query = "Your query here";
$result = @mysql_query ($query);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
while(list($key,$val) = each($row)) {
echo '<input type=text name=$key
value="'.htmlspecialchars(stripslashes($row[$key])).'"> '."\n";
}
echo "\n";
}
The key is to get the array return by MySQL to be an associative array
that has the field names as indices to the array.

Ken Robinson
KIS Web Design
www.kis-web-desgin.com

[MeerKat]

mysql_list_fields() could help.

See the example at
http://www.php.net/manual/en/functio...ist-fields.php

Mike B wrote:

Hi everyone,
I have a project that I'm working in which the user is allowed to
create and add columns to certain tables in mysql. After they add
them, I need to be able to display them in a form so I can use them.
Now, that part isn't a problem, but what I'm having a problem w/ is
that when I submit them through the form, how can I process all the
fields dynamically. The user could add 20 fields so how in my code
could I handle that. If anyone could help me out I would appreciate
it or if you need more info or I'm not making sense let me know.
LAMP environment, PHP 4.2.3 MySQL 4.0.12

TIA
Mike B

--
MeerKat