You need to escape your strings.
> INSERT into mybtd(co_pe) values('Johsua\'s Brother'); cannot run...
[EMAIL PROTECTED] wrote:
>
> Dear sir;
> I have find a big error from MySQL. I have one fields like that;
> co_na(Fields) = Johsua's Brother;
> mybtd is the data name, co_na is the fields;
> I cannot insert the data by using the php commands;
> mysql_query("INSERT into mybtd(co_pe) values('Johsua's Brother')"); canot
> be functioned. and also mysql_query("INSERT into mybtd(co_pe)
> values("Johsua's Brother")");
>
> but this command can be run on terminal use the command below:-
> INSERT into mybtd(co_pe) values("Johsua's Brother"); can be run...But
> INSERT into mybtd(co_pe) values('Johsua's Brother'); cannot run...
>
> can you give me some help..
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php