Ah-hah. The problem is with how I'm trying to print the array elements.

 

If I use "print" it just outputs "Array". print_r prints the content, but does it like this:

 

Array ( [0] => The service was excellent. [text] => The service was excellent. )

 

How on earth do i just get the bit of text I need out of it?! This shit was so easy in QBASIC :(

(just a note: that will result in an array of arrays. i.e. $hooray will be an array containing arrays containing the result elements. So the first element of the first result will be at $hooray[0][0], second element of the first result at $hooray[0][1] and first element of the second result at $hooray[1][0] and so on)

It's not my solution, but it works perfectly.

As above. I think fetch_array produces both an indexed and an associative array (or one which acts as both, I dunno (and they might not be the right words)).

So you can do either:

$hooray[0]['text'] or $hooray[0][0]

They will point to the same thing.

Tis, cos you made me look at it. But you failed to adjust it to fit my exact requirements.

(hug)

 

Thank you! That was the vital bit of information that I couldn't be bothered getting my huge, and severely out of date, PHP book down off the shelf for (kiss)

If you're simply taking 6 results with one field each then it's just $array[0][0] to $array[5][0]

You didn't hire me to fit it to your exact requirements.

Yay, it's all working now, I think I can forget about it now.

 

Pete: It was implied.

(cheer)