PHP - Variable Not Changing For Dns Update Command

Hi all,
I need to create a button my page that when clicked will update my mysql table.
I also need a command that will find 3 'x' values and update them accordingly,

It needs to update the theme column in my model pictures table, Would something similiar like this work?
Code: [Select]
UPDATE theme
SET name = '5'
WHERE name = '1 or 2 or 4';[code]

Does this make sense?

Hello people,

At the moment I am really desperate. I've done this script over 20 times now, always with the same script but all of a suddon, it doesn't work anymore. heres the problem:

I made a very simple "patient database" for a doctor. Where he can upload patients, alter and delete them. The script to add the patients works fine. now im trying to make a script where he can alter the variables agian, using the UPDATE command. but instead of updating the variables it cleares all the date in the row.

can someone help me? here s the entire code:


Code: [Select]
<?PHP
include'connect.php';
?>
            <?PHP
$SQL = mysql_query("SELECT * FROM leys_patienten WHERE patientid='".$_REQUEST['patientid']."'");
while ($row = mysql_fetch_array($SQL))
{
?>
        <?PHP
if ($_POST[submit]) {
if (!$_POST[volgnummer]) {
echo "<font size=\"2\" color=\"#990000\"><b>--> Vul een volgnummer in a.u.b. <--</b></font>";
}
elseif (!$_POST[naam])
{
echo "<font size=\"2\" color=\"#990000\"><b>--> Vul een naam in a.u.b. <--</b></font>";
}
elseif (!$_POST[voornaam])
{
echo "<font size=\"2\" color=\"#990000\"><b>--> Vul een voornaam in a.u.b.! <--</b></font>";
}
else {

mysql_query("UPDATE leys_patienten SET volgnummer='$volgnummer',naam='$naam',voornaam='$voornaam',adres='$adres',postcode='$postcode',plaats='$plaats',telefoon='$telefoon',email='$email',geboortedatum='$geboortedatum',geboorteplaats='$geboorteplaats',opmerkingen='$opmerkingen' WHERE patientid='".$_REQUEST['patientid']."'")
or die(mysql_error());

echo "Het patientendossier is succesvol gewijzigd, let op doorschakeling.";?>
        <meta http-equiv="Refresh" content="1; url=patient.php?patientid=<?PHP echo $row['patientid']?>" />
        <?
}
}
?></p>

      <form action="<?$PHP_SELF?>" method="post" name="post" id="post">
        <table width="805" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td class="table_forms">Volgnummer*</td>
            <td class="table_forms"><label><input name="volgnummer" type="text" id="volgnummer" value="<?PHP echo $row['volgnummer']?>" size="40" /></label></td>
          </tr>
          <tr>
            <td width="146" class="table_forms">Naam*</td>
            <td width="659" class="table_forms"><label><input name="naam" type="text" id="naam" value="<?PHP echo $row['naam']?>" size="40" /></label></td>
          </tr>
          <tr>
            <td class="table_forms">Voornaam*</td>
            <td class="table_forms"><font color="#FFFFFF" size="2">
              <label><input name="voornaam" type="text" id="voornaam" value="<?PHP echo $row['voornaam']?>" size="40" /></label>
            </font></td>
          </tr>
          <tr>
            <td class="table_forms">Adres </td>
            <td><font color="#FFFFFF" size="2">
              <label><input name="adres" type="text" id="adres" value="<?PHP echo $row['adres']?>" size="40" /></label>
            </font></td>
          </tr>
          <tr>
            <td class="table_forms">Postcode</td>
            <td><font color="#FFFFFF" size="2">
             <label><input name="postcode" type="text" id="postcode" value="<?PHP echo $row['postcode']?>" size="6" /></label>
            </font></td>
          </tr>
          <tr>
            <td class="table_forms">Plaats</td>
            <td><font color="#FFFFFF" size="2">
              <label><input name="plaats" type="text" id="plaats" value="<?PHP echo $row['plaats']?>" size="40" /></label>
            </font></td>
          </tr>
          <tr>
            <td class="table_forms">Telefoon</td>
            <td><font color="#FFFFFF" size="2">
              <label><input name="telefoon" type="text" id="telefoon" value="<?PHP echo $row['telefoon']?>" size="40" /></label>
            </font></td>
          </tr>
          <tr>
            <td class="table_forms">E-mail</td>
            <td><font color="#FFFFFF" size="2">
              <label><input name="email" type="text" id="email" value="<?PHP echo $row['email']?>" size="40" /></label>
            </font></td>
          </tr>
          <tr>
            <td class="table_forms">Geboortedatum</td>
            <td><font color="#FFFFFF" size="2">
              <label><input name="geboortedatum" type="text" id="geboortedatum" value="<?PHP echo $row['geboortedatum']?>" size="40" /></label>
            </font></td>
          </tr>
          <tr>
            <td class="table_forms">Geboorteplaats</td>
            <td><font color="#FFFFFF" size="2">
              <label><input name="geboorteplaats" type="text" id="geboorteplaats" value="<?PHP echo $row['geboorteplaats']?>" size="40" /></label>
            </font></td>
          </tr>
          <tr>
            <td valign="top" class="table_forms">Opmerkingen</td>
            <td><font color="#FFFFFF" size="2">
              <label><textarea name="opmerkingen" cols="40" rows="4" id="opmerkingen"><?PHP echo $row['opmerkingen']?></textarea></label>
            </font></td>
          </tr>
          <tr>
            <td valign="top" class="table_forms">&nbsp;</td>
            <td><span class="body_tekst">
              <input type="submit" id="submit" name="submit" value="verstuur" />
            </span></td>
          </tr>
        </table>
        <p class="body_tekst">&nbsp;</p>
      </form>
  <?
}
  ?>

