Jump to content

why would xml be output with wrong data despite the php having the correct field names?


Greywacke
 Share

Recommended Posts

hi there,the php code that generates this line is

echo "		<suppliergooglemapsurl>" . xmlentities( ((strlen($row["text_GoogleMapsURL"]))?$row["text_GoogleMapsURL"]:" ") ) . "</suppliergooglemapsurl>\n";

and the xml returned is

<suppliergooglemapsurl>http://www.canopyxchange.za.net/andycab/;roadrunner_cpt;amGKEa75CF241s4tPAUSED</suppliergooglemapsurl>

yet in when viewed in PMA, the value is

http://maps.google.co.za/maps?f=q&source=s_q&hl=en...

it's printing the text_VTigerData instead of text_GoogleMapsURL database fields... 0overy puzzling this phenomenon, to say the least... any ideas?

Edited by Pierre 'Greywacke' du Toit
Link to comment
Share on other sites

PMA = phpMyAdminSounds like a case of you assuming the data is something other than what it is. If you tell it to print the text_GoogleMapsURL field, and it prints "http://www.canopyxchange.za.net/andycab/;roadrunner_cpt;amGKEa75CF241s4tPAUSED",'>http://www.canopyxchange.za.net/andycab/;roadrunner_cpt;amGKEa75CF241s4tPAUSED", then the simple answer is because "http://www.canopyxchange.za.net/andycab/;roadrunner_cpt;amGKEa75CF241s4tPAUSED" is in the text_GoogleMapsURL field.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...