UPDATE MySQL data via web forms?

Randy · 05-06-2009, 11:41 PM

So i am working on a CMS for a certain genre of websites, not much detail is needed but I am having some issues. I am trying to make it for that they can update the website details from a php page and for some reason it wont update the database..

Form/PHP:

PHP Code:


			
            <?php



                if (isset($_POST['submit'])) {



                            // Define Variables

                            $websitename = $_POST['websitename'];

                            $tagline = $_POST['tagline'];

                            $websiteurl = $_POST['websiteurl'];

                            $contactemail = $_POST['contactemail'];

                            

                        // Attempt To Update

                        $update = mysql_query"UPDATE settings SET `sitename` = '$websitename' ") or die(mysql_error());

                            if(mysql_num_rows($update) > 0

                                {

                                        echo 'SUCCESS';

                                }

                            else

                                {

                                        echo 'FAILZOR';

                                }

                        

                } else {

            ?>

              <form action="" method="POST" id="settings" name="settings ">

                Website Name: <br />

                <label class="mediumInput">

                  <input name="websitename" id="websitename" type="text" size="75" />

                  </label>

                <br />

                <small>This will show up in the tab bar in your browser and all over the website.</small>

                <p>Tagline (Description): <br />

                  <label class="textareasmall">

                    <textarea name="tagline"  id="tagline" rows="2" cols="5"></textarea>

                  </label>

                <br />

                <small>This will show up on search engines under the name and will give a basic description of your website.</small></p>

                <p>Website URL: <br />

                  <label  class="mediumInput">

                    <input type="text" name="websiteurl" id="websiteurl" size="75"/>

                  </label>

                  <br />

                  <small>This is the URL to where you have this installed, It is recommend you do not change unless you know what you are doing.</small></p>

                <p>Contact Email: <br />

                  <label class="mediumInput">

                    <input name="contactemail" id="contactemail" type="text" size="75" />

                  </label>

                <br />

                <small>This is where emails will be sent to when contact form is used, as well as when emails are sent out.</small></p>

                <p>

            <input name="submit" id="submit" type="image" src="../images/bt_submit.gif" />

                  </p>

              </form>

              <?php

                }

                ?>

I have updated the entire file here:
http://pastie.org/470648
PHP for Form starts on line: 170

Im not sure why its not updating, i know all my variables are right. I don't receive any errors at all, I hit submit and it just reloads the page and removes all entered text on the input