----- Original Message ----- 
From: "Hugh Bothwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 6:23 AM
Subject: [PHP-DB] Re: Spaces Problem php & mysql


> > I've been pounding my head (and the keyboard with searches) over this. Do
> I
> > have to take the first entry apart with string functions to get my desired
> > end, which is the entire name in one field in the database?
> 
> ... make sure the value is enclosed in quotes when you try
> to insert it into the database, ie
> 
> INSERT INTO table ( name ) VALUES ( '$name' )

Make sure you escape out all single quotes in $name.

$name = " This is Paul's field."
.
.
.
INSERT INTO table ( name ) VALUES ( '$name' )

Will fail, because you have VALUES ('This is Paul');

Post the full value of $name via var_dump($name) and
var_dump($query) and we'll see what we can find with it.

'Luck

-Szii


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to