Fetch xth item from mysql_array

Hey gentlebeings,

I'm pretty sure this is possible, just can't find the correct way to do it.

I want to select the contents of my table of testimonials, and randomly display one of them on the screen.

So the thinking we had over here was to count the number of rows and then select the xth row for display. We just weren't sure on the options available to us. :)

One option was to count the rows, use that number for the basis for a random select (i.e. mt_rand(1,$num_testimonials)) and select that row.

Just not sure if that would work at all...

If I recall correctly, fetching an associative array will allow us to move forward and backwards through it, so somehow this should be possible.

I'm open to all suggestions, can't even think of a way to start this.

Thanks,

Ray

re: Fetch xth item from mysql_array

Duh!

Sorry people, the answer was so obvious it slapped us in the face!

Works like a charm!

Ray

(figures we should have just spoken to the sql guru rather than the php guru)

re: Fetch xth item from mysql_array

Glad you got that sorted.