MySQL easy syntax question - GoFuckYourself.com

Socks · 04-03-2009, 11:51 PM

update category_text set text='this is a problem because it's got an apostrophe in it', keywords='asdf,asdf' where id='1';

Just that the string I want to insert has an apostrophe.. Is that going to mess the syntax up?

jMEGA · 04-04-2009, 12:14 AM

try this

update category_text set text='this is a problem because it\'s got an apostrophe in it', keywords='asdf,asdf' where id='1';

Socks · 04-04-2009, 12:53 AM

Nice thanks!! Now I know why I've seen those things printed around my site sometimes heh

V_RocKs · 04-04-2009, 01:52 AM

google for php html entities

nation-x · 04-04-2009, 08:01 AM

if this is for a php script then you can just use http://us3.php.net/mysql_real_escape_string

Code:

$sql = "update category_text set text='".mysql_real_escape_string("this is a problem because it's got an apostrophe in it")."', keywords='asdf,asdf' where id='1';"

$affected_rows = mysql_query($sql);

04-03-2009, 11:51 PM	#1
Socks Confirmed User Industry Role: Join Date: May 2002 Location: Toronto Posts: 8,475	MySQL easy syntax question update category_text set text='this is a problem because it's got an apostrophe in it', keywords='asdf,asdf' where id='1'; Just that the string I want to insert has an apostrophe.. Is that going to mess the syntax up?

04-04-2009, 12:14 AM	#2
jMEGA Confirmed User Join Date: Oct 2005 Location: St. Louis, MO Posts: 671	try this update category_text set text='this is a problem because it\'s got an apostrophe in it', keywords='asdf,asdf' where id='1'; __________________ Design \| SEO \| Photo / Video Editing ( ICQ 49354667 )

04-04-2009, 08:01 AM	#5
nation-x Confirmed User Industry Role: Join Date: Mar 2004 Location: Rock Hill, SC Posts: 5,370	if this is for a php script then you can just use http://us3.php.net/mysql_real_escape_string Code: $sql = "update category_text set text='".mysql_real_escape_string("this is a problem because it's got an apostrophe in it")."', keywords='asdf,asdf' where id='1';" $affected_rows = mysql_query($sql); Last edited by nation-x; 04-04-2009 at 08:03 AM..

04-04-2009, 12:53 AM	#3
Socks Confirmed User Industry Role: Join Date: May 2002 Location: Toronto Posts: 8,475	Nice thanks!! Now I know why I've seen those things printed around my site sometimes heh

04-04-2009, 01:52 AM	#4
V_RocKs Damn Right I Kiss Ass! Industry Role: Join Date: Dec 2003 Location: Cowtown, USA Posts: 32,428	google for php html entities