bewerk.php-> need help soz for 2nd topic

izdesign

2005-07-05 18:53:52

Parse error: parse error, unexpected $ in /home/httpd/vhosts/izdesign.nl/httpdocs/bewerk.php on line 53

kan iemand me hierbij helpen?

Groeten ivo

<?php
error_reporting(E_ALL);
$database ="mijndb";
$server ="localhost";
$user ="mijndb1";
$wachtwoord ="mijndb2";
mysql_connect("$server","$user", "$wachtwoord");
mysql_select_db("$database");

if(isset($_POST['bevestiging'])){
$query = "UPDATE gastenboek SET
naam = '". $_POST['naam'] ."',
email = '". $_POST['email'] ."',
bericht = '". $_POST['bericht'] ."',
WHERE id=" .$_POST['id'];

$result =mysql_query($query) or die(mysql_error());
echo "Opdracht is uitgevoerd.";
if($result){
echo "Deze post is bijgewerkt";
}
}else{
$query = "SELECT * FROM gastenboek WHERE id=" .$_GET['id'];
$result = mysql_query($query) or die(mysql_error());
?>
<html>
<head>
<title>Bewerk gbook.php</title>
</head>
<body>
<?php
while($row = mysql_fetch_array($result)){
$naam = $row['naam'];
$email = $row['email'];
$bericht = $row['bericht'];
}
?>
<form action="<?php $PHP_SELF ?>" method="post">
<input type="hidden" name="bevestiging" value="1">
<input type="hidden" name="id" value="<?php echo($_GET['id']);?>">
<table width=250 border="0" cellspacing="0" cellpadding="2" bordercolor="#000000">
<tr><td>Naam:</td></tr>
<tr><td><input type="text" name="naam" value="<?php echo ("$naam"); ?>" size="15"></td></tr><br>
<tr><td>E-Mail:</td></tr>
<tr><td><input type="text" name="email" value="<?php echo ("$email"); ?>" size="15"></td></tr><br>
<tr><td>Bericht:</td></tr>
<tr><td><textarea name="bericht" rows="4" cols="40"><?php echo ("$bericht"); ?></textarea></td></tr>
<tr><td><input type="Submit" value="Bijwerken" size="15"></td></tr>
</table>
</form>
</body>
</html>

jacob_slomp

2005-07-05 19:22:05

op het einde moet je nog <? } ?> doen.

izdesign

2005-07-05 19:47:33

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id=6' at line 5

Wat moet ik hiermee??

jacob_slomp

2005-07-05 22:25:57

$query = "UPDATE gastenboek SET
naam = '". $_POST['naam'] ."',
email = '". $_POST['email'] ."',
bericht = '". $_POST['bericht'] ."',
WHERE id=" .$_POST['id'];
moet worden:
$query = "UPDATE gastenboek SET
naam = '". $_POST['naam'] ."',
email = '". $_POST['email'] ."',
bericht = '". $_POST['bericht'] ."'
WHERE id=" .$_POST['id'];

izdesign

2005-07-06 15:37:06

Hartstikke bedankt :D:D:D:D