Loops inside a LIST or INSERT statement

[thomasadam83]

I was wondering if there is any way to use loops inside a LIST or INSERT statement. I want to use this in a case where the number of fields and the field names is not constant. I would like to store the field names inside an array and then use that array to make changes and add records to a mysql database.

Any help would be appreciated. Thanks.

Adam.

[[deleted]]

You can't use loops inside MySQL statements,
but you can use loops to create MySQL statements.

For example, you can use a loop to create one big MySQL statement that inserts multiple records.
$sql="INSERT INTO table (field) values ";
for ($t=1;$t<=10;$t++)
{
$sql.="($t)";
if ($t!=10)
{
$sql.=',';
};
};

[Anon]

How would i use the same method in a LIST command. I can create the statement but I cannot get it to run.

[Anon]

This should help:
http://www.phpbuilder.com/manual/function.list.php

[Anon]

I want to use a LIST command where the variables in the brackets are generated from a query. This is the code i used:

/GET A LIST OF FIELD NAMES/
$fields=mysql ("miniyo", "select fieldname from fieldlist where tableid='$tableid'");
$count=mysql_num_rows($fields);
$i=0;
/GENERATE LIST COMMAND/
$sql="list($";
while ($i<$count) {
list($fieldname) = mysql_fetch_row($fields);
$sql.=$fieldname;
$check=$count-1;
if ($i!=$check){
$sql.=", $";
}
$i3++;
}
$sql.=") = mysql_fetch_row($";
$sql.="tmp);";

Now the list command i want to use is stored in the variable '$sql.' How would I run that list command?

Adam

[kparker]

See: http://www.php.net/manual/en/function.eval.php