Fetching one row

Anon

Ok I want to retrieve a row depending on the user id. As of now I have always just fetched, printed, etc. in one group so it was never a problem, but now I want them to be able to edit their information. I have their userID stored as $userid and I cant' figure out which would be the correct function to use to retrieve just their row of data which would be $userid-1. If you could help it would be much appreciated.
-Mark Harris

lawnmowerman

I take it you are asking how to structure the SQL statement to only return the row where $userid = 1.

This is actually quite simple,

SELECT * FROM Table WHERE UserIdentification = $userid;

That should do it...of course you have to put your table name and column name in there.

Hope this helps!

-Rich

Anon

You will probably benefit a lot by spending some time learning SQL.

One tutorial can be found at:

http://w3.one.net/~jhoffman/sqltut.htm

Anon

Actually, there is no standard SQL method to "fetch" one row.

Remember, hstmt still has all the rows even if you only call SQLFetch() once unless you destroy the rest

Microsoft SQL Server 2000 : SELECT TOP 1 * FROM x

MySQL : SELECT * FROM x LIMIT 1 (Not sure about that, but its close)