Replace Into

[samsbc12]

I am trying

 

if ($REQUEST_METHOD=="POST")

  {

    mysql_query('REPLACE INTO info_comments (Id, Text, isOn) VALUES (1, "'.mysql_escape_string($aboutus).'", $isOn)')

          or die(mysql_error());

  }

a

but I get error

 

Unknown column '$isOn' in 'field list'

 

any ideas

[bubblegum.anarchy]

Pretty much just switch the double and single quotes.

 

settype($isOn, "integer");

mysql_query($query = "
    REPLACE INTO info_comments (Id, Text, isOn) 
    VALUES (1, '".mysql_escape_string($aboutus)."', {$isOn})") or trigger_error(mysql_error()."<PRE>".$query."</PRE>", E_USER_ERROR);