Ken-- If you have access to that server with the SQL database... Then instead of creating an additional PHP script on the SQL server... Could you simply add a username/password that was allowed to access that particular database (read-only, of course) remotely? If that isn't an option, here's an idea: Transmit the $star and $decade variables to the MovieResponder.php (don't pass the SQL query directly-- that's a bad idea!)... Have the MovieResponder.php execute the SQL query, retrieve all results into an array, and serialize() the array, then pass the serialized data back to MovieInfo.php. I'm sure others will have other suggestions, and there are probably better ways to do it than this. Good luck! -----Original Message----- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 12:22 AM To: PHP DB Mailing List Subject: [PHP-DB] relay response transactions between PHP scripts on different servers Hello, suppose you have a MOVIES table in your database on your server at your hosting company. Suppose I want some MOVIE info from your database..the titles of all the Robert Deniro movies released in the 1980's. Can I get the info and relay it back to the user on MY site? Would it be something like this?: Suppose I have a php page on MY web site called MovieInfo.php MovieInfo.php creates a sql command string from info provided by the user at MY site. something like $sql=" select titles,dates from movies where star = 'Robert Deniro' and decade = '1980'" assume correct syntax. Suppose you have a PHp script on your site called MovieResponder.php that is designed to run the query and send the result back to MY script. The php page on MY web site called MovieInfo.php has something like this form: FORM method="post" action="https://www.yourserver.com/gateway/MovieResponder.php";> <INPUT TYPE="hidden" NAME="x_ADC_URL" VALUE="https://www.myserver.com/MovieInfo.php";> <INPUT TYPE="hidden" NAME="query" VALUE=$sql> <INPUT TYPE="submit"> </FORM> etc? etc? how could it work? Ken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
