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