per_changeit.php script

Hmm.. nu har jeg ikke lige bogen. Men du kunne vel prøve at paste din per_changeit.php ?

hvad mener du????
cypermann

Præcis hvilken linie har du problemer med?

den har ikke "$ID" med


$sql="UPDATE personal SET name='$name', address='$address', town='$town', country='$country' WHERE ID='$ID'";

Du havde ikke overvejet at give os nogle flere oplysninger vel?

Jeg mener bare at du eventuelt kunne vises os indholdet i per_changeit.php :)

<HTML>
<BODY>
<?php
# per_changeit.php

# include file
include ("test_holding_inc.php");
$name=(urldecode($name));

$error=false;
if ( $name == "" ) {
$error=true;
echo "Name needs to be filled in<BR>";
}
if ( $address == "" ) {
echo "Address needs to be filled in<BR>";
$error=true;
}

if ( $town == "" ) {
echo "Town needs to be filled in<BR>";
$error=true;
}
if ($error) {
echo "All fields have to be filled in, re-select the record";
echo "<BR><A HREF=\"per_amend.php\"> Back</A>";
exit;
}
$sql="UPDATE personal SET name='$name', address='$address', town='$town', country='$country' WHERE ID='$ID'";

if (!mysql_query($sql,$connection)) {
echo "Error cannot Amend record<BR>";
echo "<BR><A HREF=\"per_amend.php\"> Back</A>";
  exit;
  } else {
# amend OK inform user
echo "Table updated [".mysql_affected_rows()."] record amended<BR>";
    echo "The record of <B>$name</B> has been amended";
}

echo "<BR><A HREF=\"per_amend.php\"> Back</A>";
mysql_close($connection);
?>
</BODY>
</HTML>

Hmm... hvad med siden per_amend.php ? eller hvor det nu er du sætter dine variabler ?

jeg har selv løs problemmet