太难用了, 加了一个if就完蛋解决思路

太难用了, 加了一个if就完蛋

CREATE   PROCEDURE   `AddTopics`($fid   smallint,   $author   char(15)   character   set   gbk,   $subject   char(80)     character   set   gbk,   $message   mediumtext     character   set   gbk)

BEGIN

//—————————–下面这个IF语句是新加的

    IF   (select   count(*)   from   my023bbs_threads   where   fid=$fid   and   subject=$subject)> 0   THEN  

        DECLARE   $authorid   mediumint;

        SELECT   uid   INTO   $authorid   FROM   my023bbs_members   WHERE   username   =   $author;

        INSERT   INTO   my023bbs_threads   (fid,   subject,   author,   authorid,   dateline,   lastpost)   VALUES   ($fid,   $subject,   $author,   $authorid,   UNIX_TIMESTAMP(),   UNIX_TIMESTAMP());

        UPDATE   my023bbs_forums   SET   threads   =   threads   +   1   WHERE   fid   =   $fid;

        INSERT   INTO   my023bbs_posts   (fid,   tid,   subject,   author,   authorid,   message,   dateline)   VALUES   ($fid,   last_insert_id(),   $subject,   $author,   $authorid,   $message,   UNIX_TIMESTAMP());

        UPDATE   my023bbs_forums   SET   posts   =   posts   +   1   WHERE   fid   =   $fid;

    END   IF;//————–这里是匹配新加的   IF

END

加了那个IF     END   IF   就出错,存储过程无法保存,太不可思议了

不是太难用，是你不会用

delimiter //

CREATE PROCEDURE `AddTopics`($fid smallint, $author char(15) character set gbk, $subject char(80) character set gbk, $message mediumtext character set gbk)

BEGIN

declare $cnt int(11);

DECLARE $authorid mediumint;

select count(*) from my023bbs_threads where fid=$fid and subject=$subject into $cnt;

IF $cnt> 0 THEN

SELECT uid INTO $authorid FROM my023bbs_members WHERE username = $author;

INSERT INTO my023bbs_threads (fid, subject, author, authorid, dateline, lastpost) VALUES ($fid, $subject, $author, $authorid, UNIX_TIMESTAMP(), UNIX_TIMESTAMP());

UPDATE my023bbs_forums SET threads = threads + 1 WHERE fid = $fid;

INSERT INTO my023bbs_posts (fid, tid, subject, author, authorid, message, dateline) VALUES ($fid, last_insert_id(), $subject, $author, $authorid, $message, UNIX_TIMESTAMP());

UPDATE my023bbs_forums SET posts = posts + 1 WHERE fid = $fid;

END IF;

END//

delimiter ;