What's wrong with this?

[Johnathan]

Code: Select all

<?php
$con = mysql_connect("rdbms.strato.de","*******","********");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("DB407820", $con);
mysql_query("INSERT INTO favicon (faviconURL, siteURL, email)
VALUES
('$_POST[faviconURL]','$_POST[siteURL]','$_POST[email]')";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Your Favicon has been added, refresh the page to see it.";
mysql_close($con)
?>

I get this, "Parse error: syntax error, unexpected ';' in /mnt/web2/43/79/51648779/htdocs/JBP/favicon/submit_favicon.php on line 18"

Then I take the ";" so I end up with this:

Code: Select all

<?php
$con = mysql_connect("rdbms.strato.de","U407820","thomas02");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("DB407820", $con);
mysql_query("INSERT INTO favicon (faviconURL, siteURL, email)
VALUES
('$_POST[faviconURL]','$_POST[siteURL]','$_POST[email]')"
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Your Favicon has been added, refresh the page to see it.";
mysql_close($con)
?>


And get this "Parse error: syntax error, unexpected T_IF in /mnt/web2/43/79/51648779/htdocs/JBP/favicon/submit_favicon.php on line 19".
You can see the form and what happens here... http://www.jbportal.net/favicon/favicon.php

Any ideas???

[webmaster]

Try putting a ";" after this row

Code: Select all

('$_POST[faviconURL]','$_POST[siteURL]','$_POST[email]')"

[Johnathan]

Yea, that's what it was at the start but I got an error, the first one in my post. Thanks for the help anyway.

[willyamPax]

try putting a semicolon like below
mysql_close($con);
and u lack ) try this
mysql_query("INSERT INTO favicon (faviconURL, siteURL, email)
VALUES
('$_POST[faviconURL]','$_POST[siteURL]','$_POST[email]')");

[npsari]

I would say the right code should be as you have it at the top

So anyway, Perhaps the php code is reacting to another issue on the page

Perhaps you have an extra } or {