www/upl_styles.php

changeset 778
e64fd38c469c
parent 311
f6fafccd8a6d
child 785
aa79acfdf8a9
equal deleted inserted replaced
777:daf55c944fb0 778:e64fd38c469c
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

mercurial