Spaces collapsed in database
| From: | Alberto Brea | Date: | Fri, 28 Feb 2003 15:58:54 +0000 |
| Subject: | Spaces collapsed in database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-137581@lists.php.net to get a copy of this message | ||
Hi, list
I had certain information in a text file, which showed ok upon fopen() and parsing, but when I put
it into a MySQL database, instead of echoing directly into the browser, the spaces in the strings
collapsed, so that "One Two & Three" became "OneTwo&Three" in the
database table. When I retrieve this the spaces remain collapsed.
Can anybody tell me what I did wrong, or what can I do to prevent this from happening?
Please find the code below
Thank you,
Alberto
// QUERY 1: INSERT RECORDS INTO TABLE contacts
// DEFINE VARIABLES FOR QUERY 1
$sex=$info[1];
$lang=$info[2];
$pretreat=$info[3];
$fname=$info[4];
$lname=$info[5];
$posttreat=$info[6];
$contabbr=$info[9];
$persweb=$info[10];
$idactiv=$info[11];
$unsubscribe=$info[14];
$ent=$info[7];
$city=$info[13];
$email=$info[8];
$random=$info[14];
// DEFINE QUERY 1
$sql1= "INSERT INTO contacts SET
sex='$sex',
lang='$lang',
pretreat='$pretreat',
fname='$fname',
lname='$lname',
posttreat='$posttreat',
contabbr='$contabbr',
persweb='$persweb',
idactiv='$idactiv',
unsubscribe='$unsubscribe',
ent='$ent',
city='$city',
email='$email',
random='$random',
date= CURDATE()";
// RUN QUERY 1
if(!mysql_query($sql1)):
echo("Unable to add contact: ". mysql_error() . "<br>");
else:
echo("Contact added successfully<br>");
endif;