On 22 Nov 2004 07:50:30 -0800, Dynamo <Dy***********@newsguy.com>
wrote:
Hello again ;-)
What is the correct syntax to use when inserting a value into a table that
contains a variable name with spaces.
This works
$query = "INSERT INTO Catalogue (Author) VALUES ('Stephen King')"
And this does not
$query = "INSERT INTO Catalogue (Book title) VALUES ('The Crow')"
I'd suggest simply correcting the problem by NOT putting spaces in
such things as field names.
--
gburnore@databasix dot com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
DataBasix | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ 3 4 1 4 2 ݳ޳ 6 9 0 6 9 ÝÛ³
Black Helicopter Repair Svcs Division | Official Proof of Purchase
================================================== =========================
Want one? GET one!
http://signup.databasix.com
================================================== =========================