I need to do a few things with the code attached. Section I is mandatory, Section II is optional.
Under Section I
1) Limit the number of results displayed. For example, only show 8 results. I've tried LIMIT 1, 8 however it doesn't work. Also, possibly adding the ability of Next 8 Prev 8.
2) I need to be able to list these results by either random order or by a certain field in the database. If you want to provide with with two sets of code, that's fine.
Under Section II (Optional)
1) I'd like to have an image (resized) to be used as a thumbnail when it's uploaded. Not sure if that can be implimented in the code?
Any questions, let me know. Thanks.