Table names with hypens recieve parse error

[kilbey1]

Hi folks,

I have some DB table names that are hyphenated, ie. federal-exemptions. I have gotten my code to work by putting single quotes around it. However, when I try to write my query like so:

$result_federal-exemptions = mysql_query("SELECT * FROM 'federal-exemptions'");

I get a parse error.

Can anyone tell me the best way to handle this? I know I could go:

$sql = 'SELECT * '
				. ' FROM `federal-exemptions` '; 
				$result = mysql_query($sql);

...but I was trying to shorten things up a bit by using the first form.

Thanks,
Eve

[mistercash60000]

don't you have to set: 'federal-exemptions'
between [] without ' '

[superwormy]

You can't use - in variable names. Remove the -.

[csn]

Yeah use _'s instead.

[kilbey1]

Hmm, that'll goof up all my code that makes references to table names with hyphens. I was kinda hoping to not go that option, but will if I must.

• Eve

[ultraslacker]

A decent editor or some command line knowhow will fix that.