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 Link to comment https://forums.phpfreaks.com/topic/206894-mysql_error-not-working/ 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 Link to comment https://forums.phpfreaks.com/topic/206894-mysql_error-not-working/#findComment-1081932 Share on other sites More sharing options...
Jragon Posted July 6, 2010 Author Share Posted July 6, 2010 Lol spelt label worng Link to comment https://forums.phpfreaks.com/topic/206894-mysql_error-not-working/#findComment-1081934 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.