1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

请教mysql插入数据的问题

Discussion in '后端开发' started by swenge, Mar 1, 2006.

  1. swenge

    swenge New Member

    Joined:
    Nov 28, 2005
    Messages:
    386
    Likes Received:
    1
    当我执行一条插入语句,比如

    Code:
    mysql_query("insert into news (title, content) values ('$title','$content')");
    然后我的数据库中还有一个file字段,我想接着执行一个语句把它设置为与自动赋值的id字段的值相同

    应该怎么做呢?
    :( :confused:
     
  2. swenge

    swenge New Member

    Joined:
    Nov 28, 2005
    Messages:
    386
    Likes Received:
    1
    我顶!
     
  3. vicke

    vicke New Member

    Joined:
    Dec 20, 2005
    Messages:
    2,348
    Likes Received:
    24
    不懂帮顶:cool:

    能不能麻烦一下,解释下上面语句的意思里 一起学习学习
     
  4. woshidianpa

    woshidianpa New Member

    Joined:
    Nov 8, 2005
    Messages:
    89
    Likes Received:
    1
    我只知道ASP SQL.....

    mysql_query("insert into news (title, content) values ('$title','$content')");

    就是插入新记录吧..字段title 字段content 后面是获取的值


    ASP 中过两种可以马上获得新增记录的ID....PHP不懂..
     
  5. swenge

    swenge New Member

    Joined:
    Nov 28, 2005
    Messages:
    386
    Likes Received:
    1
    wc来看看啊!
     
  6. Tameway

    Tameway New Member

    Joined:
    Sep 6, 2005
    Messages:
    1,286
    Likes Received:
    8
    在插入记录后,获取ID的值,赋给FILE
     
  7. swenge

    swenge New Member

    Joined:
    Nov 28, 2005
    Messages:
    386
    Likes Received:
    1
    谢谢,可是如何获取插入这条数据的ID呢
     
  8. swenge

    swenge New Member

    Joined:
    Nov 28, 2005
    Messages:
    386
    Likes Received:
    1
    汗,搞出来了!
    Code:
    mysql_query("insert into news (title, content) values ('$title','$content')");
    $id=mysql_insert_id();
    mysql_query("UPDATE news SET file = id WHERE id = $id");
     
    #8 swenge, Mar 2, 2006
    Last edited: Mar 2, 2006