PHP - Php If Command Not Working When Returning A Value

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

Hi I am new to php,  I am trying to capture the url and place into a variable but I only get the 1st digit to show,  I just cant see what I am doing wrong. 

Sorry to ask such a basic question but I just can't work it out,  I have attached a screen shot of all me code, your help would be very very much appreciated.

I have a shoutbox my friend made, and I'm just adding onto it.

I have command that are like @prune, @prunelogs, @logout, etc.. I am tying to make it so you can type @ban username, @unban username, etc..

Here is my command that my friend came up with.
if($_POST['text'] == '@ban'.$username.'') {
$unn=$idk['username'];
mysql_query("UPDATE users SET banned = '1' WHERE usernane='$unn'") or die(mysql_error());
mysql_query("INSERT INTO chat (`log`, `date` ,`username` ,`text`) VALUES (1, NOW( ) , '".stripslashes($_SESSION['user'])."', 'has banned '$unn'.');") or die(mysql_error());

I have created a tar file with my site backup and I assume it is the full backup.  Not sure becasue I can't "un"-tar the file.

I have tried several ways to "unzip" or untar the file but can not come up with anything.


here is how I had created the tar file:
Code: [Select]
$date = date("m-d-Y");

// repeat this command for multiple backups, changing the path - e.g. you can have a backup for email, another for files, etc.
shell_exec("tar cvfz file_backup_$date.tar.gz mydir/ ");

now how do extract it?