var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MySQL Php get id question
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:
What I need is the pick_id... anyone know the best way to get it?
// 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());
I assume that pick_id is the primary key.
Have a look at the function called mysql_insert_id(). More info on http://se2.php.net/manual/en/functio...-insert-id.php (it was PHP you were using, right?)
Hope this was what you wanted
By the way, if you insert many rows at the same time, mysql_insert_id() will return the number of the first of the inserted rows.
(Suppose you have 10 rows in your table and do INSERT tab VALUES(...), (...). You will get the return value 11 from mysql_insert_id() since the rows you inserted were 11 and 12.)