How do you access columns with a space in them via mysql_fetch_object?

Question

When using mysql_fetch_object() to return objects from a MySQL query, sometimes column names have spaces in them, and cannot be aliased, such as when running SHOW CREATE PROCEDURE. The procedure definition is returned in a column named Create Procedure. In my case, the data abstraction layer only allows the use of mysql_fetch_object(), so I can't simply use mysql_fetch_assoc() to work around this problem.

Can I access columns with spaces in when using mysql_fetch_object()?

Answer 1

Generally speaking,

$recordname->{"my column name"} 

will do the trick.

You can also do a print_r($record); to find out how the columns are represented in the object.