1
zite83
MySQL and quotes
  • 2006/9/27 19:57

  • zite83

  • Just popping in

  • Posts: 41

  • Since: 2004/10/5


I understand that quotes can stop a MySQL statment. I was wondering whats the propper way to get arround this issue.

Lets say I have this
le="color: #000000"><?php $variable= "The boat's color is red" ; $Query = "INSERT INTO ".$xoopsDB->prefix("some_table")." (variable) VALUES ('$variable'); $Insert = $xoopsDB->query($Query);


I was wondering how I can insert that text into MySQL with out altering it so the query statment dosn't fail.

Thanks

Login

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Aug 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!