MSSQL Insert query not working

[davidgl16]

Hi, just wondering if you could help where I have gone wrong, im pulling my hair out and cannot understand why it wont work (the variables come from the previous page via a form). Be kind ive only just started using php

Code:

<?php
session_start();
$cat = $GET[['cat'];
$var = $GET['var'];
$style = $GET['style'];
$price = $GET['price'];
$pid = $_SESSION['product'];

$Conn = mssql_connect("UADSDS01","sql0503401","B1r12-36") or die("Unable to connect to server");

$Db=mssql_select_db("sql0503401",$Conn);

$query = mssql_query("INSERT INTO product (cat, var, style, price) VALUES ('$cat', '$var', '$style', '$price' WHERE pid='$pid');

mssql_query($query) or die ('Error Updatating Database');

?>

Thanks

[ixalmida]

You didn't say where it was failing. Do you get any errors?

[dagon]

there's 2 syntax errors

$cat = $_GET[['cat'];

should be

$cat = $_GET['cat'];

$query = mssql_query("INSERT INTO product (cat, var, style, price) VALUES ('$cat', '$var', '$style', '$price' WHERE pid='$pid');

should be

$query = mssql_query("INSERT INTO product (cat, var, style, price) VALUES ('$cat', '$var', '$style', '$price' WHERE pid='$pid' ");

you should have error checking on them the php engine would tell you of the error

[dagon]

i don't know mssql but it looks like your missing a ")" also