codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Mysql statement as variable (if – else)

    23rd October 2014

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
     
    if ($showmonth == "on") {
    $dog = "SELECT name FROM targets WHERE name ='codehaven'";
    }
    else {
    $dog = "SELECT name FROM targets WHERE name ='mike'";
    }
     
    //the query ($dog is in it!)
     
    $result = mysql_query($dog);
     
    while($row = mysql_fetch_array($result))
      {
    $whatever = $row['whatever'];
    }
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN