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 could happen)
So if I do a search on the data I just inserted, I could get two or
more hits, and there would be no way for me to tell which one is the
one Im after.

Im new to both php and sql, but I keep thinking things like this must
be done every day on thousands of sites. I just cant figure out how to
do it, any suggestions?

What I do, when I need to reference an ID from a sequence after I do the
INSERT, is I get the next number in the sequence /before/ inserting the data
into the table, like so:

$res = pg_query($conn, "select nextval('my_seq');");
$row = pg_fetch_array($res);
$id = $row['nextval'];
$res = pg_query($conn, "insert into my_table values ($id, 'value',
//Error checking here...
echo "Your submission was accepted with ID $id";

Since you are just getting the next value of the sequence, your data is safe
from having non-unique id numbers, as long as you always call nextval() in
order to get your id number. Any subsequent calls to nextval() will return
the next number, regardless of whether you use the $id returned by the first

Hope that helps.

Nathaniel Price http://www.thornvalley.com
"Who is General Failure and why is he reading my hard drive?"

For future reference, here is the code snippet that finally worked for me:
$res = pg_query($connection, "select nextval('public.logs_log_id_seq'::text);");

$row = pg_fetch_array($res);
$log_id = $row['nextval'];

$query = "insert into logs values ($log_id,$id,'$logtext','now','$_SERVER[PHP_AUTH_USER]');";
$result = pg_query($connection, $query) or die("Error in query: $query. " .pg_last_error($connection));

The data is stored, and the counter value is saved in $log_id and available for use.

Thanks to all those that helped!


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to