Jragon Posted July 6, 2010 Share Posted July 6, 2010 Hello, when i am trying to see what mysql error is it dose not work Code: <?php $link = include("connect.php"); include("connect.php"); mysql_select_db('moviesite') or die(mysql_error); //select the movie titles and there ganre after 1990 $query = 'SELECT movie.movie_name, movietype.movietype_lable FROM movie, movietype WHERE movie.movie_type = movietype.movietype_id AND movie_year > 1990 ORDER BY movie_type'; $result = mysql_query($query) or die(mysql_error); //Show results echo '<table border="1"'; while($row = mysql_fetch_assoc($result)){ echo '<tr>'; echo '<tr>'; foreach ($row as $value){ echo '<td>' . $value . '</td>'; } echo '</tr>'; } echo '</table>'; ?> I Would like to see what the error is but its not working Quote Link to comment Share on other sites More sharing options...
Mchl Posted July 6, 2010 Share Posted July 6, 2010 It's a function so: $result = mysql_query($query) or die(mysql_error()); And I think error might be here: movietype_lable Quote Link to comment Share on other sites More sharing options...
Jragon Posted July 6, 2010 Author Share Posted July 6, 2010 Lol spelt label worng Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.