Can you insert defined() constant into database?

[DamienRoche]

I'm having trouble inserting constant into database.

 

Here are the relevant lines:

 

define("IP", clean($_SERVER['REMOTE_ADDR']));

 

mysql_query("INSERT INTO sessions (user,ip,sid) VALUES ('$user','IP','$sid')") or die(mysql_error());

 

Obviously, it is insert 'IP' into database and not the constant value. Is there a way around this....

 

on a more important note - with the use being evident - am I going about this the wrong way?

 

Thanks.

[Cal]

try this:

 

mysql_query("INSERT INTO sessions (user,ip,sid) VALUES ('$user','" . IP . "','$sid')") or die(mysql_error());

[wildteen88]

PHP does not parse constants within strings, you'll have to concatenate it

mysql_query("INSERT INTO sessions (user,ip,sid) VALUES ('$user','".IP."','$sid')") or die(mysql_error());

[DamienRoche]

PHP does not parse constants within strings, you'll have to concatenate it

mysql_query("INSERT INTO sessions (user,ip,sid) VALUES ('$user','".IP."','$sid')") or die(mysql_error());

 

I thought that was concatenating it. Could you elaborate?

 

Thanks for the help.

[Cal]

Yes what he wrote was the concenated version.