RE: [PHP-DB] Hi, simple question
There's two methods I use, depending on the situations I need. What it sounds like you want is this: $sql = "SELECT id FROM test ORDER BY id DESC LIMIT 1"; Often when I need to know the next avaliable ID prior to making an insert, I'll do this-- $sql ="SHOW TABLE STATUS LIKE 'test'"; $array = $this->sql->getRow($sql); echo $array['Auto_increment']; Either way will get you a number you can work with, the first gets you the last inserted number and the second way gets you the number of what the next entry will be. --Nick Pappas -Original Message- From: Patrik Fomin [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 9:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Hi, simple question Hi, im adding a post to the database, is there any way to retrive back the ID for the post that i just created? the id is auto_increment and primary key. like $sql = "insert into test (namn, www) values('test', 'test.com')"; mysql_query($sql); $row = mysql_get_post("id"); ? the only way i could think of was to create a tempfield in the database and each time you post you give the temp field a unique value, like: $sql = "insert into test (namn, www, unique) values('test', 'test.com','25323324')"; mysql_query($sql); $sql = "select id from test where unique = '25323324'"; $res = mysql_query($sql); regards patrick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Hi, simple question
see mysql_insert_id($link_identifier) -- rylin Patrik Fomin wrote: Hi, im adding a post to the database, is there any way to retrive back the ID for the post that i just created? the id is auto_increment and primary key. like $sql = "insert into test (namn, www) values('test', 'test.com')"; mysql_query($sql); $row = mysql_get_post("id"); ? the only way i could think of was to create a tempfield in the database and each time you post you give the temp field a unique value, like: $sql = "insert into test (namn, www, unique) values('test', 'test.com','25323324')"; mysql_query($sql); $sql = "select id from test where unique = '25323324'"; $res = mysql_query($sql); regards patrick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Hi, simple question
Hi, im adding a post to the database, is there any way to retrive back the ID for the post that i just created? the id is auto_increment and primary key. like $sql = "insert into test (namn, www) values('test', 'test.com')"; mysql_query($sql); $row = mysql_get_post("id"); ? the only way i could think of was to create a tempfield in the database and each time you post you give the temp field a unique value, like: $sql = "insert into test (namn, www, unique) values('test', 'test.com','25323324')"; mysql_query($sql); $sql = "select id from test where unique = '25323324'"; $res = mysql_query($sql); regards patrick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php