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

johnny10119

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