MSSQL error: Invalid pseudocolumn "$_POST"

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mjkomidar
Forum Newbie
Posts: 10
Joined: Wed Dec 30, 2009 9:59 am

MSSQL error: Invalid pseudocolumn "$_POST"

Post by mjkomidar »

When running the follow script/SQL query, I get --> MSSQL error: Invalid pseudocolumn "$_POST"


$server = '***';

$connect = mssql_connect($server, 'sa', '***');

mssql_select_db('db_jobs', $connect);

$sql = 'INSERT INTO tbl_jobs VALUES
(
$_POST["id"],
$_POST["company"],
$_POST["location"],
$_POST["title"],
$_POST["desc"],
$_POST["exper"],
$_POST["edu"],
$_POST["link"]
)';

$query = mssql_query($sql);

if (!$query)
{
die('MSSQL error: ' . mssql_get_last_message());
}


What is the problem?
User avatar
daedalus__
DevNet Resident
Posts: 1925
Joined: Thu Feb 09, 2006 4:52 pm

Re: MSSQL error: Invalid pseudocolumn "$_POST"

Post by daedalus__ »

if you dont use code tags the jacka is gonna strangle you in your sleep

Code: Select all

$sql = [b]"[/b]INSERT INTO tbl_jobs VALUES
(
$_POST["id"],
$_POST["company"],
$_POST["location"],
$_POST["title"],
$_POST["desc"],
$_POST["exper"],
$_POST["edu"],
$_POST["link"]
)[b]"[/b];
mjkomidar
Forum Newbie
Posts: 10
Joined: Wed Dec 30, 2009 9:59 am

Re: MSSQL error: Invalid pseudocolumn "$_POST"

Post by mjkomidar »

huh???
Post Reply