I have written a script to update the database when a user upgrades from one script to another. The problem I have is that I need to check that Field already exists, if not \'ADD\' to the \'TABLE\' or \'UPDATE\' field row.
But everytime I try to \'UPDATE\' the field I get an error saying that it already exists?
This is code I am trying to use:
[php:1:4e2d389063]<?php
$$result = $xoopsDB->queryF(\"ALTER TABLE \".$xoopsDB->prefix(\"wfs_category\").\" ADD groupid varchar(255) NOT NULL default \'1 2 3\'\");
if (!$result) {
$result = $xoopsDB->queryF(\"ALTER TABLE \".$xoopsDB->prefix(\"wfs_category\").\" UPDATE groupid varchar(255) NOT NULL default \'1 2 3\'\");
if (!$result) {
$error[] = \"Failed ALTER TABLE \".$xoopsDB->prefix(\"wfs_category\").\"\";
}
}?>[/php:1:4e2d389063]
But it will not update the table giving this MySQL Error:
MySQL Query Error: ALTER TABLE xoops_wfs_category UPDATE groupid varchar(255) NOT NULL default \'1 2 3\'
Error number:1064
Error message: You have an error in your SQL syntax near \'UPDATE groupid varchar(255) NOT NULL default \'1 2 3\'\' at line 1
I am quite new to PHP/MySQL and any help would be really gratefull :-)
Many thanks
