Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Old 01-15-2004, 12:33 AM   #1 (permalink)
Epsilon
Regular Contributor
 
Epsilon's Avatar
 
Join Date: Mar 2003
Location: Las Vegas, NV
Posts: 131
Epsilon is on a distinguished road
Magic Quotes

Okay, PHP is enabled with Magic Quotes (so you don't have to escape funky characters in MySQL data). Works perfectly fine with an INSERT statement, doesn't work at all with an UPDATE statement. I still have to use addslashes() when updating a MySQL row. Is this normal or am I missing something?
__________________
--Epsilon--
Epsilon is offline   Reply With Quote
Old 01-15-2004, 07:49 PM   #2 (permalink)
Admin
$_['Your_Mom'];
 
Admin's Avatar
 
Join Date: May 2002
Location: Santee
Posts: 627
Admin is on a distinguished road
that seems rather odd. i never have to do that.
__________________


Urban Clothing
Admin is offline   Reply With Quote
Old 01-16-2004, 07:52 PM   #3 (permalink)
bdl
Senior Contributor
 
Join Date: May 2002
Location: vta.ca.usa
Posts: 555
bdl is on a distinguished road
Bizarre. Where does the data going into the UPDATE query come from? I would assume a form similar to the data that's going in the first time around?

From what I've read, it's a good idea to turn off magic_quotes_gpc anyway and always manually use addslashes() or mysql_escape_string() on your data.
bdl is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macintosh Quotes? Admin PHP 5 06-04-2004 04:47 PM
Double quotes in fwrite NirTivAal PHP 8 12-08-2003 09:13 AM
magic the gathering Hrqls Lounge 26 01-19-2003 03:33 PM


All times are GMT -8. The time now is 02:09 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting