PHP problem!

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 456,588 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,574 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 929 | Replies: 11

Page 1 of 2

•

Join Date: Nov 2007

Posts: 13

Reputation: jaydude23 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

jaydude23

Offline

Newbie Poster

PHP problem!

Nov 2nd, 2007

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<HTML>
<?php
if (empty($CSP_Name) || empty($Supervisor) || empty($Rep_Number) || empty($Department) || empty($Account_No) || empty($First_Name) || empty($Last_Name) || empty($Phone) || empty($ShipTo_Address) || empty($ShipTo_City) || empty($ShipTo_State) || empty($ShipTo_ZIP) || empty($Accept))
{echo "<h2>Please make sure you have filled in all required fields. Please use your browsers Back button</h2>\n";
 echo "<h2>******REQUEST WAS NOT SUBMITTED******</h2>\n";}
if (isset ($_POST['chk8'])) {
$req1 = "Pre Band Mailer\n";
} else {
$req1 = "None\n";
}
if (isset ($_POST['chk9'])) {
$req2 = "At Brand Mailer\n";
} else {
$req2 = "None\n";
}
if (isset ($_POST['chk10'])) {
$req3 = "Welcome Kit\n";
} else {
$req3 = "None\n";
}
if (isset ($_POST['chk11'])) {
$req4 = "Three Product Welcome Kit -1\n";
} else {
$req4 = "None\n";
}
if (isset ($_POST['chk12'])) {
$req5 = "Three Product Welcome Kit -2\n";
} else {
$req5 = "None\n";
}
if (isset ($_POST['chk13'])) {
$req6 = "...\n";
} else {
$req6 = "None\n";
}
if (isset ($_POST['chk14'])) {
$req7 = "...\n";
} else {
$req7 = "None\n";
}
$ShipTo_Address = stripcslashes($ShipTo_Address);
$Additional_Info = stripcslashes($Additional_Info);
?>
<?php
$usr = "national_twc";
$pwd = "timewarnercable";
$db = "national_test";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($REQUEST_METHOD=="POST") {
if mysql_query("SELECT * FROM test WHERE Account_No = '$Account_No'"){
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");
}    else {
$SQL = " INSERT INTO twc ";
$SQL = $SQL . " (DATE, CSP_Name, Supervisor, Rep_Number, Department, Email, req1, req2, req3, req4, req5, req6, req7, Account_No, First_Name, Last_Name, Phone, ShipTo_Address, ShipTo_City, ShipTo_State, ShipTo_ZIP, Additional_Info, Accept) VALUES ";
$SQL = $SQL . " (now(), '$CSP_Name', '$Supervisor', '$Rep_Number', '$Department', '$Email', '$req1', '$req2', '$req3', '$req4', '$req5', '$req6', '$req7', '$Account_No', '$First_Name', '$Last_Name', '$Phone', '$ShipTo_Address', '$ShipTo_City', '$ShipTo_State', '$ShipTo_ZIP', '$Additional_Info', '$Accept') ";
$result = mysql_db_query($db,"$SQL",$cid);
}
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<center><h1>Thank You.</h1></center>\n");
echo ("<center>Please use back button to go back.</center>\n");
}
mysql_close($cid); 
?>
</HTML>
<HTML>
<?php
if (empty($CSP_Name) || empty($Supervisor) || empty($Rep_Number) || empty($Department) || empty($Account_No) || empty($First_Name) || empty($Last_Name) || empty($Phone) || empty($ShipTo_Address) || empty($ShipTo_City) || empty($ShipTo_State) || empty($ShipTo_ZIP) || empty($Accept))
{echo "<h2>Please make sure you have filled in all required fields. Please use your browsers Back button</h2>\n";
 echo "<h2>******REQUEST WAS NOT SUBMITTED******</h2>\n";}
