Jump to content

Archived

This topic is now archived and is closed to further replies.

Catzwolf

MySQL Update table with PHP

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.