MySQL Update table with PHP

[Catzwolf]

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

[effigy]

don\'t you mean update a row? or actually change the column definition?