Php mysql conditional syntax inside query

Question

$category = get_option('category');

// checks to see if subcategory is enabled in the option page  
if ( get_option('enable_subcategory') == 'y' ):   

  $subcategory = get_option('subcategory');

endif;

$qry = mysql_query("SELECT car,number FROM ".$table." 
                    WHERE category = '$category' AND subcategory = '$subcategory' 
                    ORDER BY RAND() LIMIT 20");

How can i write the $qry so the " AND subcategory = '$subcategory' " will disappear if subcategory option isn't enable?

Chad · Accepted Answer · 2010-11-09 18:22:17Z

2

Added $subSql var:

<?

  $category = get_option('category');

  if ( get_option('enable_subcategory') == 'y' ):   // checks to see if subcategory is enabled in the option page  

  $subcategory = get_option('subcategory');
  $subSql = "AND subcategory = '$subcategory'";

  endif;

  $qry = mysql_query("SELECT car,number FROM ".$table." WHERE category = '$category' $subSql ORDER BY RAND() LIMIT 20");

?>

answered Nov 9, 2010 at 18:22

Chad

2181 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

webmasters Over a year ago

This looks interesting, and if there is no value $subSql is empty, cool;)

spanky Over a year ago

You can do it without the extra variable if you drop the $subcategory line and change the next line to $subSql = "AND subcategory = '" . get_option('subcategory') . "'";

Your Common Sense Over a year ago

@webmasters not empty nor cool. To be empty, this variable should be defined first

Collectives™ on Stack Overflow

Php mysql conditional syntax inside query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related