What am I doing wrong please?

[zmola]

$db_tbl = "logs";
$db_col[0] = "log";
$db_col[1] = "date";
$clm_list = implode(',',$db_col);
$connect = mysql_connect($db_addr,$db_user,$db_pass) or die(mysql_error());
$fulltext_key = mysql_query("ALTER TABLE $db_tbl ADD FULLTEXT KEY keyname ($clm_list)") or die ("Invalid alter table query");

the above dies, giving invalid alter table query.

please, does anyone see my typo?

[KoshNaranek]

Here is my way for trying out SQL-Statements:

Just ECHO your SQL-Statement... copy and paste it into a mysql-console or phpMyAdmin.

$sql="ALTER TABLE $db_tbl ADD FULLTEXT KEY keyname ($clm_list)";
echo $sql;
mysql_query($sql);

You should get something like "you have got an error near...."

That's very helpfull... sometimes... 😃

[zmola]

thanks. echo gives: ALTER TABLE logs ADD FULLTEXT KEY keyname (log,date)

also, phpMyAdmin is happy with this, but my script is not ::sniff::

any other ideas?

[zmola]

i figured it out.

q: a long night of coding, no sleep, etc... and what do i forget???
a: select the db.

zmola <--- duh.

thanks for taking the time to read my posts.

[KoshNaranek]

😃 so it worked again... the statement was correct, so the error was anywhere else... 🙂
Don't mind... you are not the 1st who made this fault 😉