Code Forums - View Single Post

morpheuz · 02-19-2005, 12:40 AM

For top 10 I was meaning profiles themselves turning up as results on the index page automatically, but that would mean there would be some kind of rating function in place wouldn't it?

The random 10 script is fine, but at what part of the string do I insert the db fields exactly and would the appropriate query be to return the results by mem_userid?

Here's two sites I could dig up showing what I'm talking about. I saw a msgboard like this that blew both away but I can't remember the url. >_<

anywho, http://www.webdate.com
http://www.datingsoftware.biz/demo

*EDIT

The string you provided was dead on, the tbl name for users is members; however, when I inserted the query in index.php nothing happened when I saved the file and reloaded the site. Comments?

02-19-2005, 12:40 AM	#6 (permalink)
morpheuz Code Monkey Join Date: Feb 2005 Posts: 64	For top 10 I was meaning profiles themselves turning up as results on the index page automatically, but that would mean there would be some kind of rating function in place wouldn't it? The random 10 script is fine, but at what part of the string do I insert the db fields exactly and would the appropriate query be to return the results by mem_userid? Here's two sites I could dig up showing what I'm talking about. I saw a msgboard like this that blew both away but I can't remember the url. >_< anywho, http://www.webdate.com http://www.datingsoftware.biz/demo EDIT The string you provided was dead on, the tbl name for users is members; however, when I inserted the query in index.php nothing happened when I saved the file and reloaded the site. Comments? Last edited by morpheuz; 02-19-2005 at 04:56 AM.*