need help, please

Evan_Morgan

right well its giving me an error that i dont understand
Here is my code

<?
include('dbconnect.php');
//process

$team1 = $POST['team1'];
$team2 = $POST['team2'];
$odds1 = $POST['odds1'];
$odds2 = $POST['odds2'];
$oddsdraw = $POST['oddsdraw'];
$title = $POST['title'];

print "$team1 are playing $team2 with $team1 at home and $team2 away.<br>";
print "$team1 are priced at $odds1 and $team2 are priced at $odds2, a draw is priced at $oddsdraw.<br>";
print "You have given this game the title $title.";

mysql_query("INSERT INTO matches ( team1, team2, odds1, odds2, oddsdraw, title )
VALUES( $team1, $team2, $odds1, $odds2, $oddsdraw, $title )")
or die( "doesnt work because ".mysql_error());

?>

and if i input manchester utd as the home team in this form

</head>

Title of game : <input type='text' name='title'><br>
Team 1 : <input type='text' name='team1'> decimal odds : <input type='text' name='odds1'><br>
Team 2 : <input type='text' name='team2'> decimal odds : <input type='text' name='odds2'><br>
Draw odds : <input type='text' name='oddsdraw'><br>
<input type='submit'>

</form>
</font>
</div>
</body>

</html>

I get this error 'doesnt work because Unknown column 'manchester utd' in 'field list''

What have i done 🙁

Evan_Morgan

this is the url of the form

here

thanks

yelvington

Whenever you encounter this sort of problem, debug it by echoing the query string and examining it closely.

Are you using backticks where you should be using single quotes?

Are you quoting values that should not be quoted? Or vice versa? (Pay close attention to data type.)

pseudonym

I see backticks (probably generated by PHPmyadmin) in that insert statement.

Try rewriting it 🙂

mysql_query("
INSERT INTO matches 
SET
team1 ='$team1',
team2 = '$team2'.
odds1  = '$odds1',
odds2 = '$odds2',
oddsdraw = '$oddsdraw',
title = '$title'
") 
or die( "doesnt work because ".mysql_error());

Also, are you escaping any data?? Does your server use gpc_magic_quotes=on ? 🙂