Page 1 of 1

Updating a table doesn't work please help

Posted: Sat Nov 02, 2002 1:05 pm
by Skywalker
It gives me an error on line 5 but i don't know what went wrong?


<?php require_once('Connections/Verbinding.php'); ?>

<?php
$ID = $_GET['ID']
$Naam = $_GET['Naam']
$AchterNM = $_GET['AchterNM'];
$WNPlaats = $_GET['WNplaats'];
$Post = $_GET['Post'];
$Straat = $_GET['Straat'];
$Studie = $_GET['Studie'];
$Email = $_GET['Email'];
$Username = $_GET['Username'];
$Password = $_GET['Password'];
$Blok = $_GET['Blok'];
$Table = $_GET['Table'];

$Host = "localhost"
$Gebruiker = "blabla"
$Wachtwoord = "blabla"
$DBNaam = "studiecoach"

$Connectie = mysql_connect ($Host, $Gebruiker, $Wachtwoord);

$Opdracht = "Update $Table ID= $ID, Naam=$Naam, AchterNM=$AchterNM, WNPlaats=$WNPlaats, Post=$Post, Straat=$Straat, Studie=$Studie, Email=$Email, Username=$Username, Password=$Password, Blok=$Blok";
$Result = mysql_db_query ($DBNaam, $Opdracht, $Connectie);
echo ("<font face=\"verdana\" size=\"2\"><b>Gebruiker wordt geblokeerd een ongenblik geduld AUB</b> <META HTTP-EQUIV=\"refresh\" content=\"8;URL=admin.php\"><br>\n");

?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#CCCCFF">
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Posted: Mon Nov 04, 2002 2:04 am
by twigletmac
You've not bothered adding a lot of semi-colons, try putting one ( ; ) at the end of each of these lines:

Code: Select all

$ID = $_GET&#1111;'ID'] 
$Naam = $_GET&#1111;'Naam']

Code: Select all

$Host = "localhost" 
$Gebruiker = "blabla" 
$Wachtwoord = "blabla" 
$DBNaam = "studiecoach"
Mac