XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / MySQL and quotes
Register
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
$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

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

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