Database Echo Error

[princeofpersia]

Hi guys

 

When I retrieve information from database into text field and update the fields, each time I press on update button, an space gets added before the text so in screenshots I have added you can see in image1 everything is fine but once I click on update, a space will be added before the text inside the text field.

 

Here is my code

<?php

session_start();

include ("global.php");

 

 

//username session

$_SESSION['username']=='$username';

$username=$_SESSION['username'];

 

 

 

//welcome messaage

echo "Welcome, " .$_SESSION['username']."!<p>";

 

  if ($_POST['register'])

    {

    //get form data

    $name = addslashes(strip_tags($_POST['name']));

    $telephonenumber = addslashes(strip_tags($_POST['telephonenumber']));

    $buildingnumber = addslashes(strip_tags($_POST['buildingnumber']));

    $streetname = addslashes(strip_tags($_POST['streetname']));

    $town = addslashes(strip_tags($_POST['town']));

    $county = addslashes(strip_tags($_POST['county']));

    $country = addslashes(strip_tags($_POST['country']));

    $postcode = addslashes(strip_tags($_POST['postcode']));

    $email = addslashes(strip_tags($_POST['email']));

 

//update statements

 

$query = "UPDATE  userss  SET name =' $name' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET telephonenumber = ' $telephonenumber' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET buildingnumber = ' $buildingnumber' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET streetname = ' $streetname' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET county = ' $county' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET town = ' $town' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET country = ' $country' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET postcode = ' $postcode' WHERE username='$username'";

$result = mysql_query($query);

 

$query = "UPDATE  userss  SET email = ' $email' WHERE username='$username'";

$result = mysql_query($query);

 

}

 

//update from database to txt field

$update = "SELECT name, telephonenumber, buildingnumber, streetname, country, town, postcode, county, email FROM userss WHERE username='$username'";

$result = mysql_query($update);

$row = mysql_fetch_assoc($result);

 

 

 

?>

  <form action='updateprofile.php' method='POST'>

    Name:<br />

    <input type='text' name='name' value='<?php echo $row['name'];?>'><p />

    Telephone Number:<br />

    <input type='text' name='telephonenumber' value='<?php echo $row['telephonenumber'];?>'><p />

    Building Number:<br />

    <input type='text' name='buildingnumber' value='<?php echo $row['buildingnumber'];?>'><p />

    Street Name:<br />

    <input type='text' name='streetname' value='<?php echo $row['streetname'];?>'><p />

    County:<br />

    <input type='text' name='county' value='<?php echo $row['county'];?>'><p />

    Town:<br />

    <input type='text' name='town' value='<?php echo $row['town'];?>'><p />

    Country:<br />

      <input type='text' name='country' value='<?php echo $row['country'];?>'><p />

      Postcode:<br />

      <input type='text' name='postcode' value='<?php echo $row['postcode'];?>'><p />

      Email:<br />

      <input type='text' name='email' value='<?php echo $row['email'];?>'><p />

             

    <input type='submit' name='register' value='Update'>

    </form>

 

 

    <iframe width="750" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.co.uk/maps?f=q&source=s_q&hl=en&geocode=&q=<?php echo "$buildingnumber,+$streetname,+$town,+ $postcode,+$county,+$country";?>&sll=&sspn=0.007597,0.025921&ie=UTF8&hq=&hnear=<?php echo "$buildingnumber,+$streetname,+$town,+ $postcode,+$county,+$country";?>&ll=&spn=0.011236,0.025921&z=14&output=embed"></iframe>

 

 

could someone kindly advice me on this please?

 

 

[attachment deleted by admin]

[PFMaBiSmAd]

All of your string data values (everything between the pair of single-quotes) in your queries have a space character in them, so of course you are getting an extra space stored with the data.

[princeofpersia]

yeah y r right, thanks for help PFMaBiSmAd