[Resolved] Parse error

[slimjim]

Can anyone tell me why i keep getting an error when trying to install a table.
Error I am getting is this : Parse error: parse error, unexpected T_STRING in /home/virtual/site15/fst/var/www/html/test/install/tableinstall2.php on line 98
Line 98 is the $query

$query = "INSERT INTO paypalbutton1 (id, message) VALUES (1,'<br>\r\n<center>\r\nPurchase 1000 Impressions $10.00\r\n<form action="https://www.paypal.com/cgi-bin/webscr" method="post">\r\n<input type="hidden" name="cmd" value="_xclick">\r\n<input type="hidden" name="business" value="[e-mail]">\r\n<input type="hidden" name="undefined_quantity" value="1">\r\n<input type="hidden" name="item_name" value="1000 Impressions">\r\n<input type="hidden" name="item_number" value="1000 Impressions">\r\n<input type="hidden" name="amount" value="10.00">\r\n<input type="hidden" name="no_shipping" value="1">\r\n<input type="hidden" name="return" value="http://www.yoursite.com">\r\n<input type="hidden" name="cancel_return" value="http://www.yoursite.com">\r\n<input type="hidden" name="currency_code" value="USD">\r\n<table><tr><td><input type="hidden" name="on0" value="Campaign URL">Campaign URL</td><td><input type="text" name="os0" maxlength="200"></td></tr><tr><td><input type="hidden" name="on1" value="Your Member Name">Your Member Name</td><td><input type="text" name="os1" maxlength="200"></td></tr></table><input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-butcc.gif" border="0" name="submit" alt="Make payments with PayPal - it\'s fast, free and secure!">\r\n</form>\r\n</center>')";
mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");

[Merve]

Put backslashes before the quotation marks inside the brackets after VALUES.

[slimjim]

After what Value ? I tried vaule=\ and that didnt work i still have same problem.

[Merve]

$query = "INSERT INTO paypalbutton1 (id, message) VALUES (1,'<br>\r\n<center>\r\nPurchase 1000 Impressions $10.00\r\n<form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\">\r\n<input type=\"hidden\" name=\"cmd\" value=\"_xclick\">\r\n<input type=\"hidden\" name=\"business\" value=\"[e-mail]\">\r\n<input type=\"hidden\" name=\"undefined_quantity\" value=\"1\">\r\n<input type=\"hidden\" name=\"item_name\" value=\"1000 Impressions\">\r\n<input type=\"hidden\" name=\"item_number\" value=\"1000 Impressions\">\r\n<input type=\"hidden\" name=\"amount\" value=\"10.00\">\r\n<input type=\"hidden\" name=\"no_shipping\" value=\"1\">\r\n<input type=\"hidden\" name=\"return\" value=\"http://www.yoursite.com\">\r\n<input type=\"hidden\" name=\"cancel_return\" value=\"http://www.yoursite.com\">\r\n<input type=\"hidden\" name=\"currency_code\" value=\"USD\">\r\n<table><tr><td><input type=\"hidden\" name=\"on0\" value=\"Campaign URL\">Campaign URL</td><td><input type=\"text\" name=\"os0\" maxlength=\"200\"></td></tr><tr><td><input type=\"hidden\" name=\"on1\" value=\"Your Member Name\">Your Member Name</td><td><input type=\"text\" name=\"os1\" maxlength=\"200\"></td></tr></table><input type=\"image\" src=\"https://www.paypal.com/en_US/i/btn/x-click-butcc.gif\" border=\"0\" name=\"submit\" alt=\"Make payments with PayPal - it\'s fast, free and secure!\">\r\n</form>\r\n</center>')";
mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");

Try this and see if it works.

[slimjim]

Well that worked. Not sure why but it did. But now i have another error :
ERROR: You have an error in your SQL syntax near '; ' at line 6

$server = "localhost";
$user = "username";
$password = "password";
$cid = mysql_connect ($server, $user, $password) or die("Database connection failed.");
$db = "Databasename";
mysql_select_db($db) or die("Database could not be selected.");
if (!$cid) { print "ERROR: " . mysql_error() . "\n"; }

[slimjim]

Figured it out. Problem was in it's : I needed to place a backward slash after the letter t in it's.

it\'s fast, free and secure

Thanks again everyone