mysql_error

[reisve]

Hi

I have this piece of code part of a larger code block:
 

$page = '../../register.php';      
$msg = $error['register'];        
$msg .= mysql_error($link);      
header("Location: templates/frontend/error.php?msg=$msg&page=$page"); 

 

everything works if I remove the  "$msg .=  mysql_error($link);" line. the line bellow comes from a language, file and if the Mysql_error is not on the line, it shows up. with the mysql_error, just get  ablank line

Any help please?

 

[davidannis]

If there was no error mysql_error returns and empty string. Are you sure that the database returned an error?

Returns the error text from the last MySQL function, or '' (empty string) if no error occurred.

http://php.net/manual/en/function.mysql-error.php]

 

Also:

 

Do a view source and see if there is something returned that you are not seeing.

Edited May 4, 2013 by davidannis

[reisve]

according the code flow, there was an error, and if the error line is not there I got my error message. Just would like to add the MySQL error itself:

    $query = "INSERT INTO users (first_name, last_name, email, c_user, c_pass, c_type) VALUES ('$f_fname', '$f_lname', '$f_email', '$f_user', '$cryptpass', '$f_type')";
    if (mysqli_query($link, $query)){
      $page = '../../index.php';
      $msg = $info['register'];
      header("Location: templates/frontend/info.php?msg=$msg&page=$page");

    } else {
      $page = '../../register.php';
      $msg = $error['register'];  
      $msg .= mysql_error($link);
      header("Location: templates/frontend/error.php?msg=$msg&page=$page"); 
    }

Edited May 4, 2013 by reisve

[davidannis]

You are using mysqli above and mysql below. Use mysqli_error

[reisve]

That was the problem. Thank You very much