take second value from an array ?

[sheepsheep]

I want to find the second value in an array.....

I have a mysql table containing DateLogs

I know what the datelog is for this week, but I want to find out what the previous datelog is

$query = "SELECT DateLogId FROM tblDateLog WHERE CRef = $CRef ORDER BY EndDate DESC LIMIT 2";

gives me the most recent datelog, but I want to know what the second datelog in this array is........

how do I do this?

[laserlight]

Take the second element of the array, of course.

[sheepsheep]

thanks for your reply
but if I knew how to take the second element of the array, I wouldn't be posting here - more clues needed - thanks

[laserlight]

Well, how are you getting the first element of the array? Kindly show more code.

[NogDog]

I believe this query would just give you just the second one:

$query = "SELECT DateLogId FROM tblDateLog WHERE CRef = $CRef ORDER BY EndDate DESC LIMIT 1, 1";