On entering data in the form when we press submit it returns Error! Could not insert values: Query was empty and the same type of script is working with another table with just five fields It is wierd I wasted three days on it SO please look at the code and suggest the problem. Lots of thanks for help !!!! <html> <head> </head> <body> <? //initilize PHP if($_POST['submit']) //If submit is hit { $connect = mysql_pconnect(localhost, hoodad, mysql); mysql_select_db("test"); /*drop table if exists sitelocation; $result=create table sitelocation(SiteLabel varchar(3) UNIQUE, SiteDate date, Watershed varchar(25), SubBasin varchar(25), Country varchar(25), DigitHydrologicUnitCode_6 varchar(6), DigitHydrologicUnitCode_8 varchar(8), DigitHydrologicUnitCode_11 varchar(11), GAPSegmentType varchar(15), GAPSegmentLength int, StreamOrder varchar(2), StreamName varchar(30), UTMzone int, UTMeast int, TMnorth int, LegalDescription varchar(25), OmernikEcoregion varchar(5), BaileyEcoregion varchar(7), NearestTown varchar(25), RiverMile int, DrivingDirections varchar(200), PRIMARY KEY(SiteLabel)); if( mysql_query( $result ) ) echo( "Table created successfully." ); else die( "Error! Could not create a table: " . mysql_error() ); */ //$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$4 //convert all the posts to variables: $SiteLabel = $_POST['SiteLabel']; $SiteDate = $_POST['SiteDate']; $Watershed = $_POST['Watershed']; $SubBasin = $_POST['SubBasin']; $Country = $_POST['Country']; $DigitHydrologicUnitCode_6 = $_POST['DigitHydrologicUnitCode_6']; $DigitHydrologicUnitCode_8 = $_POST['DigitHydrologicUnitCode_8']; $DigitHydrologicUnitCode_11 = $_POST['DigitHydrologicUnitCode_11']; $GAPSegmentType = $_POST['GAPSegmentType']; $GAPSegmentLength = $_POST'GAPSegmentLength']; $StreamOrder = $_POST['StreamOrder']; $StreamName = $_POST['StreamName']; $UTMzone = $_POST['UTMzone']; $UTMeast = $_POST['UTMeast']; $TMnorth = $_POST['TMnorth']; $LegalDescription = $_POST['LegalDescription']; $OmernikEcoregion = $_POST['OmernikEcoregion']; $BaileyEcoregion = $_POST['BaileyEcoregion']; $NearestTown = $_POST['NearestTown']; $riverMile = $_POST['RiverMile']; $DrivingDirections = $_POST['DrivingDirections']; //Insert the values into the correct database with the right fields $result=MYSQL_QUERY("insert into sitelocation (SiteLabel,SiteDate,Watershed,SubBasin,Country, DigitHydrologicUnitCode_6,DigitHydrologicUnitCode_8,DigitHydrologicUnitCode_11,GAPSegmentType, GAPSegmentLength,StreamOrder, StreamName, UTMzone,UTMeast,TMnorth,LegalDescription, OmernikEcoregion,BaileyEcoregion,NearestTown,RiverMile, DrivingDirections) values ('SiteLabel','SiteDate','Watershed','SubBasin','Country', 'DigitHydrologicUnitCode_6','DigitHydrologicUnitCode_8','DigitHydrologicUnitCode_11','GAPSegmentType', 'GAPSegmentLength','StreamOrder', 'StreamName','UTMzone','UTMeast','TMnorth','LegalDescription', 'OmernikEcoregion','BaileyEcoregion','NearestTown','RiverMile','DrivingDirections')"); if( mysql_query( $result ) ) echo( "Values inserted successfully." ); else die( "Error! Could not insert values: " . mysql_error() ); echo "Query Finished<br>"; echo "---------------<br><br>"; echo "CONTENTS of the TABLE LOCATION are : <br>"; $result = mysql_query("select * from sitelocation") or die(mysql_error()); while($r=mysql_fetch_array($result)) { echo "CONTENTS of the TABLE LOCATION are vccvcvc: <br>"; $SiteLabel =$r["SiteLabel"]; $SiteDate =$r["SiteDate"]; $Watershed =$r["Watershed"]; $SubBasin =$r["SubBasin"]; $Country =$r["Country"]; $DigitHydrologicUnitCode_6 =$r["DigitHydrologicUnitCode_6"]; $DigitHydrologicUnitCode_8 =$r["DigitHydrologicUnitCode_8"]; $DigitHydrologicUnitCode_11 =$r["DigitHydrologicUnitCode_11"]; $GAPSegmentType =$r["GAPSegmentType"]; $GAPSegmentLength =$r["GAPSegmentLength"]; $StreamOrder =$r["StreamOrder"]; $StreamName =$rT["StreamName"]; $UTMzone =$r["UTMzone"]; $UTMeast =$r["UTMeast"]; $TMnorth =$r["TMnorth"]; $LegalDescription =$r["LegalDescription"]; $OmernikEcoregion =$r["OmernikEcoregion"]; $BaileyEcoregion =$r["BaileyEcoregion"]; $NearestTown =$r["NearestTown"]; $RiverMile =$r["RiverMile"]; $DrivingDirections =$r["DrivingDirections"]; echo "$SiteLabel $SiteDate $Watershed $SubBasin $Country $DigitHydrologicUnitCode_6<br>"; echo "$DigitHydrologicUnitCode_8 $DigitHydrologicUnitCode_11 $GAPSegmentType<br>"; echo "$GAPSegmentLength $StreamOrder $StreamName $UTMzone $UTMeast<br>"; echo "$TMnorth $LegalDescription $OmernikEcoregion $BaileyEcoregion $NearestTown<br>"; echo "$RiverMile $DrivingDirections<br>"; } } else { // close php so we can put in our code ?> <form method="post" action="insert_location.php"> <TABLE> <TR> <TD>SiteLabel:</TD> <TD><INPUT TYPE='TEXT' NAME='SiteLabel' VALUE='' size=60></TD> </TR> <TR> <TD>SiteDate:</TD> <TD><INPUT TYPE='TEXT' NAME='SiteDate' VALUE='' size=60></TD> </TR><br> <TR> <TD>Watershed:</TD> <TD><INPUT TYPE='TEXT' NAME='Watershed' VALUE='' size=60></TD> </TR> <TR> <TD>SubBasin:</TD> <TD><INPUT TYPE='TEXT' NAME='SubBasin' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>Country:</TD> <TD><INPUT TYPE='TEXT' NAME='Country' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>6DigitHydrologicUnitCode:</TD> <TD><INPUT TYPE='TEXT' NAME='DigitHydrologicUnitCode_6' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>8DigitHydrologicUnitCode:</TD> <TD><INPUT TYPE='TEXT' NAME='DigitHydrologicUnitCode_8' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>11DigitHydrologicUnitCode:</TD> <TD><INPUT TYPE='TEXT' NAME='DigitHydrologicUnitCode_11' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>GAPSegmentType:</TD> <TD><INPUT TYPE='TEXT' NAME='GAPSegmentType' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>GAPSegmentLength:</TD> <TD><INPUT TYPE='TEXT' NAME='GAPSegmentLength' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>StreamOrder:</TD> <TD><INPUT TYPE='TEXT' NAME='StreamOrder' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>StreamName:</TD> <TD><INPUT TYPE='TEXT' NAME='StreamName' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>UTMzone:</TD> <TD><INPUT TYPE='TEXT' NAME='UTMzone' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>UTMeast:</TD> <TD><INPUT TYPE='TEXT' NAME='UTMeast' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>TMnorth:</TD> <TD><INPUT TYPE='TEXT' NAME='TMnorth' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>LegalDescription:</TD> <TD><INPUT TYPE='TEXT' NAME='LegalDescription' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>OmernikEcoregion:</TD> <TD><INPUT TYPE='TEXT' NAME='OmernikEcoregion' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>BaileyEcoregion:</TD> <TD><INPUT TYPE='TEXT' NAME='BaileyEcoregion' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>NearestTown:</TD> <TD><INPUT TYPE='TEXT' NAME='NearestTown' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>RiverMile:</TD> <TD><INPUT TYPE='TEXT' NAME='RiverMile' VALUE='' size=60></TD> </TR> <TR> <TR> <TD>DrivingDirections:</TD> <TD><INPUT TYPE='TEXT' NAME='DrivingDirections' VALUE='' size=60></TD> </TR> <TR> <TR> <TD></TD><br> <TD><INPUT TYPE="submit" name="submit" value="submit"></TD> </TR> </TABLE> </form> <? } //close the else statement ?> </body> </html> &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&77 Structure of the Sitelocation Table is : +----------------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------------+--------------+------+-----+---------+-------+ | SiteLabel | char(3) | | PRI | | | | SiteDate | date | YES | | NULL | | | Watershed | varchar(25) | YES | | NULL | | | SubBasin | varchar(25) | YES | | NULL | | | Country | varchar(25) | YES | | NULL | | | DigitHydrologicUnitCode_6 | varchar(6) | YES | | NULL | | | DigitHydrologicUnitCode_8 | varchar(8) | YES | | NULL | | | DigitHydrologicUnitCode_11 | varchar(11) | YES | | NULL | | | GAPSegmentType | varchar(15) | YES | | NULL | | | GAPSegmentLength | int(11) | YES | | NULL | | | StreamOrder | char(2) | YES | | NULL | | | StreamName | varchar(30) | YES | | NULL | | | UTMzone | int(11) | YES | | NULL | | | UTMeast | int(11) | YES | | NULL | | | TMnorth | int(11) | YES | | NULL | | | LegalDescription | varchar(25) | YES | | NULL | | | OmernikEcoregion | varchar(5) | YES | | NULL | | | BaileyEcoregion | varchar(7) | YES | | NULL | | | NearestTown | varchar(25) | YES | | NULL | | | RiverMile | int(11) | YES | | NULL | | | DrivingDirections | varchar(200) | YES | | NULL | | +----------------------------+--------------+------+-----+---------+-------+ 21 rows in set (0.00 sec)