54 $sql = "INSERT INTO profile_styles SET name='" . mysqli_real_escape_string($db, $style->NAME); |
54 $sql = "INSERT INTO profile_styles SET name='" . mysqli_real_escape_string($db, $style->NAME); |
55 if ($style->NOTES) |
55 if ($style->NOTES) |
56 $sql .= "', notes='" . mysqli_real_escape_string($db, $style->NOTES); |
56 $sql .= "', notes='" . mysqli_real_escape_string($db, $style->NOTES); |
57 if ($style->CATEGORY) |
57 if ($style->CATEGORY) |
58 $sql .= "', category='" . mysqli_real_escape_string($db, $style->CATEGORY); |
58 $sql .= "', category='" . mysqli_real_escape_string($db, $style->CATEGORY); |
59 if ($style->CATEGORY_NUMBER) |
59 if ($style->CATEGORY_NUMBER) { |
60 $sql .= "', category_number='" . $style->CATEGORY_NUMBER; |
60 if (strlen($style->CATEGORY_NUMBER)) |
|
61 $sql .= "', category_number='" . $style->CATEGORY_NUMBER; |
|
62 else |
|
63 $sql .= "', category_number='0"; |
|
64 } |
61 if ($style->STYLE_LETTER) |
65 if ($style->STYLE_LETTER) |
62 $sql .= "', style_letter='" . mysqli_real_escape_string($db, $style->STYLE_LETTER); |
66 $sql .= "', style_letter='" . mysqli_real_escape_string($db, $style->STYLE_LETTER); |
63 if ($style->STYLE_GUIDE) |
67 if ($style->STYLE_GUIDE) |
64 $sql .= "', style_guide='" . mysqli_real_escape_string($db, $style->STYLE_GUIDE); |
68 $sql .= "', style_guide='" . mysqli_real_escape_string($db, $style->STYLE_GUIDE); |
65 |
69 |