IF or CASE statement inside INSERT

[ddtpmyra]

What is the syntax of inserting a value on a table with CASE statement or IF stmt.
I have PHP form that holds the value, now I wanted to skip the insert value if the text box value is null but I dont know the correct syntax

"insert into table1 (id, category)
values
IF ($cat1 <> null) THEN
({$id}, '{$cat1}'), 
ENDIF
IF ($cat2 <> null) THEN
({$id}, '{$cat1}'), 
ENDIF";

OR

 
$query = "INSERT  
WHEN $cat1 <> null then INTO table1 (Cal_ID,DateStamp,Category,Total) VALUES ({$id},NOW(),'{$cat1}',{$Totalcat1}) 
WHEN $cat2 <> null then INTO table1  (Cal_ID,DateStamp,Category,Total) VALUES ({$id},NOW(),'{$cat2}',null);	";

how can i do this correctly?

[prabirchoudhury]

1. check the submitted variables before executing the insert statement.

2. if ($_POST[cat] !='null') { then execute the insert statement }

3. or if ($cat !='null') { then execute the insert statement }

4.

    if ($cat1 !='null') { 
       $sql  = "INSERT INTO table1 (id, category) ";
            
      $sql .= " ({$id}, '{$cat1}')";
      mysql_query($sql);
      }

:)

[ddtpmyra]

I have too many variables like 20 of them, and I wanted to put the insert query all together, is ther a way to make the if condition locally or after the insert statement?

1. check the submitted variables before executing the insert statement.

2. if ($_POST[cat] !='null') { then execute the insert statement }

3. or if ($cat !='null') { then execute the insert statement }

4.

    if ($cat1 !='null') { 
       $sql  = "INSERT INTO table1 (id, category) ";
            
      $sql .= " ({$id}, '{$cat1}')";
      mysql_query($sql);
      }

:)

[prabirchoudhury]

IF or CASE statement inside INSERT

1. put your cat list in an array
2. and then put this array in an for each loop , check the "null" values with if statement and then inside the if statement execute the sql

$cat_arr = array ();


foreach ($arr as $key => $value) {

if (check null){inser statement}

}

may be this would be helpful foreach

[ddtpmyra]

Grazie Prabirchoudhury (whew what a name)

smile!

1. put your cat list in an array
2. and then put this array in an for each loop , check the "null" values with if statement and then inside the if statement execute the sql

$cat_arr = array ();


foreach ($arr as $key => $value) {

if (check null){inser statement}

}

may be this would be helpful foreach

[prabirchoudhury]

thanks .. glad that works .. enjoy coding :)