fetching string from database in php only returns part before a space

Question

i am trying to display a varchar(40) from database to php page field. the value in database is "test address" but when it displays on page it only shows "test".

Below is the code, appreciate you help.

$sql = "SELECT FIRST_NAME,LAST_NAME,ADDRESS,CITY,STATE,ZIP FROM user WHERE USER_ID='$id'";
$result = $database->query($sql);   
$row = mysql_fetch_array( $result );
    $_SESSION['fname']=ucfirst(strtolower($row[0]));        
    $_SESSION['lname']=ucfirst(strtolower($row[1]));
    $_SESSION['address']=$row[2];

<input type='text' name='street_address'DISABLED  size='75' value=";echo var_dump($_SESSION['address']);  print" />

u mean quotes on echo statement? i thought u dont need quotes while echoing variables — PUG
– PUG, Commented Jun 21, 2011 at 16:24
I mean quotes around the html field value="" of the input tag. — Jacob Eggers
– Jacob Eggers, Commented Jun 21, 2011 at 16:25

Jacob Eggers · Accepted Answer · 2011-06-21 16:24:03Z

1

I think that you are probably missing the quotes around the value. Can you paste the view source?

But, try this:

echo "<input type='text' name='street_address'DISABLED  size='75' value='";
echo var_dump($_SESSION['address']);
echo "' />";

answered Jun 21, 2011 at 16:24

Jacob Eggers

9,3282 gold badges27 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

fetching string from database in php only returns part before a space

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related