The commas were inside the string enclosed by "". If changed to periods,
that would create a SQL error.
miguel
On Tue, 30 Apr 2002, Richard Emery wrote:
> 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
