RE: [PHP-WIN] SQL and ROWID
| From: | Martin Verstegen | Date: | Thu, 19 Oct 2000 22:17:18 +0000 |
| Subject: | RE: [PHP-WIN] SQL and ROWID | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-3396@lists.php.net to get a copy of this message | ||
No, I don't use an autoincrement column. I'am looking for a unique
identifier that is not represented by a column. But maby it's not an SQL
habbit. Maby I better use the autoincrement column you mentioned to uniquely
identify a row with just 1 column.
Martin Verstegen
2FIT
-----Original Message-----
From: Flint Doungchak [mailto:Flint@netsolutionsllc.com]
Sent: Friday, October 20, 2000 12:03 AM
To: 'Martin Verstegen'; Php-Windows-Help
Subject: RE: [PHP-WIN] SQL and ROWID
Assuming you're using MSSQL you can use the
SELECT @@IDENTITY
to get the identity of an autoincrement column. In MySQL there is a function
called:
mysql_insert_id();
Hope that helps.
-Flint
-----Original Message-----
From: Martin Verstegen [mailto:martinv@wxs.nl]
Sent: Thursday, October 19, 2000 2:36 PM
To: Php-Windows-Help
Subject: [PHP-WIN] SQL and ROWID
I used to work with Progress. In Progress it's possible to retrieve a rowid
from a row. It's a sort of unique number of that row. Can I retrieve
something like that from an SQL row?
If yes, how do I retrieve that rowid and after that how can I select the
same row using that rowid.
Greetinx,
Martin verstegen
2FIT