i keep getting a Parse error: parse error, unexpected '\"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/gdnclan/public_html/cs/p/jaguar/index.php on line 120
$result = mysql_query("SELECT * FROM profile_jaguar order by id",$dbm);
if ($submit) {
// here if no ID then adding else we're editing
if ($id) {
$sql = "UPDATE profile_jaguar SET name='$name',position='$position',age='$age',sex='$sex',location='$location',email='$email',msn='$msn',site='$site',connection='$connection',weapon='$weapon',aliases='$aliases',experience='$experience',about='$about',1='$1',2='$2',3='$3',news='$news',flag='$flag']WHERE id=$id";
} else {
$sql = "INSERT INTO profile_jaguar (name,position,age,sex,location,email,msn,site,connection,weapon,aliases,experience,about,1,2,3,news,flag)
VALUES ('$name','$position','$age','$sex','$location','$email','$msn','$site','$connection','$weapon','$aliases','$experience','$about','$1','$2','$3','$news','$flag')";
}
// run SQL against the DB
$result = mysql_query($sql);
echo "Record updated/edited!<p>";
} elseif ($delete) {
// delete a record
$sql = "DELETE FROM profile_jaguar WHERE id=$id";
$result = mysql_query($sql);
echo "$sql Record deleted!<p>";
} else {
// this part happens if we don't press submit
if (!$id) {
// print the list if there is not editing
$result = mysql_query("SELECT * FROM profile_jaguar",$dbm);
while ($myrow = mysql_fetch_array($result)) {
printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PHP_SELF, $myrow["id"], $myrow["name"], $myrow["position"], $myrow["age"], $myrow["sex"], $myrow["location"], $myrow["email"], $myrow["msn"], $myrow["site"], $myrow["connection"], $myrow["weapon"], $myrow["aliases"], $myrow["experience"], $myrow["about"], $myrow["1"], $myrow["2"], $myrow["3"], $myrow["news"], $myrow["flag"]);
printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["id"]);
}
}
?>
<P>
<a href="<?php echo $PHP_SELF; ?>">ADD A RECORD</a>
<P>
<form method="post" action="<?php echo $PHP_SELF; ?>">
<?php
if ($id) {
// editing so select a record
$sql = "SELECT * FROM profile_jaguar WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["id"];
$name = $myrow["name"];
$position = $myrow["position"];
$age = $myrow["age"];
$sex = $myrow["sex"];
$location = $myrow["location"];
$email = $myrow["email"];
$msn = $myrow["msn"];
$site = $myrow["site"];
$connection = $myrow["connection"];
$weapon = $myrow["weapon"];
$aliases = $myrow["aliases"];
$experience = $myrow["experience"];
$about = "$myrow["about"]";
$1 = $myrow["1"]; <<<line 120
$2 = $myrow["2"];
$3 = $myrow["3"];
$flag = $myrow["flag"];
// print the id for editing
?>
<input type=hidden name="id" value="<?php echo $id; ?>">
<?php
}
?>
Name:<input type="Text" name="name" value="<?php echo $name ;?>"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
?>
Could anyone plz tell me wats wrong... thank u
