use js to get realtime data from another site (HowHotAmI.com)

[philPHPBUILDER]

Hi,

I run sfnitelife.com, its a php driven 'vote for the hottest party' site.
I want to be able to let users put a code snipet on their site that will display realtime party voting data (the score from 1-10 and the amount of votes, you know the whole hotornot thing) from my site in real time.

...so a user would put the below code on their site (I'm using HowHotAmI.com as an example):

<!-- HowHotAmI.com code start -->
<SCRIPT LANGUAGE= "javaScript" SRC="http://howhotami.com/track.php?pic=MTgxMjk="></script>
<!-- HowHotAmI.com code end -->

...and then the question becomes...What does this track.php file look like?

Is track.php JavaScript and PHP? If its just JavaScript (as the

SCRIPT LANGUAGE= "javaScript"

would make apparent) then how do I call the MySQL db?

From what I can see, the script uses document.write() to output the data if you shorten the url and use:

http://howhotami.com/track.php

Has anyone any code to do this?

cheers,
Phil

[diego25]

Usually track.php will output JavaScript code, and that JavaScript code will add some HTML to the page through document.write()'s.

So you call the database as you'd usually do with PHP, and then put the results inside document.write()s. When the page gets to the browser, the document.write()s will write the database result to the web page.

Diego