text file

[Anon]

Hi there.
My text file have this.
None
Dean
Lecturer
Proff

Next i want to convert this text file to SQL statemant like this
ALTER TABLE user MODIFY design enum('None','Dean','Lecturer','Proff') DEFAULT 'None';

How possible to do that. Please help.
Thanks.

[van__]

<?
$tableName = 'user';
$fieldName = 'design';

$lines = file('/path/to/txtfile');

$set = '';

for ($i=0;$i<count($lines);$i++) {
$set .= "'".$lines[$i]."'";
if ($i<(count($lines)-1)) { $set .= ', '; }
}

$sql = "ALTER TABLE $tableName MODIFY $fieldName enum($set) DEFAULT '" . $lines[0] . "'";

?>

[Anon]

Thanks a lot.