for statement inside $sql variable....

[listenmirndt]

Ok so obviously this code is wrong - but this is what I want to do - (in theory) - how could this be done?

$sql = "INSERT INTO $table SET

for ($i=0; $i < $count; $i++)
{
$x=$i+1;
$y = $_POST[$pre[$x]];
$d = $y;

$pre[$x] = '$d$x', // FIELD = '$data'
}

ID = ''";
$query = mysql_query($sql) or die("$sql_error" . mysql_error());

Thanks
-Arron

[Roger_Ramjet]

So you want to use numeric field names do you? Not a good idea, even if mysql does accept them: most db engines will not allow all numeric names so it's a bad habit to have.

That said, you will need to use the back-tick ` to quote the column name if it is all numeric.

$sql = "INSERT INTO $table SET ";

for ($i=0; $i < $count; $i++)
{
$x=$i+1;
$y = $_POST[$pre[$x]];
$d = $y;

$sql .= " `$pre[$x]` = '$d$x',"; // FIELD = '$data'
}

$sql .= " ID = '' ";
$query = mysql_query($sql) or die("$sql_error" . mysql_error());

That should just about do it. Looks horrible to me. How exactly is your table laid out?

[listenmirndt]

Actually, I dont plan to insert numbers - I took apart a $_POST array, I needed to generate the database insert values (with that for loop)

Anyhow, that worked like a charm! Thanks!!!!!!

-Arron