[PHP] Re: Concatenate PHP code into a string

[franciccio]

$query="INSERT"+" ";
for ($i=0;$i<sizeof($col);$i++) {
    $query+=cols[$i]+" ";
}
    $query+="comment INTO mytable SET";

for ($i=0;$i<sizeof($col);$i++) {
    $query+=cols[$i]+"="+$cols[$i]+",";
}

Bye
Franciccio


"Abrea" <[EMAIL PROTECTED]> ha scritto nel messaggio
news:[EMAIL PROTECTED]
> Dear List,
> How can I include a dynamically generated array:
> e.g. for($i=0; $i<sizeof($cols); $i++)
>       { $cols[$i]= mysql_field_name($fields,$i); }
>
> into a MySQL insert query of the type:
> $sql= "INSERT cols[0],cols[1],cols[2], ..., comment
> INTO mytable SET
> cols[0]= '$cols[0]',
> cols[1]= '$cols[1]',
> cols[2]= '$cols[2]',
> cols[...]= '$cols[...]',
> comment= '$comment'";
>
> The number of $cols is different for each table.
> Thanks in advance for any help
>
> Alberto Brea

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php