PHP Web Hosting, Tomcat, JSP, J2EE, Servlets, Struts - PHP4, PHP5 Programming Blog

/* Function to get the director s name from the people table */ function get_director() { global $movie_director; global $director; $query_d = SELECT people_fullname . FROM people . WHERE people_id= $movie_director ; $results_d = mysql_query($query_d) or die(mysql_error()); $row_d = mysql_fetch_array($results_d); extract($row_d); $director = $people_fullname; } /* Function to get the lead actor s name from the people table */ function get_leadactor() { global $movie_leadactor; global $leadactor; $query_a = SELECT people_fullname . FROM people . WHERE people_id= $movie_leadactor ; $results_a = mysql_query($query_a) or die(mysql_error()); $row_a = mysql_fetch_array($results_a); extract($row_a); $leadactor = $people_fullname; } $query = SELECT * FROM movie . WHERE movie_id = . $_GET[ movie_id ] . ; $result = mysql_query($query, $link) or die(mysql_error()); $movie_table_headings=<< Movie Title Year of Release Movie Director Movie Lead Actor Movie Running Time Movie Health

EOD; while ($row = mysql_fetch_array($result)) { $movie_name = $row[ movie_name ]; $movie_director = $row[ movie_director ]; $movie_leadactor = $row[ movie_leadactor ]; $movie_year = $row[ movie_year ]; $movie_running_time = $row[ movie_running_time ]. mins ; $movie_takings = $row[ movie_takings ]; 125 Using Tables to Display Data
Note: In case you are looking for affordable and reliable webhost to host and run your j2ee application check Vision j2ee hosting services

This entry was posted on Wednesday, April 25th, 2007 at 3:10 pm and is filed under php. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.