mysql_error() not being displayed

nick99

Hi,

I pretty new to PHP and am currently developing a small application.

I have developed an error page which I want to include a MySQL error message from another page from:

I use the header function to transfer to another page if there is an error:

$link = mysql_connect ('localhost',"root","wrong password")
or header("Location: http://localhost/cd/complaint_management_system_error.php");

I have 'echo mysql_error();' on my error page, but nothing is displayed.

Has any one got any ideas?

thorpe

mysql_error() will only show the last error that accured on the current script, so redirecting to another script will clear it. You'll either need to display the error on the current page, or pass it through a $_SESSION variable or url.

nick99

How would you pass it through a URL?

bradgrafelman

Why not just integrate your error handling into your scripts?

If you really wanted to pass it through the URL, though, just add "?msg=" onto the end of your URL, followed by the error message after you made it safe for transport via the URL (using a function such as [man]urlencode[/man]/[man]rawurlencode/man ).

nick99

Is error handling the best way for what im trying to do?

nick99

Thanks for you guys quick reply, but im now totally confused.

Here is my code from my two pages:

First Page

<?php
session_start();

if($REQUEST["submit"])
{
$cc_fname = $REQUEST["fname"];
$cc_lname = $REQUEST["lname"];
$cc_company = $REQUEST["company"];
$cc_phno = $REQUEST["phno"];
$cc_faxno = $REQUEST["faxno"];
$cc_mobno = $REQUEST["mobno"];
$cc_email = $REQUEST["email"];

$cm_method = $_REQUEST["method"];

$cl_location = $_REQUEST["location"];

//$ccom_company = $REQUEST["briefdescription"];
//$ccom_location = $REQUEST["briefdescription"];

$cn_nature = $_REQUEST["nature"];

$ci_briefdesc = $REQUEST["briefdescription"];
$ci_fulldesc = $REQUEST["fulldescription"];

$cr_fname = $REQUEST["fnameInput"];
$cr_lname = $REQUEST["lnameInput"];

$ci_doc = $_REQUEST["attach1"];

$error = $_SESSION['mysql_error();'];

$link = mysql_connect ('localhost',"root","wrong password")
or header("Location: http://localhost/cd/complaint_management_system_error.php?");

$dblink = mysql_select_db ('complaints desk test',$link)
or die ("Could not select database".mysql_error());

$sql ="INSERT INTO Complainant_Contact(cc_fname,cc_lname,cc_company, cc_phno, cc_faxno, cc_mobno, cc_email)VALUES('$cc_fname','$cc_lname','$cc_company','$cc_phno','$cc_faxno','$cc_mobno', '$cc_email')";