When I run the following Query in PhpMyAdmin's query analyzer it returns:
FEET FEET FEET
3 7 5
Problem is when I try to reference Anchor.Feet in php code... It does not know what I am talking about.. WHy is the dot notation not working? The query returns the correct values... Just with no way to tell them apart in the php code...
SELECT Anchor.Feet,Channel.Feet,Cargo.Feet FROM WPI_Data INNER JOIN Depth_Code as Anchor ON WPI_Data.Anchorage_depth=Anchor.Depth_Code INNER JOIN Depth_Code as Channel ON WPI_Data.Channel_depth = Channel.Depth_Code INNER JOIN Depth_Code as Cargo ON WPI_Data.Cargo_pier_Depth=Cargo.Depth_Code INNER JOIN Country_Codes ON Country_Codes.Country_Code =WPI_Data.Wpi_country_code WHERE World_port_index_number ='45590'
FEET FEET FEET
3 7 5
Problem is when I try to reference Anchor.Feet in php code... It does not know what I am talking about.. WHy is the dot notation not working? The query returns the correct values... Just with no way to tell them apart in the php code...
SELECT Anchor.Feet,Channel.Feet,Cargo.Feet FROM WPI_Data INNER JOIN Depth_Code as Anchor ON WPI_Data.Anchorage_depth=Anchor.Depth_Code INNER JOIN Depth_Code as Channel ON WPI_Data.Channel_depth = Channel.Depth_Code INNER JOIN Depth_Code as Cargo ON WPI_Data.Cargo_pier_Depth=Cargo.Depth_Code INNER JOIN Country_Codes ON Country_Codes.Country_Code =WPI_Data.Wpi_country_code WHERE World_port_index_number ='45590'