Re: Outputting a string from mysql database

Are you sure that that last field truly contains "J B's Supermarket" in the database? Are you sure the error wasn't produced while INSERTING the data into the database, thus resulting in only "J B" being put into the database? You should view your database data directly, like by using a webmin utility. If you do $row_info = mysql_fetch_row($result), and then show the row with the company name, a single quote (') shouldn't mess it up. But single quotes can mess up a query. Because if you think about your query, if you do it like this: INSERT INTO table (Name) VALUES ('J B's Supermarket') you can see how the single quote in the Name is messing up the query for MySQL -- it's making MySQL think it's the end of the value for Name. You need to escape single quotes when inserting them into a MySQL database. If you do it via a form and have magicquotes turned on in your PHP.INI, then it's done automatically. Otherwise, you have to do it yourself. At 05:15 AM 4/16/2002 -0400, q wrote:

I have a field in a mysql table called table which is called names. Examples of the information in this column : Name Lottery Company Mark MiniMark J B's Supermarket I connect to the datbase successful and I use the following php line to get the information from the row: $row_info=mysql_fetch_row($result) Howevere when I try to output J B's Supermarket to the web page all I get is J B. How can I get the entire display on the screen including the ' in the name? quincy

Mike Flynn - Burlington, VT http://www.mikeflynn.net/ - mike@mikeflynn.net home=>work=>home=>store=>home [repeat daily]