Spaces in Field names and mssql_fetch_object !!

[davezap]

Ok my first post, and here is the problem.

I'm writing a PHP front end to an existing MSSQL DB, the designer of the DB has used spaces in just about every field name posable.. for example
User ID
First Names
Last Registration Type

When I do a query and try and pull objects with mssql_fetch_object I run into problems because of course the following is illegal in PHP.

$obj = mssql_fetch_object($query_id);
echo $obj->User ID;
echo $obj->First Names; // SPACES !!!

Vardump returns things like this.
object(stdClass)#8 (1) { ["computed"]=> string(10) "User ID" }

So my question, is it possible to have the field names translated to replace spaces with underscores, given that no _'s exist in the MSSQL DB at all.

Or another solution, I suppose I could just pull the results as an array but would rather not have to rewrite to much code.

Thanks

[NogDog]

One work-around would be to create aliases for the columns in your queries, e.g.:

SELECT "column one" AS column_one, "column two" AS column_two . . .

[davezap]

I had thought of that, but it bloats my queries and makes them harder to read. Also I 'm holding out for a magic solution 🙂 I suppose Fetch Array is not all that bad, and I may just head down that path.

Thanks

[NogDog]

Threaten to take away the DB designer's Jolt/Mountain Dew privileges until he changes all the field names to not have any spaces or other problematic characters?

[davezap]

ha ha, unfortunately I dont weild that kind of power on this job. It's a 5 year old DB with too many users and interdependent applications. But I'm changing them by stealth to MySQL and underscores over the next year hopefully.

[laserlight]

I believe you can actually write:

echo $obj->{'User ID'};
echo $obj->{'First Names'};

Alternatively, use mssql_fetch_assoc() instead of mssql_fetch_object().