PHP/MYSQL: Refer to column name when name is number

[chromonium]

Hello everyone.

When querying a MYSQL DB with PHP, how can you query a column ie [WHERE 1='test'] when the column/field name is itself a number?

Thanks very much

Many Regards

adam

http://www.fractalimpact.co.uk

 

[sleipnir214]

You might try WHERE `1` = 'test' (backticks around the name of the column).

But using numbers for column names is a very bad idea. The programmers allow you to use descriptive names for a column to make your code easier to understand.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[chromonium]

Yeah thanks...

I've now abandoned that system, instead calling them q1, q2 etc instead of 1, 2 etc, then stripping string of 'q' at other end.

regards

adam

 

[sleipnir214]

You might want to rethink your database schema.

Tables consisting of repeated columns like "x1", "x2", etc, generally contain a single class of data with multiple values. Data like that is better stored "vertically" in a related table rather than "horizontally" in a single table.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!