assigning values from a query

[Anon]

When I attempt to assign a database field from a query to a variable, I only get part of the value in the variable. When I echo, I see the whole database value.
(ex. database="Joe Smith" variable="Joe")

[steveness]

When you assign the value to a variable, you should enclose it in single quotes.

example:

$value='$result';

without the quotes you just get the first word.

Steveness

[toma42]

Whatever man. Single quotes are hard quotes and you will end up with $value equal to the exact string $result also written as \$result.

This is a bad thing. Using $value="$result"; will work but I don't get why you're having the one word problem. Try a print_r($variable); to help debug your problem.

I suspect you ment echo "<input type=\"stuff\" value=\"$result\">";
Using single quotes will still screw you however if the value has a ' in it like; echoed as:
value='tom's value'

will show only tom and the s value' will be lost.

[Anon]

Steveness,

You're a code God!

Jim