Jimmy Lam said:
> I have insert some text with space to mysql DB with varchar()
> When I use mysql_fetch_array function to retrieve the data from DB . I
> found only the first session text can be shown . It means if any space
> there . It will split like session by session. for example. my DB have a
> text "Hello World" , It can retrieve only "HELLO" by using
> mysql_fetch_array .
Whenever you insert data into a database you need to escape any special
characters. As you're using MySQL, simply using addslashes() on your data
before inserting them would do the trick.
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php