under the covers

[kiwi2]

This is such a silly problem I am almost embarassed to ask
If I have an ALTER TABLE STATEMENT AND I need an ENUM field to be filed with an array of values drawn from a txt file what is the correct syntax to use.
$vals = file($txt);

foreach ($vals as $val)
{
str_replace("|", " ", $val);
$val1 ="$val";
"ALTER TABLE change cat cat ENUM($val1)";
}

does'nt work .
Input data in file
'one' , |'two' ,|'three'
please help I feel as if my head is under cover on this

[Bozebo]

well... I hope this is what you are asking for because you have worded your problem badly:

So you are wondering what mysql query you need?
well:
$query = "UPDATE tablename SET cat = '$val'";
mysql_query($query) or die(mysql_error());

I havn't used enum before so I'm not sure if that will work...

[wilku]

$val = file_get_contents($txt); //reads to one string instead of array

$val1 = str_replace("|", " ", $val);
mysql_query( "ALTER TABLE change cat cat ENUM($val1)") or die(mysql_error()); 

str_replace doesn't replace strings in original variable - it returns new string, thus $var1 in front of str_replace.
And queries don't run all by themselves - mysql_query must be used (with some other mysql connection functions first - check [man]mysql[/man] or [man]mysqli[/man]).
Is this what you're looking for?