PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
mattmcb
Forum Commoner
Posts: 27 Joined: Sun Jan 25, 2004 3:34 pm
Post
by mattmcb » Fri Oct 01, 2004 11:55 pm
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]
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Sat Oct 02, 2004 12:16 am
[php_man]mysql_insert_id[/php_man]()
mattmcb
Forum Commoner
Posts: 27 Joined: Sun Jan 25, 2004 3:34 pm
Post
by mattmcb » Sat Oct 02, 2004 11:58 am
How do you then find out what that id is?
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Sat Oct 02, 2004 12:12 pm
I don't quite understand what you're asking now.
d_d
Forum Commoner
Posts: 33 Joined: Wed Jul 07, 2004 4:56 pm
Location: UK
Post
by d_d » Sat Oct 02, 2004 3:13 pm
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();
?>