how to get a value of an autoincrement id after insert in mysql

From: heldopsokken (fietsbelbellen_at_$#@NOSPAM$#@hotmail.com)
Date: 05/31/04 

Date: Mon, 31 May 2004 12:59:57 +0200

Hello,

Is there any way to find out the value of the id (wich is autoincrement)
when using the following statements:

$query = "INSERT into rfc values
('','$gebruiker','$omschrijving','$reden','$aanspreekpunt')";
$sql = mysql_query($query) or trigger_error(mysql_error(), E_USER_WARNING);

Relevant Pages

  • Re: Combining a data from a linked table and a regular table in on
    ... created an Append Query wich adds the field from the "linked", ... the their relevant fields (primary key) appear again in the "linked" table, ... Make an append query that appends the excel data to the table you created ...
    (microsoft.public.access.forms)
  • Re: Retrieving Auto increment field
    ... I am entering information into two tables (Sales and Forecasts). ... table has an autoincrement field (RecordID). ... Query the Sales table to get the RecordID. ...
    (microsoft.public.access.queries)
  • Re: 550 5.7.1 NDR caused by Exchange using A record instead of MX
    ... Thanks for the RFC reference David. ... If that initial mx query ... Mail servers are so touchy anymore because of SPAM that servers ... > Exchange is required to query the A record if no MX records exist. ...
    (microsoft.public.exchange.connectivity)
  • Re: Update with Do Until rsTable.EOF allways leave one record "beh
    ... The text and names wich where used - there where som typofault from ... I created an Update Query in Querry designer. ... I copied the Sql-view for the first query to the SQLStreng, ... Private Sub cmd1_Click ...
    (microsoft.public.access.modulesdaovba)
  • Re: Ahhh.. URL wants to get encoded. Does Java wanna?
    ... the way I read RFC 2396 is that reserved chars: ... Perhaps Patricia could read the RFC ... query, in which case it should be present as an actual & character. ... example URI Wayne gave uses ampersands as query ...
    (comp.lang.java.programmer)