Jump to content


Photo

MySQL Update table with PHP


  • Please log in to reply
1 reply to this topic

#1 Catzwolf

Catzwolf
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 08 January 2003 - 08:25 AM

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

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 08 January 2003 - 09:23 AM

don\'t you mean update a row? or actually change the column definition?
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users