[thelist] undefined index error - PHP and MySQL

[Jeffrey Barke]

Ron,

No problem. I was poking around a bit more, and this is from the  
PHP.net site:
mysql_insert_id() converts the return type of the native MySQL C API  
function mysql_insert_id() to a type of long (named int in PHP). If  
your AUTO_INCREMENT column has a column type of BIGINT, the value  
returned by mysql_insert_id()  will be incorrect. Instead, use the  
internal MySQL SQL function LAST_INSERT_ID() in an SQL query.

Jeffrey

--
Cheers.
Jeffrey Barke
jeffery.barke at theMechanism.com
Lead Developer, US
theMechanism - New York City
440 9th Avenue, 8th Floor
New York, NY 10001-1631
t: +1 212.404.3150
c: +1 917.941.1232
f: +1 212.404.3228



http://www.theMechanism.com

Subscribe to theMechcast, our monthly Podcast:
http://feeds.feedburner.com/theMechcast

theMechanism - London
3rd Floor
405 The Strand
London E14 9FW
United Kingdom
t: +44 (0)20 7240 4942
f: +44 (0)20 7240 2262

--
The information contained in this Electronic mail message is attorney  
privileged and confidential information intended only for the use of  
the individual or entity named above. Such information also is  
intended to be privileged, confidential, and exempt from disclosure  
under applicable law. If the reader of this message is not the  
intended recipient or the employee or agent responsible to deliver it  
to the intended recipient, you are hereby notified that any  
dissemination, distribution, or copying of this communication is  
strictly prohibited. If you have received this communication in  
error, please notify us immediately by telephone.

Blah, blah, blah...
--


On May 7, 2007, at 4:15 PM, Pringle, Ron wrote:

> Jeffrey-
>
> Ah thank you. I was overcomplicating things as usual. I did look at  
> mysql_insert_id but apparently didn't understand its use.
>
> regards,
> Ron
>
>
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Jeffrey Barke
> Sent: Monday, May 07, 2007 2:47 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] undefined index error - PHP and MySQL
>
>
> try:
> mysql_query(insert statement here);
> $histID = mysql_insert_id();
> echo '<p>History ID is: ' . $histID . '</p>';
>
> Jeffrey
>
> --
> Cheers.
> Jeffrey Barke
> jeffery.barke at theMechanism.com
> Lead Developer, US
> theMechanism - New York City
> 440 9th Avenue, 8th Floor
> New York, NY 10001-1631
> t: +1 212.404.3150
> c: +1 917.941.1232
> f: +1 212.404.3228
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !