I'm no 'expert' (opening myself up for much criticism here) but try the

(I'm assuming you are setting $fid somewhere)

 if (empty($form_status))
    $staff = $_POST["staff"];
    $ttlpst = $_POST["ttlpst"];
    $mnthpst = $_POST["mnthpst"];
    $ttlicon = $_POST["ttlicon"];
    $mnthicon = $_POST["mnthicon"];

    $exists = "SELECT * FROM badges WHERE fid = $fid";
    $result = mysql_query($exists) or die("Query1 failed: ".mysql_error());
    if (mysql_num_rows($result) == 0)
      $sql = "INSERT INTO badges
      VALUES ('$fid','$staff','$ttlpst','$mnthpst','$ttlicon','$mnthicon')";
      echo "Insert query = $sql";
      mysql_query($sql) or die("Query2 failed: ".mysql_error());
      $form_status = "<span class=\"msgUpdated\">Description
      $sql = "UPDATE badges
              SET staff = '$staff'
                  ttlpst ='$ttlpst'
                  mnthpst = '$mnthpst'
                  ttlicon = '$ttlicon'
                  mnthicon = '$mnthicon'
              WHERE fid = $fid";
      echo "Update query = $sql";
      mysql_query($sql) or die("Query3 failed: ".mysql_error());
      $form_status = "<span class=\"msgUpdated\">Description

The echos will at least show the SQL being executed which could give a clue
to the problem.

You could even just set the $sql within the if...else... and use the same
mysql_query($sql) for both instances:

if (condition1)
    $sql = "query statement 1";
    $sql = "query statement 2";



> -----Original Message-----
> From: Matthew Kiehne [mailto:[EMAIL PROTECTED]
> Sent: 12 October 2004 21:09
> Subject: [PHP-DB] DB will INSERT wont UPDATE..error in code?
> forgive the poor structure of my code, im pretty new at this and havent
> figured out exactly what it should be formed like to look its best, anyway
> whenever i run this code it works on inserting new information into the
> database, however when i want to update the SQL query returns an
> output like
> this 'SQL statement = UPDATE badges
> (staff,ttlpst,mnthpst,ttlicon,mnthicon)
> VALUES ('1','1','1','/ribbons','/ribbons') WHERE fid=2' but when i try to
> pull the information from the database it hasnt updated, can
> someone help me
> out with this...im not sure why it wouldnt update even though the
> statement
> looks correct.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to