quick question field name with spaces

[germanjulian]

while ($row = odbc_fetch_array($datequery)) {

$RelocatingawayfromGBIlocations[$counter] = $row['Relocating away from GBI locations'];
				$ReturningtoEducation[$counter] = $row['Returning to Education'];
}

the problem is that php doesnt like the field names with spaces inside the row field. how do I fix this error?

Notice: Undefined index: Relocating away from GBI locations in c:\program files\apache group\apache\htdocs\leavers\functions\search.php on line 44

😕

[onion2k]

Modify the database so that you don't have spaces in the field names?

[germanjulian]

..... if I wanted that awnser I wouldnt ask lol

🙂
thats why I am asking I dont want to do this.. but I might have too

[laserlight]

Do a print_r($row)

From there you can determine what index to use.

There's a chance that the spaces have been replaced by underscores, though I'm only familiar with this happening in form fields, not database table fields, as like PHP, I abhor spaces in names.

[germanjulian]

wtf?
mhh [Relocating away from GBI locati] => 3 [Returning to Education] => 1 [Change of career (to one not co] => 3 [Travelling Abroad] => 3 [Decided to raise Family or care] => 3 [Pay and Benefits]

weird the problem is that the row field names get cut after a certain length.

:o

[kilbey1]

Perhaps this is an obvious answer, but have you tried putting backticks (`) around your fields?

IE:

while ($row = odbc_fetch_array($datequery)) {

$RelocatingawayfromGBIlocations[$counter] = $row['`Relocating away from GBI locations`'];
                $ReturningtoEducation[$counter] = $row['`Returning to Education`'];
}

You really should consider renaming your database fields to eliminate spaces, ie. RelocatingAwayFromGBILocations.