Code Problems???

Anon

Hello anybody who can help me.
Here's the deal: Below is my code for a php page that gets called by an html form. I have been trying to figure out why it is not running. I thought all the code was correct (especially since I cut and pasted a bunch from a tutorial.) But all that happens is that i get a parse error somewhere or other in the page. And the header won't even work on other pages. (I can't get my headers or footers to display on any pages...the headers and footers are .php files using print commands.)

Please help!!! (Comment lines???)

Thanks.
Zac

<head><link rel="stylesheet" href="format.css">
<title>Information Response</title>
</head>
<body background="yellow_paper.gif">
<p>
<p>
<a name=0></a>

<?php
include ("header.php");
?>

<p>

<?php

mysql_connect (twain.phpwebhosting.com, zacchristie, five.ten);

mysql_select_db (zacchristie);

mysql_query ("INSERT INTO employers (title, first_name, last_name, email, company, telephone, userid)
VALUES ('$title', '$first_name', '$last_name', '$email', '$company', '$telephone', null)
");

print (Thank you $title $last_name. I look forward to speaking with you.);

mail("zacchristie@hotmail.com","RE: Resume Page Visitor",
"Visitor to my resume page at zacchristie.phpwebhosting.com.":
"$title $last_name, $first_name visited the site for information. n
The email address is $email. n
Mr. $last_name works for $company, Tel: $telephone");

mysql_close(quit);

?>
<p>

Click here to proceed.
<form action=cv.html method=GET>
<input type=submit value=Thank you>
</form>
<p>
<p>
<p>

<?php
include ("footer.php");
?>

</body>

Anon

<?php

//Set us connection id
$db = mysql_connect (twain.phpwebhosting.com, zacchristie, five.ten);

mysql_select_db (zacchristie);

//This assigns your query to $sql
$sql = "INSERT INTO employers (title, first_name, last_name, email, company, telephone)
VALUES ('$title', '$first_name', '$last_name', '$email', '$company', '$telephone')"

//This line executes the query
$result = mysql_query ($sql, $db);

mysql_close(quit);

printf('Thank you %s %s. I look forward to speaking with you.', $title, $last_name);

mail("zacchristie@hotmail.com", "RE: Resume Page Visitor",
"Visitor to my resume page at zacchristie.phpwebhosting.com.:
$title $last_name, $first_name visited the site for information. \n
The email address is $email. \n
Mr. $last_name works for $company, Tel: $telephone");

?>
Should work

Anon

Thanks Louie.
It was just a problem of not assigning the commands to variables? How basic and yet...
Thanks for all the help. I can actually rest easy tonight!!!
Zac

Anon

Back again. Still having problems. Here's the code (below).
i am getting a parse error on line 40. I think that is the $result = mysql_query ($sql, $db); line. Not sure what is going on. Also, what is the deal with my header and footer files (i.e. why will they not run?) Any suggestions of what I should check to remedy this? THanks for the help again.
ZAc

Code for infoform.php

<head><link rel="stylesheet" href="format.css">
<title>Information Response</title>
</head>
<body background="yellow_paper.gif">
<p>
<p>
<a name=0></a>

<p>

<?php
include ("header.php");
?>

 <p>

<?php

//set up connection id
$db = mysql_connect (twain.phpwebhosting.com, zacchristie, five.ten);

mysql_select_db (zacchristie);

//assign the query to the variable $sql
$sql = "INSERT INTO employers (title, first_name, last_name, email, company, telephone)
VALUES ('$title', '$first_name', '$last_name', '$email', '$company', '$telephone')"

//execute the query $sql
$result = mysql_query ($sql, $db);

mysql_close(quit);

printf ('Thank you %s %s. I look forward to speaking with you.', $title, $last_name);

mail("zacchristie@hotmail.com","RE: Resume Page Visitor",
"Visitor to my resume page at zacchristie.phpwebhosting.com.":
"$title $last_name, $first_name visited the site for information. n",

The email address is $email. n
$title $last_name works for $company , Tel: $telephone. n");

mysql_close(quit);

?>
<p>

Click here to proceed.
<form action=cv.html method=GET>
<input type=submit value=Thank you>
</form>
<p>
<p>
<p>

<?php
include ("footer.php");
?>

</body>

Anon

I don't think you will be resting ver easy. You just gave the code to get into your website and potentially change the password.

Anon

You may want to change that username and password I think your parse error is because you need a semicolon at the end of the $sql line. I left it off in my last post. You are getting the parse error on line 40 because the error was right above line 40

Anon

On the topic of your header and footer files, not sure why they are not working, but try using include("./header.php"); and include("./footer.php");