Professional Web Applications Themes

mysql autoincrement- return id - PHP Development

Hello, I have a table with column ID of auto increment type. I want to insert a record in the table and then I want to show it's ID. My best idea is to count the records in the table after inserting the record. But if 2 people will insert different records in the same time in the same table, then it is possible that they will get wrong ids. To be sure that the script will always return right id I can write a sql query that will search the table for record of values same as the ones, ...

  1. #1

    Default mysql autoincrement- return id

    Hello,
    I have a table with column ID of auto increment type.
    I want to insert a record in the table and then I want to show it's ID.
    My best idea is to count the records in the table after inserting the
    record.
    But if 2 people will insert different records in the same time in the same
    table, then
    it is possible that they will get wrong ids.
    To be sure that the script will always return right id I can write a sql
    query that will search the table for record of values same as the ones, that
    have been just saved.

    But- can I do it easier and faster?

    Regards,
    Talthen


    Guest

  2. #2

    Default Re: mysql autoincrement- return id

    use mysql_insert_id() direct after your INSER Query.

    More doentation on http://dk2.php.net/mysql_insert_id

    Good luck!

    Jochem

    Jochem Guest

  3. #3

    Default Re: mysql autoincrement- return id

    User nicknamed <com> : 

    Thanks, that's *exactly* what I wanted :]

    Regards,
    Talthen


    Guest

Similar Threads

  1. Replies: 2
    Last Post: March 7th, 07:18 PM
  2. autoincrement problem
    By acidrain9 in forum Dreamweaver AppDev
    Replies: 3
    Last Post: February 21st, 02:24 PM
  3. Parsing MySQL query return
    By John in forum PHP Development
    Replies: 4
    Last Post: July 29th, 03:47 AM
  4. ViewState + AutoIncrement -- Okay; Session + AutoIncrement -- Not okay
    By Gene Gorokhovsky in forum ASP.NET General
    Replies: 0
    Last Post: July 17th, 02:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139