if (isset ($_POST['chk8'])) {
$req1 = "Pre Band Mailer\n";
} else {
$req1 = "None\n";
}
if (isset ($_POST['chk9'])) {
$req2 = "At Brand Mailer\n";
} else {
$req2 = "None\n";
}
if (isset ($_POST['chk10'])) {
$req3 = "Welcome Kit\n";
} else {
$req3 = "None\n";
}
if (isset ($_POST['chk11'])) {
$req4 = "Three Product Welcome Kit -1\n";
} else {
$req4 = "None\n";
}
if (isset ($_POST['chk12'])) {
$req5 = "Three Product Welcome Kit -2\n";
} else {
$req5 = "None\n";
}
if (isset ($_POST['chk13'])) {
$req6 = "...\n";
} else {
$req6 = "None\n";
}
if (isset ($_POST['chk14'])) {
$req7 = "...\n";
} else {
$req7 = "None\n";
}
$ShipTo_Address = stripcslashes($ShipTo_Address);
$Additional_Info = stripcslashes($Additional_Info);
?>
<?php
$usr = "national_twc";
$pwd = "timewarnercable";
$db = "national_test";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($REQUEST_METHOD=="POST") {
if mysql_query("SELECT * FROM test WHERE Account_No = '$Account_No'"){
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");
}    else {
$SQL = " INSERT INTO twc ";
$SQL = $SQL . " (DATE, CSP_Name, Supervisor, Rep_Number, Department, Email, req1, req2, req3, req4, req5, req6, req7, Account_No, First_Name, Last_Name, Phone, ShipTo_Address, ShipTo_City, ShipTo_State, ShipTo_ZIP, Additional_Info, Accept) VALUES ";
$SQL = $SQL . " (now(), '$CSP_Name', '$Supervisor', '$Rep_Number', '$Department', '$Email', '$req1', '$req2', '$req3', '$req4', '$req5', '$req6', '$req7', '$Account_No', '$First_Name', '$Last_Name', '$Phone', '$ShipTo_Address', '$ShipTo_City', '$ShipTo_State', '$ShipTo_ZIP', '$Additional_Info', '$Accept') ";
$result = mysql_db_query($db,"$SQL",$cid);
}
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<center><h1>Thank You.</h1></center>\n");
echo ("<center>Please use back button to go back.</center>\n");
}
mysql_close($cid); 
?>
</HTML>

Our company does fullfillment requests for a client, and this is the script that places the data into the mysql table from the form they fill out.

What I'm trying to add is a way to check the db before adding the record to prevent duplicate records being submitted to the db.

I've got the code in there, but it seems to fail at:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Accounts\national\wwwRoot\test\new_datain.php on line 52

I'm not sure what is wrong. Perhaps a syntax error. I'm new to php and mysql.

Thanks for any help you can provide me.

- jason

•

Join Date: Sep 2007

Location: Budapest

Posts: 252

Reputation: fatihpiristine has a little shameless behaviour in the past

Rep Power: 0

Solved Threads: 14

fatihpiristine fatihpiristine is offline

Offline

Posting Whiz in Training

Re: PHP problem!

Nov 2nd, 2007

this is integer right? then u cannot assign integer as text

change this :
Account_No = '$Account_No'"
to this:
Account_No = $Account_No"

it ll work

Do a favour, leave me alone

•

Join Date: Sep 2007

Location: Buenos Aires

Posts: 30

Reputation: chmazur is an unknown quantity at this point

Rep Power: 2

Solved Threads: 2

chmazur

Offline

Light Poster

Re: PHP problem!

Nov 2nd, 2007

I wil try with:
if mysql_query("SELECT * FROM test WHERE Account_No = ".$Account_No)

