edit database error with mySQL and php3

I have created a database, and it seems to be working fine so far. However, when I try to edit my entries via a php3 file it erases all of the data I have added in the past except the first word -
Like if the park is called 'Joshua Tree National Monument' all I get back is 'Joshua'. The database displays the data fine, but when I try to edit it erases everything after the first space....I assume I may have set up my database parameters incorrectly? Any suggestions? I am completely at a loss!

------------------

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by camparoo:
<snip> ...when I try to edit my entries via a php3 file it erases all of the data I have added in the past except the first word...<snip>
[/quote]

What are you using to connect to mysql with, scripts from someone else or stuff you wrote yourself? What it sounds like is that you are not quoting you insert or update sql statements right. Try this: set var = '$var'

in php , your query statment must use single quotes, as follows...

$query = "UPDATE table SET blah='$blah' WHERE ID=$id";

note - $id isn't in ' ' because it is an integar while $blah is because it is a string...hope it helps