Forum Home
Press F1
 
Thread ID: 43524 2004-03-17 09:17:00 Off Topic: Any PHP/MYSQL gurus out there?? prayingmantis (5416) Press F1
Post ID Timestamp Content User
223278 2004-03-17 09:17:00 Hello

I hopeing there are some PHP/MYSQL gurus out there who can help me to get this script to work:

The error message I am getting is:

Notice: Undefined index: job_details_priority in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_client in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_phone in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_mobile in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_address in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_job_description in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_status in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_contact in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_client_email in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_due_date in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_quote in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_deposit in c:\program files\apache group\apache\htdocs\form . php on line 39

Notice: Undefined index: job_details_recd in c:\program files\apache group\apache\htdocs\form . php on line 39


Any ideas???? ?:|?:|

Here is the code

<?
////////////////////////////////
// This checks to see if we need to add another entry .
////////////////////////////////
//if (($REQUEST_METHOD=='POST')) {

////////////////////////////////
// This loop removed "dangerous" characters from the posted data
// and puts backslashes in front of characters that might cause
// problems in the database .
////////////////////////////////
for(reset($HTTP_POST_VARS);
$key=key($HTTP_POST_VARS);
next($HTTP_POST_VARS)) {
$this = addslashes($HTTP_POST_VARS[$key]);
$this = strtr($this, ">", " ");
$this = strtr($this, "<", " ");
$this = strtr($this, "|", " ");
$$key = $this;
}
/////////////////////////////////
// This will catch if someone is trying to submit a blank
// or incomplete form .
////////////////////////////////
//if ($name && $email && $message ) {
////////////////////////////////////////////

////////////////////////////////
// This is the meat of the query that updates the table
////////////////////////////////
$query = "INSERT INTO job_details(job_details_priority, job_details_client, job_details_phone, job_details_mobile,job_details_address, job_details_job_description,job_details_status, job_details_contact, job_details_client_email, job_details_due_date, job_details_quote, job_details_deposit, job_details_recd)
VALUES('" . $_POST['job_details_priority'] . "','" . $_POST['job_details_client'] . "','" . $_POST['job_details_phone'] . "','" . $_POST['job_details_mobile'] . "','" . $_POST['job_details_address'] . "','" . $_POST['job_details_job_description'] . "','" . $_POST['job_details_status'] . "','" . $_POST['job_details_contact'] . "','" . $_POST['job_details_client_email'] . "','" . $_POST['job_details_due_date'] . "','" . $_POST['job_details_quote'] . "','" . $_POST['job_details_deposit'] . "','" . $_POST['job_details_recd'] . "')";
$link = mysql_connect("localhost", "stuartw", "stuartw1")
or die("Unable to connect to SQL server : " . mysql_error());
echo "Connected successfully";
mysql_select_db("stuartw") or die("Could not select database ");
mysql_query($query) or die("Insert Failed! ");

//} else {//
?>


I hope some one can help me here :)

PS: sorry about the right hand side scrolling :| 		prayingmantis (5416)
223279 2004-03-17 09:31:00 By the way, in the 2nd part of this script the bit that should show the information back to me I get this error message:

Parse error: parse error, unexpected $end in c:\program files\apache group\apache\htdocs\show_infor . php on line 132

Here is the code:

<?

