PHP Parse error: syntax error, unexpected ')' on line 10

[yakoup46]

Here is my code I cannot find the fu**ing unexpected ')'

Maybe I have just been looking at code to much today but I really don't see it. HELP!

 

<?php

$mysql_host = "mysql6.000webhost.com";

$mysql_database = "a1091112_values";

$mysql_user = "a1091112_values";

$mysql_password = "yakoup46";

 

$con = mysql_connect($mysql_host, $mysql_user, $mysql_password) or die ('Error connecting to mysql');

mysql_select_db($mysql_database);

 

if(isset($_POST['buttonsumofodds']) || $_POST['inputbox1']))

{

$sql="INSERT INTO Sumofodds VALUES ('$_POST[inputbox1]')";

 

if($_POST[inputbox1] != -144)

echo "Sorry Wrong!";

else

echo "Correct!";

}

 

if(isset($_POST['buttonsumofchain']) || $_POST['inputbox3']))

{

$sql="INSERT INTO Sumofchain VALUES ('$_POST[inputbox3]')";

 

if($_POST[inputbox3] != 820)

echo "Sorry Wrong!";

else

echo "Correct!";

}

 

if(isset($_POST['buttonsumofsquares']) || $_POST['inputbox2']))

{

$sql="INSERT INTO Sumofsquares VALUES ('$_POST[inputbox2]')";

 

if($_POST[inputbox2] != 2870)

echo "Sorry Wrong!";

else

echo "Correct!";

}

 

if(isset($_POST['buttonsumofprimes']) || $_POST['inputbox5']))

{

$sql="INSERT INTO Sumofprimes VALUES ('$_POST[inputbox5]')";

 

if($_POST[inputbox5] != 1060)

echo "Sorry Wrong!";

else

echo "Correct!";

}

 

if(isset($_POST['buttonsumofdifference']) || $_POST['inputbox4']))

{

$sql="INSERT INTO Diffofsums VALUES ('$_POST[inputbox4]')";

 

if($_POST[inputbox4] != -144)

echo "Sorry Wrong!";

else

echo "Correct!";

}

 

echo '<br>Redirecting...';

echo '<META HTTP-EQUIV="Refresh" Content="1; URL=http://luta.comuv.com/Easy/easy.html">';

 

if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

 

mysql_close($con)

?>

[Deoctor]

dude u have a typo error..

 

if(isset($_POST['buttonsumofodds']) || $_POST['inputbox1']))

 

change this to

if(isset($_POST['buttonsumofodds']) || $_POST['inputbox1'])

 

 

and also

if(isset($_POST['buttonsumofchain']) || $_POST['inputbox3']))

 

this too

if(isset($_POST['buttonsumofchain']) || $_POST['inputbox3'])

 

as well as

if(isset($_POST['buttonsumofsquares']) || $_POST['inputbox2']))

these too

if(isset($_POST['buttonsumofsquares']) || $_POST['inputbox2'])

from

if(isset($_POST['buttonsumofprimes']) || $_POST['inputbox5']))

to

if(isset($_POST['buttonsumofprimes']) || $_POST['inputbox5'])

 

from

if(isset($_POST['buttonsumofdifference']) || $_POST['inputbox4']))

to

if(isset($_POST['buttonsumofdifference']) || $_POST['inputbox4'])

[andrewgauger]

You probably wont believe this, but it is on line 10, the last )

[yakoup46]

I did as you said ym_chaitu but now I am getting...

 

Error: Column count doesn't match value count at row 1

[TeddyKiller]

dude u have a typo error..

Nice spotting, that made me laugh with all them

[yakoup46]

I'm not sure I get it? :-\

[TeddyKiller]

It was a bit of humour about ym_chaitu's response.

As for your problem.. are you able to identify the query thats offending? It seems hard as they all nearly look the same.

[TeddyKiller]

Although I just noticed.

$sql="INSERT INTO Sumofodds VALUES ('$_POST[inputbox1]')";

These aren't qurys, these are strings. Maybe try a format like..

$sql = mysql_query(" blah blah here ");

[Deoctor]

I'm not sure I get it? :-\

as per ur errors it looks like the tables columns into which u are entering are not matching.

check ur database and see whether u have all the tables with these columns in which u are inserting..

[Deoctor]

Although I just noticed.

$sql="INSERT INTO Sumofodds VALUES ('$_POST[inputbox1]')";

These aren't qurys, these are strings. Maybe try a format like..

$sql = mysql_query(" blah blah here ");

 

he is running the query at the end..

 

if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

[yakoup46]

Tried that and now I am getting a Query is Empty Error! LOL

 

$sql = mysql_query(" blah blah here ");

[yakoup46]

GOT IT!

 

$sql="INSERT INTO Sumofodds (Column) VALUES ('$_POST[inputbox1]')";

 

I only had one column in my database so I figured I didn't have to include the column name but I do.

Thank you for all the help.

[TeddyKiller]

he is running the query at the end..

 

if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

Yeah I saw that.. I thought that only checks if the query didn't succeed.