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, 09:34 PM

By the by, you could write the condition stuff much simpler:

Code:

$condition = " WHERE validate = 1 AND slng = " $slng ; // assuming slng is a number
if(isset($cat_id) && $cat_id != 0) 
{
    $condition .= " AND category_id=" . $cat_id ;
}
$SQL = "select * from $database_table_name2 " . $condition . " ORDER BY rand() LIMIT 10";

Though you should be sanitizing that $cat_id to make sure it really is a number, to protect against SQL injection.

01-15-2013, 09:34 PM	PM User \| #3
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,237 Thanks: 59 Thanked 3,998 Times in 3,967 Posts	By the by, you could write the condition stuff much simpler: Code: $condition = " WHERE validate = 1 AND slng = " $slng ; // assuming slng is a number if(isset($cat_id) && $cat_id != 0) { $condition .= " AND category_id=" . $cat_id ; } $SQL = "select * from $database_table_name2 " . $condition . " ORDER BY rand() LIMIT 10"; Though you should be sanitizing that $cat_id to make sure it really is a number, to protect against SQL injection. __________________ 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.