home version mysql is not the same commercial version mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gphp
Forum Commoner
Posts: 29
Joined: Sun Feb 17, 2008 1:40 pm

home version mysql is not the same commercial version mysql

Post by gphp »

Would anyone know how much difference is between the single/home version MySQL and the commercial version?
I can make something to work on my home version MySql but once I put same text out there it generates an error!
Thanks.
:roll:
here is the problem:

Code: Select all

 
$message_d = $post['message'];
 
$message_d      nwo` how to' figure/ out '\this proble/`    - failed, raw message
 
                let's call these $10/sh to $15/sh           - failed, did not like the ' single quote
//----------------------------------------------------------------------------
 
$message = str_replace("'", "\'", "$message_d");        - taken from the $post above
 
$message        nwo` how to' figure/ out '\this proble/`        - passed even with the quotes
 
                nwo` how to' figure/ out '\this proble/`\'\`    - failed, end slashes with quotes
 
                let's call these $10/sh to $15/sh       - passed, but it does not pass on commercial version of MySql
 
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: home version mysql is not the same commercial version mysql

Post by josh »

Sounds like PHP has magic quotes enabled
Post Reply