If it don`t work.
Try with:
if mysql_query("sql", $cid)

ch.-

Last edited by cscgal : Nov 3rd, 2007 at 11:31 pm. Reason: Fake sig snipped

•

Join Date: Nov 2007

Posts: 13

Reputation: jaydude23 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

jaydude23

Offline

Newbie Poster

Re: PHP problem!

Nov 2nd, 2007

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<HTML>
<?php
if (empty($CSP_Name) || empty($Supervisor) || empty($Rep_Number) || empty($Department) || empty($Account_No) || empty($First_Name) || empty($Last_Name) || empty($Phone) || empty($ShipTo_Address) || empty($ShipTo_City) || empty($ShipTo_State) || empty($ShipTo_ZIP) || empty($Accept))
{echo "<h2>Please make sure you have filled in all required fields. Please use your browsers Back button</h2>\n";
 echo "<h2>******REQUEST WAS NOT SUBMITTED******</h2>\n";}
if (isset ($_POST['chk8'])) {
$req1 = "Pre Band Mailer\n";
} else {
$req1 = "None\n";
}
if (isset ($_POST['chk9'])) {
$req2 = "At Brand Mailer\n";
} else {
$req2 = "None\n";
}
if (isset ($_POST['chk10'])) {
$req3 = "Voice Welcome Kit\n";
} else {
$req3 = "None\n";
}
if (isset ($_POST['chk11'])) {
$req4 = "Welcome Kit (Scientific Atlanta)\n";
} else {
$req4 = "None\n";
}
if (isset ($_POST['chk12'])) {
$req5 = "Three Product Welcome Kit (Motorola)\n";
} else {
$req5 = "None\n";
}
if (isset ($_POST['chk13'])) {
$req6 = "...\n";
} else {
$req6 = "None\n";
}
if (isset ($_POST['chk14'])) {
$req7 = "...\n";
} else {
$req7 = "None\n";
}
$ShipTo_Address = stripcslashes($ShipTo_Address);
$Additional_Info = stripcslashes($Additional_Info);
?>
<?php
$usr = "national_twc";
$pwd = "timewarnercable";
$db = "national_test";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($REQUEST_METHOD=="POST") {
if (mysql_query("SELECT * FROM twc WHERE Account_No = $Account_No")) {
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");
}    else {
$SQL = " INSERT INTO twc ";
$SQL = $SQL . " (DATE, CSP_Name, Supervisor, Rep_Number, Department, Email, req1, req2, req3, req4, req5, req6, req7, Account_No, First_Name, Last_Name, Phone, ShipTo_Address, ShipTo_City, ShipTo_State, ShipTo_ZIP, Additional_Info, Accept) VALUES ";
$SQL = $SQL . " (now(), '$CSP_Name', '$Supervisor', '$Rep_Number', '$Department', '$Email', '$req1', '$req2', '$req3', '$req4', '$req5', '$req6', '$req7', '$Account_No', '$First_Name', '$Last_Name', '$Phone', '$ShipTo_Address', '$ShipTo_City', '$ShipTo_State', '$ShipTo_ZIP', '$Additional_Info', '$Accept') ";
$result = mysql_db_query($db,"$SQL",$cid);
}
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<center><h1>Thank You.</h1></center>\n");
echo ("<center>Please use back button to go back.</center>\n");
}
mysql_close($cid); 
?>
</HTML>
<HTML>
<?php
if (empty($CSP_Name) || empty($Supervisor) || empty($Rep_Number) || empty($Department) || empty($Account_No) || empty($First_Name) || empty($Last_Name) || empty($Phone) || empty($ShipTo_Address) || empty($ShipTo_City) || empty($ShipTo_State) || empty($ShipTo_ZIP) || empty($Accept))
{echo "<h2>Please make sure you have filled in all required fields. Please use your browsers Back button</h2>\n";
 echo "<h2>******REQUEST WAS NOT SUBMITTED******</h2>\n";}
if (isset ($_POST['chk8'])) {
$req1 = "Pre Band Mailer\n";
} else {
$req1 = "None\n";
}
if (isset ($_POST['chk9'])) {
$req2 = "At Brand Mailer\n";
} else {
$req2 = "None\n";
}
if (isset ($_POST['chk10'])) {
$req3 = "Voice Welcome Kit\n";
} else {
$req3 = "None\n";
}
if (isset ($_POST['chk11'])) {
$req4 = "Welcome Kit (Scientific Atlanta)\n";
} else {
$req4 = "None\n";
}
if (isset ($_POST['chk12'])) {
$req5 = "Three Product Welcome Kit (Motorola)\n";
} else {
$req5 = "None\n";
}
if (isset ($_POST['chk13'])) {
$req6 = "...\n";
} else {
$req6 = "None\n";
}
if (isset ($_POST['chk14'])) {
$req7 = "...\n";
} else {
$req7 = "None\n";
}
$ShipTo_Address = stripcslashes($ShipTo_Address);
$Additional_Info = stripcslashes($Additional_Info);
?>
<?php
$usr = "national_twc";
$pwd = "timewarnercable";
$db = "national_test";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($REQUEST_METHOD=="POST") {
if (mysql_query("SELECT * FROM twc WHERE Account_No = $Account_No")) {
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");
}    else {
$SQL = " INSERT INTO twc ";
$SQL = $SQL . " (DATE, CSP_Name, Supervisor, Rep_Number, Department, Email, req1, req2, req3, req4, req5, req6, req7, Account_No, First_Name, Last_Name, Phone, ShipTo_Address, ShipTo_City, ShipTo_State, ShipTo_ZIP, Additional_Info, Accept) VALUES ";
$SQL = $SQL . " (now(), '$CSP_Name', '$Supervisor', '$Rep_Number', '$Department', '$Email', '$req1', '$req2', '$req3', '$req4', '$req5', '$req6', '$req7', '$Account_No', '$First_Name', '$Last_Name', '$Phone', '$ShipTo_Address', '$ShipTo_City', '$ShipTo_State', '$ShipTo_ZIP', '$Additional_Info', '$Accept') ";
$result = mysql_db_query($db,"$SQL",$cid);
}
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<center><h1>Thank You.</h1></center>\n");
echo ("<center>Please use back button to go back.</center>\n");
}
mysql_close($cid); 
?>
</HTML>

Thanks for your help. I've believe I've changed what you told me to correctly. I'm posting my code again for you to double check me and point me in the right direction.

It seems its passing the check and the error message, and just adding the record to the db. Am I missing something? Please help me.

Thanks again

Jason

•

Join Date: Sep 2007

Location: Budapest

Posts: 252

Reputation: fatihpiristine has a little shameless behaviour in the past

Rep Power: 0

Solved Threads: 14

fatihpiristine fatihpiristine is offline

Offline

Posting Whiz in Training

Re: PHP problem!

Nov 2nd, 2007

you get empty record or you get full data you entered into fields. ??

Do a favour, leave me alone

•

Join Date: Nov 2007

Posts: 13

Reputation: jaydude23 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

jaydude23

Offline

Newbie Poster

Re: PHP problem!

Nov 2nd, 2007

I get a record entered with data each time. It does not check to see if the account number exists before adding it to the db.

Thanks

Jason

•

Join Date: Sep 2007

Location: Buenos Aires

Posts: 30

Reputation: chmazur is an unknown quantity at this point

Rep Power: 2

Solved Threads: 2

chmazur

Offline

Light Poster

Re: PHP problem!

Nov 2nd, 2007

On line 52, you are not select the DB yet.

mysql_select_db($db);

ch.-

Last edited by cscgal : Nov 3rd, 2007 at 11:30 pm. Reason: Fake signature removed: use signatures in member profiles

•

Join Date: Sep 2007

Location: Budapest

Posts: 252

Reputation: fatihpiristine has a little shameless behaviour in the past

Rep Power: 0

Solved Threads: 14

fatihpiristine fatihpiristine is offline

Offline

Posting Whiz in Training

Re: PHP problem!

Nov 3rd, 2007

dump your table into text document n zip it with this page n upload here.. i ll check it...

Do a favour, leave me alone

•

Join Date: Aug 2006

Posts: 32

Reputation: StatiX is an unknown quantity at this point

Rep Power: 3

Solved Threads: 2

StatiX

Offline

Light Poster

Re: PHP problem!

Nov 3rd, 2007

Starting from line 52:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
 
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM `twc` WHERE `Account_No` = ".$Account_No),0) or die(mysql_error());
 
if ($total_results > 0) {
// if one or more rows are returned an account with this id exists
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");
 
} else {
//no rows were returned so we can add data
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM `twc` WHERE `Account_No` = ".$Account_No),0) or die(mysql_error());

if ($total_results > 0) {
// if one or more rows are returned an account with this id exists
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");

} else {
//no rows were returned so we can add data

First you need to query the db and see if you get a result from the query. I'm not sure but the best I can remember the way it was would be true as the query would return true even if no rows matched your terms. You may also want to check to make sure that the Account_No variable is being processed correctly and passed correctly, this most likely where your problem lies as without this var being correct you will never get a correct query and all data would be added like your talking about. For testing you could echo $Account_No; just before its used in the query

Last edited by StatiX : Nov 3rd, 2007 at 11:13 pm.

Always do what you wish you could..

•

Join Date: Nov 2007

Posts: 13

Reputation: jaydude23 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

jaydude23

Offline

Newbie Poster

Re: PHP problem!

#10

Nov 5th, 2007

okay, I think I'm making head way with this little project. Thanks to all of you who have helped and guided me. I do appreciate it.

I have changed and update my code to include selecting the db and the SELECT statement.

Now when I execute it, I receive the following error:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Accounts\national\wwwRoot\new_datain.php on line 53
Access denied for user: 'national_twc@localhost' to database 'national_test'

I'll post my updated code here for you to review.

Once again thanks for all your help! I'll look forward to hearing from anyone.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<HTML>
<?php
if (empty($CSP_Name) || empty($Supervisor) || empty($Rep_Number) || empty($Department) || empty($Account_No) || empty($First_Name) || empty($Last_Name) || empty($Phone) || empty($ShipTo_Address) || empty($ShipTo_City) || empty($ShipTo_State) || empty($ShipTo_ZIP) || empty($Accept))
{echo "<h2>Please make sure you have filled in all required fields. Please use your browsers Back button</h2>\n";
 echo "<h2>******REQUEST WAS NOT SUBMITTED******</h2>\n";}
if (isset ($_POST['chk8'])) {
$req1 = "Pre Band Mailer\n";
} else {
$req1 = "None\n";
}
if (isset ($_POST['chk9'])) {
$req2 = "At Brand Mailer\n";
} else {
$req2 = "None\n";
}
if (isset ($_POST['chk10'])) {
$req3 = "Comcast Digital Voice Welcome Kit\n";
} else {
$req3 = "None\n";
}
if (isset ($_POST['chk11'])) {
$req4 = "Three Product Welcome Kit (Scientific Atlanta)\n";
} else {
$req4 = "None\n";
}
if (isset ($_POST['chk12'])) {
$req5 = "Three Product Welcome Kit (Motorola)\n";
} else {
$req5 = "None\n";
}
if (isset ($_POST['chk13'])) {
$req6 = "...\n";
} else {
$req6 = "None\n";
}
if (isset ($_POST['chk14'])) {
$req7 = "...\n";
} else {
$req7 = "None\n";
}
$ShipTo_Address = stripcslashes($ShipTo_Address);
$Additional_Info = stripcslashes($Additional_Info);
?>
<?php
$usr = "national_twc";
$pwd = "timewarnercable";
$db = "national_test";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($REQUEST_METHOD=="POST") {
mysql_select_db($db);
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM `twc` WHERE `Account_No` = ".$Account_No),0) or die(mysql_error());
if ($total_results > 0) {
// if one or more rows are returned an account with this id exists
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");
} else {
//no rows were returned so we can add data
$SQL = " INSERT INTO twc ";
$SQL = $SQL . " (DATE, CSP_Name, Supervisor, Rep_Number, Department, Email, req1, req2, req3, req4, req5, req6, req7, Account_No, First_Name, Last_Name, Phone, ShipTo_Address, ShipTo_City, ShipTo_State, ShipTo_ZIP, Additional_Info, Accept) VALUES ";
$SQL = $SQL . " (now(), '$CSP_Name', '$Supervisor', '$Rep_Number', '$Department', '$Email', '$req1', '$req2', '$req3', '$req4', '$req5', '$req6', '$req7', '$Account_No', '$First_Name', '$Last_Name', '$Phone', '$ShipTo_Address', '$ShipTo_City', '$ShipTo_State', '$ShipTo_ZIP', '$Additional_Info', '$Accept') ";
$result = mysql_db_query($db,"$SQL",$cid);
}
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<center><h1>Thank You.</h1></center>\n");
echo ("<center>Please use back button to go back.</center>\n");
}
mysql_close($cid); 
?>
</HTML>
<HTML>
<?php
if (empty($CSP_Name) || empty($Supervisor) || empty($Rep_Number) || empty($Department) || empty($Account_No) || empty($First_Name) || empty($Last_Name) || empty($Phone) || empty($ShipTo_Address) || empty($ShipTo_City) || empty($ShipTo_State) || empty($ShipTo_ZIP) || empty($Accept))
{echo "<h2>Please make sure you have filled in all required fields. Please use your browsers Back button</h2>\n";
 echo "<h2>******REQUEST WAS NOT SUBMITTED******</h2>\n";}
if (isset ($_POST['chk8'])) {
$req1 = "Pre Band Mailer\n";
} else {
$req1 = "None\n";
}
if (isset ($_POST['chk9'])) {
$req2 = "At Brand Mailer\n";
} else {
$req2 = "None\n";
}
if (isset ($_POST['chk10'])) {
$req3 = "Comcast Digital Voice Welcome Kit\n";
} else {
$req3 = "None\n";
}
if (isset ($_POST['chk11'])) {
$req4 = "Three Product Welcome Kit (Scientific Atlanta)\n";
} else {
$req4 = "None\n";
}
if (isset ($_POST['chk12'])) {
$req5 = "Three Product Welcome Kit (Motorola)\n";
} else {
$req5 = "None\n";
}
if (isset ($_POST['chk13'])) {
$req6 = "...\n";
} else {
$req6 = "None\n";
}
if (isset ($_POST['chk14'])) {
$req7 = "...\n";
} else {
$req7 = "None\n";
}
$ShipTo_Address = stripcslashes($ShipTo_Address);
$Additional_Info = stripcslashes($Additional_Info);
?>
<?php
$usr = "national_twc";
$pwd = "timewarnercable";
$db = "national_test";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($REQUEST_METHOD=="POST") {
mysql_select_db($db);
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM `twc` WHERE `Account_No` = ".$Account_No),0) or die(mysql_error());
if ($total_results > 0) {
// if one or more rows are returned an account with this id exists
echo ("<center><h1>Sorry. Your account is already added.</h1></center>\n");
} else {
//no rows were returned so we can add data
$SQL = " INSERT INTO twc ";
$SQL = $SQL . " (DATE, CSP_Name, Supervisor, Rep_Number, Department, Email, req1, req2, req3, req4, req5, req6, req7, Account_No, First_Name, Last_Name, Phone, ShipTo_Address, ShipTo_City, ShipTo_State, ShipTo_ZIP, Additional_Info, Accept) VALUES ";
$SQL = $SQL . " (now(), '$CSP_Name', '$Supervisor', '$Rep_Number', '$Department', '$Email', '$req1', '$req2', '$req3', '$req4', '$req5', '$req6', '$req7', '$Account_No', '$First_Name', '$Last_Name', '$Phone', '$ShipTo_Address', '$ShipTo_City', '$ShipTo_State', '$ShipTo_ZIP', '$Additional_Info', '$Accept') ";
$result = mysql_db_query($db,"$SQL",$cid);
}
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<center><h1>Thank You.</h1></center>\n");
echo ("<center>Please use back button to go back.</center>\n");
}
mysql_close($cid); 
?>
</HTML>