Update into MySQL problem!

[CyCloneNL]

Hi,

I need to make a problem registration system, in PHP. I really dont much about PHP, i just started. Luckly, i knew some javascript so variable's are no problems.

Now i got the registration just fine, check it out here:
This one is working perfectly.

But i also needed to build a status system in it. So the employees can accept a problem, or discard it. So my solution was to make a new row in the database, and call that status. Then in my PHP do an IF statement on it. Like this:

<? php
if ($rows['status']=="1") //if status equals 1
echo "Nog niet aangenomen";  //say not yet accepted (its dutch :))
elseif ($rows['status']=="2") //If status equals 2
echo "In behandeling";  //say accepted
else 
echo "Geen status"; //else say no status
?> 

But that isnt working, i get this error when i include it in the code:

Parse error: parse error, unexpected T_IF in /home/www/regsys.freehostia.com/beheer.php on line 56

So i just deleted that part, and concentrated on the status change.

Now what i need is a button that updates the content of the row status, for only one entry.
Like this:
Status=1 //in mysql
(click button) //in php
Status=2 //in mysql

And it would be nice if that if else thing would work too 😉

[matt72]

The if statements aren't working because of something in the code above them. Most likely you're missing a semi-colon ; at the end of the line above...

Hope this helps.

[CyCloneNL]

errhm... i dont see the problem in this:

<td>ID</td>
<td>:</td>
<td><? echo $rows['id']; ?></td>
</tr>
<tr>
<td width="117">Name</td>
<td width="14">:</td>
<td width="357"><? echo $rows['naam']; ?></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><? echo $rows['email']; ?></td>
</tr>
<tr>
<td>Lokaal</td>
<td>:</td>
<td><? echo $rows['lokaal']; ?></td>
</tr>
<tr>
<td valign="top">Probleem</td>
<td valign="top">:</td>
<td><? echo $rows['probleem']; ?></td>
</tr>
<tr>
<td valign="top">Datum/Tijd:</td>
<td valign="top">:</td>
<td><? echo $rows['datetime']; ?></td>
<tr>
<td>Status</td>
<td>:</td>
<td>
<? php
if ($rows['status']=="1"); //if status equals 1
echo "Nog niet aangenomen";  //say not yet accepted (its dutch :))
elseif ($rows['status']=="2"); //If status equals 2
echo "In behandeling";  //say accepted
else
echo "Geen status"; //else say no status
?>

[cahva]

Actually you are not missing a semicolon, you have extra semicolon there:

if ($rows['status']=="1");

Take off that semicolon from all those if's and else's from the end and it will work. Dont use semicolon at the end in if(also for, while etc.)

[CyCloneNL]

<? php 
if ($rows['status']=="1")
echo "Nog niet aangenomen";
elseif ($rows['status']=="2")
echo "In behandeling";
else 
echo "Geen status";
?> 

Still not working..

[cahva]

Well that is not working because you have space " " after <?
its now <? php
it should be <?php

Do I hear DOH! 😉

[nemonoman]

Get used to using braces -- these solve many problems:
]

<?php
if ($rows['status']=="1"){
     echo "Nog niet aangenomen";
}
elseif ($rows['status']=="2"){
   echo "In behandeling";
}
else {
   echo "Geen status";
}
?>