如何使用INSERT AND COUNT创建SQL命令

I don't know how to COUNT a column named id. I tried

mysql_query("INSERT INTO `servers` (`user_id`, `ip`, `port`, `banner`, `disabled`, `vip`,`premium`, `name`, `status`, `votifier_key`, `votifier_port`, `country`)
             VALUES ('$session_user_id', '$ip', '$port', 's=.'id'.back', '$disabled', 0,'false', '$name', '1', '$votifier', '$votPort', '$country')");

But it's not working, because I couldn't get id. Can someone help?

You need to use INSERT ... SELECT request.

Suppose, we have an empty table test:

     test
|----+-------|
| id | value |
|----+-------|

CREATE TABLE IF NOT EXISTS `test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `value` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

When we run this SQL request:

INSERT INTO test (value) SELECT COUNT(*) FROM `test`

we shall sequentially get test filling up with data:

| id | value |
|----+-------|
| 1  | 0     |
| 2  | 1     |
| 3  | 2     |

Use this approach for your table, and you'll get what you need.