Space in name of table

[steven]

I have a space in my tablename. When i use

odbc_exec( $cnx_tnrpt01, "... ... From Declaration Master" );

i have an error saying could not query the table Declaration. what shd i put between the Declaration and Master so that PHP understands the tablename is "Declaration Master"?

[barand]

Different dialects of SQL have different conventions. For example, Access uses []. others use quotes.

Try

odbc_exec( $cnx_tnrpt01, "... ... From [Declaration Master]" );

or

odbc_exec( $cnx_tnrpt01, "... ... From 'Declaration Master' " );

Best way is to design database without spaces in names (use '_' instead)

hth