////////////////////////////////
// This is where we connect to the database for reading .
////////////////////////////////
$link = mysql_connect( " localhost " , " username " , " password " )
or die( " Unable to connect to SQL server : " . mysql_error());
echo " Connected successfully " ;
mysql_select_db( " DB name " ) or die( " Could not select database " );
////////////////////////////////
// This is where we decide to get all the entries or just the last 20 .
// This variable is set by just adding a '?complete=1' after the URL .
////////////////////////////////
if ($complete = 1) {
/* Performing SQL query */
$query = " SELECT * FROM my_table " ;
$result = mysql_query($query) or die( " Query failed : " . mysql_error());

//$query = " SELECT * FROM guests " ;
//} else {
//$query = " SELECT * FROM guests " ;
//}
//$db name = mysql_query($query) or die( " Select Failed! " );


////////////////////////////////
// This will loop as long as there are records waiting to be processed .
// Notice the plain HTML inside the while loop structure . PHP is flexable
// enough to allow you to break into and out of the " code " at any point .
////////////////////////////////
while ($dbname = mysql_fetch_array($stuartw)) {

?> </p>
<table border= " 1 " cellpadding= " 1 " cellspacing= " 0 " bordercolor= " #000000 " >
<tr>
<td colspan= " 13 " bgcolor= " #00FFFF " ><div align= " left " >Job Details</div></td>
<td colspan= " 4 " bgcolor= " #FFB895 " ><div align= " left " >Developer</div></td>
<td colspan= " 3 " bgcolor= " #FFFF99 " ><div align= " left " >Referrer</div></td>
<td colspan= " 5 " ><div align= " left " >Completion </div></td>
</tr>
<tr>
<td width= " 4% " height= " 63 " bgcolor= " #99CCFF " > <div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Priority</font></div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Client</font></div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Phone</font></div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Mobile</font></div></td>
<td width= " 4% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Address</font></div></td>
<td width= " 6% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Job
Description</font></div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Status</font></div></td>
<td width= " 4% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Contact</font></div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Client
Email</font></div></td>
<td width= " 2% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Due
date</font></div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Quote</font></div></td>
<td width= " 4% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Deposit</font></div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Rec'd</font></div></td>
<td width= " 5% " bgcolor= " #99CCFF " >Developer</td>
<td width= " 4% " bgcolor= " #99CCFF " >E-mail</td>
<td width= " 2% " bgcolor= " #99CCFF " >Dev fee</td>
<td width= " 5% " bgcolor= " #99CCFF " >Fee paid</td>
<td width= " 5% " bgcolor= " #99CCFF " >Referred by</td>
<td width= " 6% " bgcolor= " #99CCFF " >Commission</td>
<td width= " 4% " bgcolor= " #99CCFF " >Paid</td>
<td width= " 6% " bgcolor= " #99CCFF " >Completed</td>
<td width= " 5% " bgcolor= " #99CCFF " >Approved</td>
<td width= " 5% " bgcolor= " #99CCFF " >Invoiced</td>
<td width= " 2% " bgcolor= " #99CCFF " >Paid</td>
<td width= " 6% " bgcolor= " #99CCFF " >Profit</td>
</tr>
<tr>
<td height= " 28 " bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " > <? echo $job_details_priority['job_details_priority']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " > <? echo $job_details_client['job_details_client']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " > <? echo $job_details_phone['job_details_phone']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " > <? echo $job_details_mobile['job_details_mobile']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_address['job_details_address']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_job_description['job_details_address']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_status['job_details_status']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_contact['job_details_contact']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_client_email['job_details_client_email']; ?> </font>
</td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_due_date['job_details_due_date']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_quote['job_details_quote']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_deposit['job_details_deposit']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $job_details_recd['job_details_recd']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $developer_developer['developer_developer']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $developer_email['developer_email']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $developer_dev_fee['developer_dev_fee']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $developer_fee_paid['developer_fee_paid']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $referrer_referred_by['referrer_referred_by']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $referrer_commission['referrer_commission']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $referrer_paid['referrer_paid']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $completion_completed['completion_completed']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $completion_approved['completion_approved']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $completion_invoiced['completion_invoiced']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $completion_paid['completion_paid']; ?> </font></td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<? echo $completion_profit['completion_profit']; ?> </font></td>
</tr>
</table>
<font size= " 2 " face= " Arial, Helvetica, sans-serif " > </font>


<? } ?>
</body>
</html>

any ideas? 		prayingmantis (5416)
223280 2004-03-18 00:26:00 My non expert opion, and I assume you are posting to an access database? would be that your field names are not matching the exported field names in the access tabel when you post. ugh1 (4204)
223281 2004-03-18 00:56:00 As another non-expert, I can say with some confidence that's there's something wrong with line 39 on form . php . (Or near line 39) . :D

The "undefined index" might be a clue . . . is there case dependence in the naming?

I'd strip that enormous line with all the horrendous <'" . > punctuation down and try to insert one element . If you can make it work for one, then you can put in the other 13 elements . 		Graham L (2)
223282 2004-03-18 01:27:00 > My non expert opion, and I assume you are posting to
> an access database?

Nope, I am posting to a mysql database

>would be that your field names
> are not matching the exported field names in the
> access tabel when you post .

Nope, as all the field name are the same every where e . g . in the form & in the database . 		prayingmantis (5416)
223283 2004-03-18 01:30:00 > As another non-expert, I can say with some confidence
> that's there's something wrong with line 39 on
> form . php . (Or near line 39) . :D
>
> The "undefined index" might be a clue . . . is there
> case dependence in the naming?

You loosed me there Graham L ?:|

> I'd strip that enormous line with all the horrendous
> <'" . > punctuation down and try to insert one
> element . If you can make it work for one, then you
> can put in the other 13 elements .

Are you talking about where it says "$query = "INSERT INTO job_details(job_details_priority, etc . . . . . " ?:|?:| 		prayingmantis (5416)
223284 2004-03-18 04:11:00 Case dependence is when "Job_Details_Priority" does not match "job_details_priority" or"JOB_DETAILS_PRIORITY".

It appears to be that line causing the problem (because there are 14 error messages -- on each for the fields referred to in that line).:D

Line 39 might be the one which sends the value of query (by my rough count of lines) but the errors come because that huge line is "wrong". Somehow. So why not try to generate a query with only one or two of the variable fields, instead of the whole catastrophe? 		Graham L (2)
223285 2004-03-18 06:23:00 Now I got a new error message:

Parse error: parse error, unexpected T_STRING in c:\program files\apache group\apache\htdocs\form . php on line 55

Any ideas?

Here is my updated code:

<!DOCTYPE HTML PUBLIC " -//W3C//DTD HTML 4 . 01 Transitional//EN " >
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv= " Content-Type " content= " text/html; charset=iso-8859-1 " >
</head>
<body>
<?
$link = mysql_connect( " localhost " , " username " , " password " )
or die( " Unable to connect to SQL server : " . mysql_error());
echo " Connected successfully " ;
mysql_select_db( " DBname " ) or die( " Could not select database " );
mysql_query($query) or die( " Insert Failed! " );
////////////////////////////////
// This checks to see if we need to add another entry .
////////////////////////////////
//if (($REQUEST_METHOD=='POST')) {

////////////////////////////////
// This loop removed " dangerous " characters from the posted data
// and puts backslashes in front of characters that might cause
// problems in the database .
////////////////////////////////
for(reset($HTTP_POST_VARS);
$key=key($HTTP_POST_VARS);
next($HTTP_POST_VARS)) {
$this = addslashes($HTTP_POST_VARS[$key]);
$this = strtr($this, " > " , " " );
$this = strtr($this, " < " , " " );
$this = strtr($this, " | " , " " );
$$key = $this;
}
/////////////////////////////////
// This will catch if someone is trying to submit a blank
// or incomplete form .
////////////////////////////////
//if ($name && $email && $message ) {
////////////////////////////////////////////

////////////////////////////////
// This is the meat of the query that updates the table
////////////////////////////////
$query = " INSERT INTO job_details(job_details_priority, job_details_client, job_details_phone, job_details_mobile,job_details_address, job_details_job_description,job_details_status, job_details_contact, job_details_client_email, job_details_due_date, job_details_quote, job_details_deposit, job_details_recd)
VALUES(' " . $_POST['job_details_priority'] . " ',' " . $_POST['job_details_client'] . " ',' " . $_POST['job_details_phone'] . " ',' " . $_POST['job_details_mobile'] . " ',' " . $_POST['job_details_address'] . " ',' " . $_POST['job_details_job_description'] . " ',' " . $_POST['job_details_status'] . " ',' " . $_POST['job_details_contact'] . " ',' " . $_POST['job_details_client_email'] . " ',' " . $_POST['job_details_due_date'] . " ',' " . $_POST['job_details_quote'] . " ',' " . $_POST['job_details_deposit'] . " ',' " . $_POST['job_details_recd'] . " ')


//} else {//
?>

<!-- *////////////////////////////////
//The bits of PHP in the form allow the data that was already //input
// to be placed back in the form if it is filled out //incompletely
////////////////////////////////* -->

<FORM ACTION= " form . php " METHOD= " post " name= " input_form " id= " input_form " >
<PRE> <table width= " 267% " border= " 1 " cellpadding= " 1 " cellspacing= " 0 " bordercolor= " #000000 " >
<tr>
<td colspan= " 13 " bgcolor= " #00FFFF " ><div align= " left " >Job Details</div></td>


<td width= " 13% " ><font color= " #FFFFFF " >s </font> </td>
</tr>
<tr>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Priority </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Client </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Phone </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Mobile </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Address </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Job Description </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Status </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Contact </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Client Email </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Due date </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Quote </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Deposit </font> </div></td>
<td width= " 3% " bgcolor= " #99CCFF " ><div align= " center " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >Rec'd </font> </div></td>
<td bgcolor= " #99CCFF " ><font color= " #99CCFF " >s </font> </td>
</tr>
<tr>
<td height= " 56 " bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_priority " type= " text " id= " job_details_priority " value= " <? echo $job_details_priority; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_client " type= " text " id= " job_details_client " value= " <? echo $job_details_client; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_phone " type= " text " id= " job_details_phone " value= " <? echo $job_details_phone; ?> " size= " 30 " >
</font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_mobile " type= " text " id= " job_details_mobile " value= " <? echo $job_details_mobile; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_address " type= " text " id= " job_details_address " value= " <? echo $job_details_address; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<input name= " job_details_job_description " type= " text " id= " job_details_job_description " value= " <? echo $job_details_job_description; ?> " size= " 30 " >
</font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " >
<input name= " job_details_status " type= " text " id= " job_details_status " value= " <? echo $job_details_job_status; ?> " size= " 30 " >
</font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_contact " type= " text " id= " job_details_contact " value= " <? echo $job_details_job_contact; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_client_e-mail " type= " text " id= " job_details_client_e-mail " value= " <? echo $job_details_client_e-mail; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_due_date " type= " text " id= " job_details_due_date " value= " <? echo $job_details_due_date; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_quote " type= " text " id= " job_details_quote " value= " <? echo $job_details_client_quote; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_deposit " type= " text " id= " job_details_deposit " value= " <? echo $job_details_client_deposit; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " ><font size= " 2 " face= " Arial, Helvetica, sans-serif " ><input name= " job_details_recd " type= " text " id= " job_details_recd " value= " <? echo $job_details_client_recd; ?> " size= " 30 " > </font> </td>
<td bgcolor= " #99CCFF " >images/spacer . gifimages/spacer . gif</td>
</tr>
</table>
<font size= " 2 " face= " Arial, Helvetica, sans-serif " > </font>
<INPUT TYPE= " submit " VALUE= " Add " ></PRE>
</FORM>
</body>
</html>


Line 55 is

<FORM ACTION= " form . php " METHOD= " post " name= " input_form " id= " input_form " >

Any ideas? ?:| 		prayingmantis (5416)
223286 2004-03-19 01:29:00 **bump**

?:| 		prayingmantis (5416)
223287 2004-03-19 01:57:00 Update

I tried something that some one from another forum suggest & now I am getting this error message

Parse error: parse error, unexpected T_STRING in c:\program files\apache group\apache\htdocs\form . php on line 44

Line 44 is:

VALUES('" . $_POST['job_details_priority'] . "')";'" . $_POST['job_details_client'] . "')";,'" . $_POST['job_details_phone'] . "')";,'" . $_POST['job_details_mobile'] . "')";,'" . $_POST['job_details_address'] . "')";,'" . $_POST['job_details_job_description'] . "')";,'" . $_POST['job_details_status'] . "')";,'" . $_POST['job_details_contact'] . "')";,'" . $_POST['job_details_client_email'] . "')";,'" . $_POST['job_details_due_date'] . "')";,'" . $_POST['job_details_quote'] . "')";,'" . $_POST['job_details_deposit'] . "')";,'" . $_POST['job_details_recd'] . "')

Any ideas? 		prayingmantis (5416)
1 2 3 4 5