CodingForums.com - View Single Post - Random function limited to the first 10 ID's of db, must take 10 random from entireDB

Old Pedant · 01-15-2013, 10:01 PM

Ummm...NEITHER is your "Top jokes by vote" working, if the code you are showing there is all you have.

Your SQL query *ALWAYS* does

Code:

ORDER BY emailed_value desc, rating_value DESC

so the emailed_value is the first seen and will override the rating_value.

I think you will have to show your HTML page where the user requests one of those 3 selections. You are clearly not interacting between the PHP code and the HTML request from the user.

If you can show a live URL, that woudl be easiest.

01-15-2013, 10:01 PM	PM User \| #5
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,168 Thanks: 59 Thanked 3,993 Times in 3,962 Posts	Ummm...NEITHER is your "Top jokes by vote" working, if the code you are showing there is all you have. Your SQL query ALWAYS does Code: ORDER BY emailed_value desc, rating_value DESC so the emailed_value is the first seen and will override the rating_value. I think you will have to show your HTML page where the user requests one of those 3 selections. You are clearly not interacting between the PHP code and the HTML request from the user. If you can show a live URL, that woudl be easiest. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.