the corect sintax

[ta2shop]

hy guys, i am playng with the browser identification thing, and i want to add some data to a DB, but a dont want to define everi thing in a new $var haw can i add the values in using just the $_POST['thing']; thing?
thanks.

$query = mysql_query("INSERT INTO brovsers VALUES('','$_POST['1']','$_POST['2']','$_POST['2']')") or die(mysql_error());

[jacek]

Easiest way is to wrap them in {} like this ...

$query = mysql_query("INSERT INTO brovsers VALUES('','{$_POST['1']}','{$_POST['2']}','{$_POST['2']}')") OR die(mysql_error());

Bare in mine though that these variables need to be escaped

[ta2shop]

Easiest way is to wrap them in {} like this ...

$query = mysql_query("INSERT INTO brovsers VALUES('','{$_POST['1']}','{$_POST['2']}','{$_POST['2']}')") OR die(mysql_error());

Bare in mine though that these variables need to be escaped

like so?

$query = mysql_query("INSERT INTO brovsers VALUES('','{$_POST['\1\']}','{$_POST['\2\']}','{$_POST['\2\']}')") OR die(mysql_error())

[jacek]

There is no need for the \ but yeah pretty much like that.

[ta2shop]

ok, now i get it, one last thing, i now that to add the ip i need to do this $_SERVER['REMOTE_ADDR']; but how can i add the date(); thing to this query?
thanks

EDIT* all done, fixed.