PHP question. Please take a look and see if you can help

[kjhkjh]

Hi All,

I've created a new table (eg/ 'LS_newtable') on my vB database and in it I have a single field (eg/ 'newfield')

I have entered 100 values under the 'newfield' and what I need to do is display these values at random wherever I insert a bit of code.

My problem is that I don't know what bit of code to insert :disappointed:

I guess that it will be a code similar to below. But what would the direct path to this field be? And how can I make the result be random from this field?

<?php
print("$newfield");
>

The final thing that I would like is that if the field doesn't have any entries (so if I take out the 100 values that I've put in) then I would like to have the code print the message "sorry but no value available!"

All help is always appreciated.

Thanks

i've just added an incremental id number for another column in the table. I think that there must be a way to use this to help create the random bit and then provide the corresponding value from row 2.

any help?