Problem Inserting into multiple tables

[bmabma]

Greetings to all,

First of all, happy new year to everyone...

I am trying to insert a new record across 28 tables in my sql db. I'm using the following php script...............

<?php
include ("../config/config.inc");

// validate data
// start session and bring in session variables
session_start();

@$link = mysql_connect(SYSTEM,USERNAME,PASSWORD);
if(!$link)
{

echo "Database seems to be down";
exit;
}

mysql_select_db(DATABASE) or die( "Unable to select database");

$query = "INSERT into '01_general_info', '02_note_terms', '03_loan_status', '04_mort_prov', '05_participation', '06_grnd_lease', '07_appraisal', '08_environmental', '10_pro perty_sum', '11_single_fam', '12_multi_fam', '13_office', '14_Retail', '15_mall', '16_indust_man', '17_ind_ware', '18_ind_show', '19_hotel_motel', '20_hospital', '21_nursing_home', '22_assisted_living', '23_land', '24_other_coll', '25_mixed_use', '26_cash_flow',
'27_loan_chron', '28_doc_inventory' WHERE control_number= $POST['control_number'] AND asset_name= $POST['asset_name'] AND loan_number= $POST['loan_number'] AND entrydate= $POST['entrydate'] AND entryname= $POST['entryname'] AND email1= $POST['email1']";

$result = mysql_query($query);

if(!$result)
{
echo "<font color='red'>Error - Could not insert your data into the database. This Control Number can only be entered once.</font>";
mysql_close();
exit;

}

mysql_close();

echo"
you have created a new record successfully";

?>

The problem is - I get an error message.............

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /www/u/unicorpservi/htdocs/my_script.php on line xx.

In this case, the line where the error occurs is...
echo "<font color='red'>Error - Could not insert your data into the database.

Can someone help me find out what I am doing wrong??

Thanks

:queasy: :queasy:

my motto: There Is No Spoon

[bpat1434]

Try changing yoru query to this:

$query = "INSERT INTO `01_general_info`, `02_note_terms`, `03_loan_status`, `04_mort_prov`, `05_participation`, `06_grnd_lease`, `07_appraisal`, `08_environmental`, `10_pro perty_sum`, `11_single_fam`, `12_multi_fam`, `13_office`, `14_Retail`, `15_mall`, `16_indust_man`, `17_ind_ware`, `18_ind_show`, `19_hotel_motel`, `20_hospital`, `21_nursing_home`, `22_assisted_living`, `23_land`, `24_other_coll`, `25_mixed_use`, `26_cash_flow`, `27_loan_chron`, `28_doc_inventory` 
  WHERE control_number= '".$_POST['control_number']."'
    AND asset_name= '".$_POST['asset_name']."'
    AND loan_number= '".$_POST['loan_number']."'
    AND entrydate= '".$_POST['entrydate']."'
    AND entryname= '".$_POST['entryname']."'
    AND email1= '".$_POST['email1']."'";

~Brett

[bmabma]

to bpat1434 ,
Thanks for your response.
I changed the coding from this.................
$query = "INSERT into '01_general_info', '02_note_terms', '03_loan_status', '04_mort_prov', '05_participation', '06_grnd_lease', '07_appraisal', '08_environmental', '10_pro perty_sum', '11_single_fam', '12_multi_fam', '13_office', '14_Retail', '15_mall', '16_indust_man', '17_ind_ware', '18_ind_show', '19_hotel_motel', '20_hospital', '21_nursing_home', '22_assisted_living', '23_land', '24_other_coll', '25_mixed_use', '26_cash_flow',
'27_loan_chron', '28_doc_inventory' WHERE control_number= $POST['control_number'] AND asset_name= $POST['asset_name'] AND loan_number= $POST['loan_number'] AND entrydate= $POST['entrydate'] AND entryname= $POST['entryname'] AND email1= $POST['email1']";

to this..............

$query = "INSERT INTO 01_general_info, 02_note_terms, 03_loan_status, 04_mort_prov, 05_participation, 06_grnd_lease, 07_appraisal, 08_environmental, 10_pro perty_sum, 11_single_fam, 12_multi_fam, 13_office, 14_Retail, 15_mall, 16_indust_man, 17_ind_ware, 18_ind_show, 19_hotel_motel, 20_hospital, 21_nursing_home, 22_assisted_living, 23_land, 24_other_coll, 25_mixed_use, 26_cash_flow, 27_loan_chron, 28_doc_inventory
WHERE control_number= '".$POST['control_number']."'
AND asset_name= '".$POST['asset_name']."'
AND loan_number= '".$POST['loan_number']."'
AND entrydate= '".$POST['entrydate']."'
AND entryname= '".$POST['entryname']."'
AND email1= '".$POST['email1']."'";

and now I get the error message that is echoed in the original script.........

if(!$result)
{
echo "<font color='red'>Error - Could not insert your data into the database. This Control Number can only be entered once.</font>";
mysql_close();
exit;

}

any other suggestions???????/

[bpat1434]

Echo out the mysql_error() with that query...

$result = @mysql_query($query);
if(!$result)
{
  echo mysql_error().'<br>';
  echo "<font color='red'>Error - Could not insert your data into the database. This Control Number can only be entered once.</font>";
}

~Brett

[bmabma]

to bpat1434 ,

Here is the error after the echo.....................

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' '01_general_info', '02_note_terms', '03_loan_status', '04_mort_prov', '05_partic' at line 1

For some reason my php script will not execute with " " around the table names..ie.
"01_general_info" etc.

What is going on ???

[bpat1434]

Yeah... table names are to be surrounded by back ticks (`) not quotes...

~Brett