RE: [PHP-DB] tables/columns with spaces

[] is the correct notation for both tables and columns. I don't ever recommend using spaces in anything, file names, tablenames, or anything else that will bite you later. But that is the correct syntax, so there may be another problem. Maybe BUSINESS AREA is numeric? <>< Ryan -----Original Message----- From: Jeffrey_N_Dyke@Keane.com [mailto:Jeffrey_N_Dyke@Keane.com] Sent: Friday, May 10, 2002 6:41 AM To: php-db@lists.php.net Subject: [PHP-DB] tables/columns with spaces Someone, in their infinite wisdom, named some, not all of course, tables and columns with spaces, i.e. BUSINESS AREA in a SQL server database that i am working with. You can run lots of queries that return fine, but when I run a query such as "select * from REQ where BUSINESS AREA = '$var', i get an error. Which, to me is completely understandable. I have tried using the [BUSINESS AREA] notation, which will work on tables named with spaces, but not field names. I want to simply rename, and make the others adapt their code to conform. But i wanted to try to solve this first. Any ideas...? Thanks, Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php