Question

How to get the line number with mysql_error() in PHP

Answer 1

$db_host     = 'localhost';
$db_user     = 'user_name';
$db_pass     = 'password';
$db_database = 'database_name';

$con = mysql_connect($db_host, $db_user, $db_pass) or die('Unable to establish a DB connection');

$sql = "SELECT *
        FROM table_name";
$result = mysql_query($sql, $con);
if ( ! $result ) die("Line: " . __LINE__  . " Error: ". mysql_error());

70+ SQL courses for beginners and professionals