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;

Reply via email to