[BNM] PHP MySQL auto-increment value

[Ali]

although on further inspection you are not inserting anything at all in your query! Your query is a select not an insert - use mysql_insert_id() immediately after the insertion.


Ali
  ----- Original Message ----- 
  From: Ali 
  To: Brighton New Media 
  Sent: Wednesday, October 24, 2007 1:08 PM
  Subject: Re: [BNM] PHP MySQL auto-increment value


  number 2 was close!

  You must call the mysql_insert_id() AFTER you have run the query to insert the record not before as your code does - and always a good idea to include the link resource in the call also e.g. mysql_insert_id($myconnection);

  hth

  ali

  On 24/10/2007 12:42:01, Richard Wells (richard at richard-wells.co.uk) wrote:
  > I am stuck on this:
  > 
  > how do you recall an auto-incremented value (eg a primary key id)
  > which you have just generated by inserting data into a table using a
  > form, in order to insert it into the next table (as a foreign key)?
  > 
  > I have tried a couple of things but with erratic results:
  > 
  > 1. Create a session variable:
  > 
  > <?php
  > session_start();
  > if ($_POST && !empty($_POST['Contact_ID'])) {
  > $_SESSION['Contact_ID'] = $_POST['Contact_ID'];
  > }
  > ?>
  > 
  > 2. Use mysql_insert_id(); to recall it, POST it in a form and then
  > create a session variable:
  > 
  > <?php
  > mysql_select_db($database_SAOS2008, $SAOS2008);
  > $query_rsContact = "SELECT `Contact_ID` FROM contacts";
  > $Contact_ID = mysql_insert_id();
  > $rsContact = mysql_query($query_rsContact, $SAOS2008) or die
  > (mysql_error());
  > $row_rsContact = mysql_fetch_assoc($rsContact);
  > $totalRows_rsContact = mysql_num_rows($rsContact);
  > ?>
  > 
  > <input type="hidden" name="Contact_ID"
  > value="<?php echo
  > $Contact_ID; ?>" />
  > 
  > Richard
  > --
  > 
  > BNM Subscribe/Unsubscribe:
  > http://www.brightonnewmedia.org/options/bnmlist
  > 
  > List jobs for 10 pounds on Sussex Digital. Use promo code bnm10
  -- 

  BNM Subscribe/Unsubscribe:
  http://www.brightonnewmedia.org/options/bnmlist

  List jobs for 10 pounds on Sussex Digital. Use promo code bnm10 http://jobs.sussexdigital.com/

  Join BNM on Linkedin - http://www.linkedin.com/e/gis/23805/5841CA3F0360

  BNM powered by Wessex Networks:
  http://www.wessexnetworks.com


  -- 
  No virus found in this incoming message.
  Checked by AVG Free Edition. 
  Version: 7.5.488 / Virus Database: 269.15.8/1089 - Release Date: 23/10/2007 19:39