[SOLVED] MySQL Mess up...

[maxudaskin]

Can someone tellme why I get the following error?

 

Error: Unknown column 'OOM210' in 'field list'

 

$flightnumber is equal to OOM210...

 

(INSERT INTO and VALUES are on the same line, but here it is split so it is easier to compare.)

 

$sql = "INSERT INTO flights (flight_num, dept, dest, depticao, desticao, depttime, desttime, stops, duration, freq) 
VALUES ($flightnumber,$departure,$destination,$departurecity,$destinationcity,$departuretime,$arrivaltime,$stop,$duration,$freq)";
  if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

[trq]

Your values need to be surrounded by single quotes.

[maxudaskin]

Like this:

 

NSERT INTO flights ("flight_num, dept, dest, depticao, desticao, depttime, desttime, stops, duration, freq")

[micah1701]

because your values aren't in quotes.

its looking for a column named 00M210 not trying to save the value '00M210'

 

you need something like this:

"INSERT INTO flights (flight_num, dept, dest, depticao, desticao, depttime, desttime, stops, duration, freq)

VALUES ('$flightnumber','$departure','$destination','$departurecity','$destinationcity',

'$departuretime','$arrivaltime','$stop','$duration','$freq')";

[maxudaskin]

Thanx