Posted by Paul Lautman on 01/20/08 13:11

I need to get some data from a MSSQL database via an asp server, to display
in a php generated page. I don't want to pre-format the data from a display
pov, as that means going to the asp server whenever I want to change it.

This data will be a few information fields (e.g. total_number_of_rows_found,
number_of_rows_per_page, current_page_number) plus the columns/rows actually
returned by the query (I guess I really only need to know
total_number_of_rows_found as I will be supplying the other information as
input parms, but this gives the general idea).

I am pleasantly in the exact opposite situation as normally found here, in
that I can control the sending asp script as well as the receiving php one
(although, whilst I may not be anywhere near an expert php programmer, my
php/MySQL skills far outweigh my asp/MSSQL ones!).

An obvious choice of communications protocol is xml, but does anyone have
any other ideas of neat ways to package up the data at the asp end, to make
it easy to access over on the php side?

[Back to original message]