问题1.$db->query("UPDATE {$tablepre}forumfields SET description=description+'$discuz_user' WHERE fid='$fid'");为什么这样+不可以...难道只有数字才可以+吗?请问怎样修改???===================================
问题2.上面那句是添加...我想问怎样从description搜到$discuz_user並刪除?
谢谢..................................................谢谢万分....
问题2.上面那句是添加...我想问怎样从description搜到$discuz_user並刪除?
谢谢..................................................谢谢万分....
$db->query("DELETE FROM {$tablepre}forumfields WHERE description LIKE '$discuz_user'");//后面多了个,
UPDATE {$tablepre}forumfields SET description=CONCAT_WS(SUBSTRING(description,LOCATE('$discuz_user',description),LENGTH($discuz_user)),SUBSTRING(description,LOCATE('$discuz_user',description)+LENGTH($discuz_user))) WHERE description LIKE '$discuz_user'");
$db->query("SELECT REPLACE('$forumdescription', '$discuz_user', '')");