Help Index Field of Insert Query

Article View: de.comp.lang.php

Article #35

#35

From: Jose Luis
Date: Mon, 14 Aug 2000 00:00

15 lines
963 bytes

I do an Insert query of a table that like this:

CREATE TABLE name_table (
 id INT(20) NOT NULL AUTO_INCREMENT,
 name MEDIUMTEXT,
 PRIMARY KEY(id));

My query is:
   $query = "INSERT INTO name_table VALUES("'',FREDERIC ROSSELL")";
   $mysql_result = mysql_query($query, $mysql_link);

How i can know what is the value of field id of the new record.

--
Thanks. Jose Luis

Technical Details

Message-ID: <8n8kfk$es0$1@talia.mad.ttd.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f92b,da3288fad35d9984,start
X-Google-Attributes: gid10f92b,public
X-Google-Thread: 10ce1c,da3288fad35d9984,start
X-Google-Attributes: gid10ce1c,public
From: "Jose Luis" <joseluis@REMOVEMEferca.com>
Subject: Help Index Field of Insert Query
Date: 2000/08/14
Message-ID: <8n8kfk$es0$1@talia.mad.ttd.net>
X-Deja-AN: 658083908
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Organization: Telefonica Transmision de Datos
X-MSMail-Priority: Normal
Newsgroups: de.comp.lang.php,ba.php