Dear Frineds
this is my first post at the wrox website and i was hoping that some one out there could help me in this problem.
i have created the creatmovie, moviedata files and it was runing fine i checked the database from the commond line(DOS) and it was there. however, when i tried to run the code using select.php the browser came back with an empty page no any error message is there i simply cant see any thing. i was wondring what is the problem.
this is the code for the select that i used:
<?php
// Connection String
$connect= mysql_connect("localhost","","")or
die ("hey losser you can not Connect to the database");
//confrming that this is the right database
mysql_select_db("salim0");
$query="SELECT movie_name, movie_type
FROM movie
WHERE movie_year>1990
ORDER BY movie_type";
$result=mysql_query($query) or die(mysql_error());
while($rows=mysql_fetch_assoc($result)) {
foreach($rows as $vall){
echo $vall;
echo " ";
}
echo "<br>";
}
?>
