or die(mysql_error()); mysql_select_db( moviesite ) or die (mysql_error()); $query = SELECT movie_name, movie_director, movie_leadactor . FROM movie ; $result = mysql_query($query, $link) or die(mysql_error()); $num_movies = mysql_num_rows($result); $movie_header=<<
Movie Review Database
| Movie Title |
Movie Director |
Movie Lead Actor |
EOD; 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 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; } while ($row = mysql_fetch_array($result)) { $movie_name = $row[ movie_name ]; 118 Chapter 4
Note: If you are looking for best quality webspace to host and run your tomcat application check Vision tomcat hosting services
This entry was posted
on Sunday, April 22nd, 2007 at 11:18 am 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.