J B's Supermarket is correct and it was inserted into tthe database without
using a form and php.
"Mike Flynn" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Are you sure that that last field truly contains "J B's Supermarket" in
the
> database? Are you sure
Depending on how the data was inserted. If the data was inserted via a php
script, then trying to insert data with a single quote ( ' ) in it would
throw an error and the query wouldn't complete. The entire query would fail.
If you want to insert ' in a database, either use escape the ' with a \'
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
webm