Jump to content

MySQL_error not working


Jragon

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.