我为我的一个朋友设计的网站上的内置管理面板有一个基本的HTML输入表单.他的想法是让他将用PHP脚本编写的数据发布到数据库中,然后将其放回到索引页面上.
I have a basic HTML input form for an inbuilt admin panel on a website that I'm designing for a friend of mine. The idea is for him to post data scripted with PHP to the database, which is then spat back out onto the index page.
问题:
每个条目显然在db中都有自己的列(id,name,ep_num等). id将自动递增到数据库中,名称被收集为$_POST['name'],但是对于ep_num,我想为每个名称分配自动递增.
Each entry obviously has its own column in the db (id, name, ep_num etc). The id is auto incremented into the database, the name is gathered as a $_POST['name'], however for ep_num, I would like to assign auto increments per name.
EG:
他发布了一次"Hello",它的ep_num为"1" 他输入了世界"一次,给出了ep_num为"1" 他再次输入"Hello",其ep_num为"2"
He posts "Hello" once, it is given the ep_num of "1" He inputs "World" once, it is given the ep_num of "1" He inputs "Hello" again, it is given the ep_num of "2"
我工作了很长的一天,并且相信mysql_insert_id()可能就是我想要的,我只是在努力地发挥自己的作用,并希望你们中的一个能帮助我.
I've had a long day at work, and believe that mysql_insert_id() may be what I'm looking for, I'm just struggling to put my brain to work and was hoping one of you guys to aid me.
预先感谢, 丰富
推荐答案insert into t (name, ep_num) select 'b', count(*)+1 from t where name='b';
在sqlfiddle上进行演示
更多推荐
SQL Auto Increment在同一张表中多次
发布评论