incrementing

[Anon]

Hi--
I'm new at this and I have a pretty straight forward question:

How do I select the first item in a MySql db column without knowing what the item is?

thanks in advance
-j

[Anon]

Just do a select and it'll be the first one.

[kparker]

I'm not exactly sure what "first item in a column" means--can you clarify and/or give a brief example?

[Anon]

I have db lets say its like this:

image | title | prmaryKey(int auto_incremented)

image1 | title1 | 7
image2 | title2 | 22

I wrote 7 and 22 for the pkeys becuase I'm dealing with numbers that are incremented but not sequential (due to deletions). I use the pkeys to display the info. For instnace this link 'link.php?7' would be used to display image1 and title1, based on the query_string. If I need to create links like this on the fly though, how can I know which is the first number used? In other words how can I know to write 'link.php?7' instead of 'link.php?6' since pkey=6 has already been deleted.

(sorry if I'm not explaining myself well-- basically I just need someway to grab the first row of information without knowing anything specific about that row. If there is some sort of WHERE condition that specifies the lowest integer that would be perfect)