unknown parse error

[Ph47f3]

I get a strange parse error in the following lines.
Can anyone see what I don't.

//Query the Database
$query = "SELECT type FROM `map`
WHERE map_file = " . $_SESSION['new_map'] . "
AND col = " . $_SESSION['new_col'] . "
AND row = " . $_SESSION['new_row']
$db_result = mysql_query($query);
$db_cell_type = mysql_fetch_array($result);

Any help is greatly appreciated.

[rostik]

"Ph47f3" <bt**@snowhill.com> wrote in message
news:14**************************@posting.google.c om...

I get a strange parse error in the following lines.
Can anyone see what I don't.

file://Query the Database
$query = "SELECT type FROM `map`
WHERE map_file = " . $_SESSION['new_map'] . "
AND col = " . $_SESSION['new_col'] . "
AND row = " . $_SESSION['new_row']
$db_result = mysql_query($query);
$db_cell_type = mysql_fetch_array($result);

You forget to write ';' at the end of AND row = " .
$_SESSION['new_row']

--
Wishes, Rostik Kerey

[Jay Moore]

Ph47f3 wrote:

I get a strange parse error in the following lines.
Can anyone see what I don't.

//Query the Database
$query = "SELECT type FROM `map`
WHERE map_file = " . $_SESSION['new_map'] . "
AND col = " . $_SESSION['new_col'] . "
AND row = " . $_SESSION['new_row']
$db_result = mysql_query($query);
$db_cell_type = mysql_fetch_array($result);

Any help is greatly appreciated.

I betcha you're getting an "Unknown column 'x'" error, right? Try
surrounding your variables in quotes like so:

$query = "SELECT type from `map`
WHERE map_file = '$_SESSION[new_map]'
AND col = '$_SESSION[new_col]'
AND row = '$_SESSION[new_row]'";

-Jay