This is the weirdest thing ever. I've been programming php for years yet I have been pulling my hair out for hours over something that seems so simple!

I have a table in my db named last_num_used with 2 fields: id, num which are both type int.
It only has one row, so I don't need to use WHERE to update

when I execute the command via php:
Code: [Select]
$sql = "UPDATE last_num SET num='4'";
echo $sql;
if (!mysql_query($sql)) {die('Error: ' . mysql_error());}everything works fine and I see the echoed command UPDATE last_num SET num='4'

But, when I have a variable $var and try to update it, it will only update properly if $var=1 or $var=2. If $var equals a value greater than 2, then for some reason it updates the column so that num=1. Note the exact problem in example 3 below.

Example 1:
Code: [Select]
$var=1;
$sql = "UPDATE last_num SET num='$var'";
echo $sql;
if (!mysql_query($sql)) {die('Error: ' . mysql_error());}Result:   echoed to screen: UPDATE last_num SET num='1'
      database updated and num=1


Example 2:
Code: [Select]
$var=2;
$sql = "UPDATE last_num SET num='$var'";
echo $sql;
if (!mysql_query($sql)) {die('Error: ' . mysql_error());}Result:   echoed to screen: UPDATE last_num SET num='2'
      database updated and num=2


Example 3:
Code: [Select]
$var=3;
$sql = "UPDATE last_num SET num='$var'";
echo $sql;
if (!mysql_query($sql)) {die('Error: ' . mysql_error());}Result:   echoed to screen: UPDATE last_num SET num='3'
      database updated and num=1

I am a bit rusty with mySQL and I tried to borrow some other query code and modify it into an update command...apparently I am trying to use an invalid property in my error checking.

Basically I just want to check and see if there were NO rows updated so I can let the user no that nothing was changed.  There are probably easier ways to do this? 

The page where I set the variable values is based on a form post.  I am not sure how to write my validation tests.  Right now it is running the update successfully but it is reporting back an error based on hitting the "else if" test where I am trying to see if no rows were updated. 

The error message is: Quote

Encountered error: 8 in /home/omgma/public_html/member_community/mbr_profiles/mbr_profile_updt_post.php, line 85: Trying to get property of non-object
No fields were updated!

Error: 0


Code: [Select]
//create a SQL statement
$updt_cmd = "UPDATE users t1, directory t2 "
."SET t1.email = '$email', "
."t2.first_name='$first_name', "
."t2.last_name='$last_name', "
."t2.suffix='$suffix', "
."t2.website_url='$website_url' "
."WHERE t1.username ='$username' AND t2.directory_id = t1.directory_id";

$conn = db_connect();

$result = $conn->query($updt_cmd);
if (!$result)
{//could not execute query
  throw new Exception('<h2>Could not execute member profile update!</h2><p>Error: '
.mysqli_errno($conn)
.mysqli_error($conn)
.'</p>' );
}
else if ($result->num_rows==0)
{// no rows so nothing was updated. 
  throw new Exception('<h2>No fields were updated! </h2><p>Error: '
.mysqli_errno($conn)
.mysqli_error($conn)
.'</p>' );
}
else
{
  $mbr_profile = $result->fetch_object();
  print_r($mbr_profile);
  return $mbr_profile;
}



Am I using the right functions here to do this and if so where can I find the class properties to use to test if nothing was updated?

Thanks

I typically only use the first two solutions.  Is there anything wrong with the third?  Is there any more streamlined way to do it?

function f1($x){return $x*1;}
function f2($x){return $x*1;}

$x=2;$y=1;

if(f1($x)>f2($y)){echo(f2($y)."\n");}

// or

$f2_y=f2($y);
if(f1($x)>$f2_y){echo($f2_y."\n");}

// or

if(f1($x)>$f2_y=f2($y)){echo($f2_y."\n");}