Thanks, but nothing I insert from the suggestions seems to matter. The site isn't responding to the php I input or just returns errors if I venture out of the syntax above. I've spent about a week trying to figure this out now. My only guess is that I need to include more code to get the desired results.
I'm beginning to think mysql wants my soul for a trade...
Oh, I left out I'm working with a ready made db and php script so I'm sure this has alot to do with the problem now that I think about it. I'm either leaving something out that's necessary or filling in the fields wrong. I copy and paste what's been put here and when the code doesn't work as is, I try replacing certain words, etc.
The db script in the connect php looks like this: if (DB_CONNECT == 1) return; define("DB_CONNECT",1); and then follows with a series of $Const_ <--covers everything from layout formatting to database setup. Instead of including the root URL all the time I can just fill in $Const_URL/members instead of
http://blah/members, etc.
The members table is fragmented instead of everything related being placed there. There are seperate tables for member pics, secondary profile info, and a mini version of member profiles (what the search results return and the data I'm trying to randomize/top 10 on the index). Don't know if this is relevant or not, but there is also a php file for functions.
I'm so lost. I'll never knock a programmer as long as I live. This work is as draining as any job.