Greg,
If you know a piece to key from you can get any piece you want. For example,
if you know the ID you're looking for is 3, and you want the first name in
record 3, use:
select firstname
from [tablename]
where ID = 3
this query would return 'tom'
Tony Gruen
[EMAIL PROTECTED]
-Original M
Do you really want to see what's in row 2, column 2, or do you want to see
what ID(3)'s First Name is? That seems much more useful.
To do that you just use
SELECT FirstName from TableName
WHERE ID = 3
#test.firstname#
If you really want to access fields by row and column nu
You can create whatever WHERE statement you wish to select whatever rows you
need from the DB
to get row 2, column 2:
SELECT password
FROM table
WHERE ID = 3
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
3 matches
Mail list logo