Re: [PHP-DB] getting serial in PHP

2003-03-31 Thread Rick Morris
On Mon, 31 Mar 2003, Roger 'Rocky' Vetterberg wrote: > [Snip] > > > >>About the second suggestion, just pulling the data back out; I could > >>do that, but the only thing that is unique in the string is the > >>timestamp. Theoretically, on a busy site even that could be identical > >>in two rows

Re: [PHP-DB] getting serial in PHP

2003-03-31 Thread Roger 'Rocky' Vetterberg
[Snip] About the second suggestion, just pulling the data back out; I could do that, but the only thing that is unique in the string is the timestamp. Theoretically, on a busy site even that could be identical in two rows. (Since timestamp is in one millionth of a second, its not very likely but

Re: [PHP-DB] getting serial in PHP

2003-03-31 Thread Roger 'Rocky' Vetterberg
Nathaniel Price wrote: - Original Message - From: "Roger 'Rocky' Vetterberg" <[EMAIL PROTECTED]> To: "kevin myers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 31, 2003 4:52 AM Subject: Re: [PHP-DB] getting serial in PHP *

Re: [PHP-DB] getting serial in PHP

2003-03-31 Thread Nathaniel Price
- Original Message - From: "Roger 'Rocky' Vetterberg" <[EMAIL PROTECTED]> To: "kevin myers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 31, 2003 4:52 AM Subject: Re: [PHP-DB] getting serial in PHP [snip] > >> Fro

Re: [PHP-DB] getting serial in PHP

2003-03-31 Thread Roger 'Rocky' Vetterberg
kevin myers wrote: well right after you insert it you can pull it right back out again, or i think you can do : $query = "insert into logs values ((nextval('public.logs_log_id_seq'::text) as $log_id),$id,'$logtext','now','$_SERVER[PHP_AUTH_USER]');"; and then use it that way, or maybe you can do