Please help the newbie...

[ladida]

Hi guys,

I need some expert advice on one of my script. For some reason the footer won't show when the code $result = mysql_query($query) or die('The username/password is already in use. Please go back and choose another'); is called. The rest of the code seems to be fine. Please please please help me.

Thank you so much in advance.

regards,
ladida

<?
session_start();
include_once "../main.php";
include_once "../configuration.inc.php";

if ($upass == $cpass) 
{
   if (!empty($uname) && !empty($upass) && !empty($cpass) && !empty($title) && !empty($fname) && !empty($lname) && !empty($city) && !empty($country) && !empty($zip) && !empty($address) && !empty($phone) && !empty($job_seeker_email) && !empty($JobCategory) && !empty($careerlevel))
     {
	if (is_array($JobCategory))
	{
		$JobStr = implode("," , $JobCategory);
	}

	if($careerlevel == '1')
	{
		$clname = 'Student (High School)';
	}
	elseif($careerlevel == '2')
	{
		$clname = 'Student (undergraduate/graduate)';
	}
	elseif($careerlevel == '3')
	{
		$clname = 'Entry Level (less than 2 years of experience)';
	}
	elseif($careerlevel == '4')
	{
		$clname = 'Mid Career (2+ years of experience)';
	}
	elseif($careerlevel == '5')
	{
		$clname = 'Management (Manager/Director of Staff)';
	}
	elseif($careerlevel == '6')
	{
		$clname = 'Executive (SVP, EVP, VP)';
	}
	elseif($careerlevel == '7')
	{
		$clname = 'Senior Executive (President, CEO)';
	}

     $query = "insert into job_seeker_info set 
	uname = \"$uname\",
	upass = \"$upass\",
	title = \"$title\",
	fname = \"$fname\",
	lname = \"$lname\",
	income = \"$income\",
	city = \"$city\",
	state = \"$state\",
	country = \"$country\",
	zip = \"$zip\",
	address = \"$address\",
	phone = \"$phone\",
	phone2 = \"$phone2\",
	job_seeker_email = \"$job_seeker_email\",
	job_seeker_web = \"$job_seeker_web\",
	job_category = \"$JobStr\",
	careerlevel = \"$clname\",
	target_company = \"$target_company\",
	relocate = \"$relocate\"
	";


	$result = mysql_query($query) or die('The username/password is already in use. Please go back and choose another');


	$qcl = "insert into job_careerlevel set
		uname = \"$uname\",
		clnumber = \"$careerlevel\",
		clname = \"$clname\" ";
	$rcl = mysql_query($qcl) or die(mysql_error());


$to = $job_seeker_email;
$subject = "Your account at $mydomain";
$message = "This is your account information at $mydomain\n\n username: $uname\n password: $upass\n\n\n Keep this information in a secure place. \n\n Thanks for your registration. We believe you will find a job at \n [url]http://[/url]$myurl";
$from = "From: <$contactemail>";

mail($to, $subject, $message, $from);

session_register("uname");
session_register("upass");

	echo "<br><br><br> 
	<p align=center>
	Thank you ! You are now registered as a job seeker.<br>Start <a href=post-resume.php>building your resume</a> or <a href=job-search.php> search for a job</a>.
	</p>
	";

    }
    else
    {
echo "<center><br><br><br><font color=red><b> You miss to fill some of the required fields.<br> Please go <a class=ERR href=jobseeker_registration.php> back</a> and fill all of them properly.</b></font></center>";
    }
}
else
{
	echo "<center><br><br><br><font color=red><b> The password/confirm password fields don`t match. <br> Please go <a class=ERR href=jobseeker_registration.php> back</a> and fill them properly.</b></font></center>";
}

?>
<? include_once('../footer.php'); ?>

[sneakyimp]

die() makes code execution and stop. generally, i try avoid outputting any header or footer files until i'm certain that everything has run properly. you might try defining a function llike this:

function my_error($error_message) {
      echo $error_message;
      include_once('../footer.php');
     die();
}

and instead of query or die(), you do

query blah blah
or my_error('The username/password is already in use. Please go back and choose another');

[ladida]

thank you so much for your reply. I'm not sure where to put them (sorry for my stupidity). Please can you show me.

much appreciated,
ladida

[sneakyimp]

don't apologize for your stupidity. pick up yourself!

change this ------>die('your long error message which i don't feel like typing')

to this ----->my_error('your long error message which i don't feel like typing')

and put the function that i defined in my last post right after this line:

include_once "../configuration.inc.php";

if you have problems, try reading the errors you get and see if you can work it out. if you're still stumped, then come back here and ask for help again. if you want to learn PHP, you're going to have to suffer through some errors and just experiment. it's the only way to have the 'programming awakening'