还有问题，不过是mysql的问题了

转信站: BYR!news.cn99.com!bbsnews.sdu.edu.cn!news.neu.edu.cn!news.cn-bbs.org!ne 在往表里插入数据之前，要use哪个数据库呢？ 在bonlinelog.c里没有看见打开数据库的相关代码，只有个mysql_init(&s)， 请大侠指点！谢谢！！ 【 在 darling (大林) 的大作中提到: 】 : 现在系统总发邮件给我，说 : From bbs@debian.workgroup Thu Oct 18 22:02:03 2007 : Return-path: <bbs@debian.workgroup> : ...................

转信站: BYR!news.cn99.com!news.szu.edu.cn!news.neu.edu.cn!news.cn-bbs.org!news. 现在系统总发邮件给我，说 From bbs@debian.workgroup Thu Oct 18 22:02:03 2007 Return-path: <bbs@debian.workgroup> Envelope-to: bbs@debian.workgroup Delivery-date: Thu, 18 Oct 2007 22:02:03 +0800 Received: from bbs by debian.workgroup with local (Exim 4.63) (envelope-from <bbs@debian.workgroup>) id 1IiVwp-0000nz-QM for bbs@debian.workgroup; Thu, 18 Oct 2007 22:02:03 +0800 From: root@debian.workgroup (Cron Daemon) To: bbs@debian.workgroup Subject: Cron <bbs@debian> /home/bbs/bin/bonlinelog Content-Type: text/plain; charset=ANSI_X3.4-1968 X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin> X-Cron-Env: <MAILTO=bbs> X-Cron-Env: <BBSHOME=/home/bbs> X-Cron-Env: <HOME=/home/bbs> X-Cron-Env: <LOGNAME=bbs> Message-Id: <E1IiVwp-0000nz-QM@debian.workgroup> Date: Thu, 18 Oct 2007 22:02:03 +0800 No database selected No database selected No database selected No database selected No database selected No database selected No database selected 我看了一下bonlinelog的代码，里面有语句要往bonline表里面插入数据： int fillbcache(struct boardheader *fptr,int idx,void* arg) { int bnum; struct BoardStatus * bs; char sql[500]; if (check_see_perm(NULL, fptr)==0 || strlen(fptr->filename) == 0) return 0; bnum = getbid(fptr->filename,NULL); bs = getbstatus(bnum); sprintf(sql, "INSERT INTO bonline VALUES ( NULL, '%s', '%d', '%d', \"%d-%d-%d\", '%d', '%d' );", fptr->filename, bs->currentusers, bs->nowid, t.tm_year+1900, t.tm_mon+1, t.tm_mday, t.tm_hour, t.tm_min/6); if( mysql_real_query( &s, sql, strlen(sql) )) printf("%s\n",mysql_error(&s)); return 0; } 请问大侠，如何在mysql里建表，还有KBS用mysql的话，要建什么名字的数据库？