When constructing $Query, end each line with a period (.) not a comma(,).
Same applies to $Query2.
$Query = "INSERT into $TableName values('0', '$Guestbook[dateadd]'.
'$Guestbook[name]', '$Guestbook[town]', '$Guestbook[email]'.
'$Guestbook[website]','$Guestbook[favsong]', '$Guestbook[comments]')";
$Query2 = "INSERT into $TableName2 values('0', '$Guestbook[dateadd]'.
'$Guestbook[name]', '$Guestbook[email]');
----- Original Message -----
From: Jule <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 12:48 PM
Subject: [PHP] parse error
Hey guys, i'm writing this guestbook script for my site, and i'm getting a
random parse error where i think everything is normal, it gives it on line
26
which is
echo "Your entry will be posted!";
my script follows
Jule
--SCRIPT--
<?php
$Guestbook["dateadd"] = date("F j, Y H:i:s");
$Guestbook["name"] = trim($Guestbook["name"]);
$Guestbook["town"] = trim($Guestbook["town"]);
$Guestbook["email"] = trim($Guestbook["email"]);
$Guestbook["website"] = trim($Guestbook["website"]);
$Guestbook["favsong"] = trim($Guestbook["favsong"]);
$Guestbook["comments"] = trim($Guestbook["comments"]);
$Guestbook["mailinglist"] = trim($Guestbook["mailinglist"]);
$Host = "localhost";
$User = "****";
$Password = "*********";
$DBName = "blindtheory";
$TableName = "guestbook";
$TableName2 = "mailinglist";
$Pattern = ".+@.+..+";
$Pattern2 = "(http://)?([^[:space:]]+)([[:alnum:]\.,-_?/&=])";
$Link = mysql_connect ($Host, $User, $Password);
$Query = "INSERT into $TableName values('0', '$Guestbook[dateadd]',
'$Guestbook[name]', '$Guestbook[town]', '$Guestbook[email]',
'$Guestbook[website]','$Guestbook[favsong]', '$Guestbook[comments]')";
$Link2 = mysql_connect ($Host, $User, $Password);
$Query2 = "INSERT into $TableName2 values('0', '$Guestbook[dateadd]',
'$Guestbook[name]', '$Guestbook[email]');
if (mysql_db_query ($DBName, $Query, $Link)) {
echo "Your entry will be added";
} else {
echo "There was an error in during the posting, please contact <a
href=\"mailto:[EMAIL PROTECTED]\";>me</a> and I will fix the
problem.<br>";
}
if (isset($Guestbook[mailinglist])) {
if (mysql_db_query ($DBName, $Query2, $Link2)) {
echo "Your e-mail address was sucessfully added to our mailinglist";
} else {
echo "There was an error in during the posting, please contact <a
href=\"mailto:[EMAIL PROTECTED]\";>me</a> and I will fix the
problem.<br>";
}
}
mysql_close ($Link);
mysql_close ($Link2);
?>
--
Jule Slootbeek
[EMAIL PROTECTED]
http://blindtheory.cjb.net
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
