Page 1 of 1

MySQL Php get id question

Posted: Fri Oct 01, 2004 11:55 pm
by mattmcb
feyd | Please use

Code: Select all

tags when posting code. Read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]


Let's say you just inserted a new row of information and your id or primary key is auto incrementing... how can you then grad that id to use in later scipts to perform other processes and logic?

Here is an example:

Code: Select all

// Insert data into database
$sql = 'INSERT INTO `picks` ( `team_name` , `team_location` , '.$bet.' , `bet_desc` , `bet_weight` , `comments` , `game_date` , `modify_date` ) '
			. ' VALUES ( '''.$_POST['team_name'].''', '''.$_POST['team_location'].''', '''.$_POST['play'].''', '''.$_POST['play_desc'].''', '''.$_POST['weight'].''', '''.$_POST['comments'].''', '''.$_POST['game_date'].''', NOW( ) );'
			. ' ';
$result = mysql_query($sql)or die (mysql_error());
What I need is the pick_id... anyone know the best way to get it?


feyd | Please use

Code: Select all

tags when posting code. Read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]

Posted: Sat Oct 02, 2004 12:16 am
by feyd
[php_man]mysql_insert_id[/php_man]()

Posted: Sat Oct 02, 2004 11:58 am
by mattmcb
How do you then find out what that id is?

Posted: Sat Oct 02, 2004 12:12 pm
by feyd
I don't quite understand what you're asking now.

Posted: Sat Oct 02, 2004 1:08 pm
by John Cartwright
[php_man]mysql_fetch_assoc[/php_man] ???

Posted: Sat Oct 02, 2004 3:13 pm
by d_d
Like feyd said mysql_insert_id
http://www.php.net/mysql_insert_id/
returns the ID generated for an AUTO_INCREMENT column by the previous INSERT query using the given link_identifier

Code: Select all

<?php
// Insert data into database
$sql = 'INSERT INTO `picks` ( `team_name` , `team_location` , '.$bet.' , `bet_desc` , `bet_weight` , `comments` , `game_date` , `modify_date` ) '
            . ' VALUES ( '''.$_POST['team_name'].''', '''.$_POST['team_location'].''', '''.$_POST['play'].''', '''.$_POST['play_desc'].''', '''.$_POST['weight'].''', '''.$_POST['comments'].''', '''.$_POST['game_date'].''', NOW( ) );'
            . ' ';
$result = mysql_query($sql)or die (mysql_error());
$id = mysql_insert_id();
?>