Jump to content


  • Posts

  • Joined

  • Last visited

  • Donations

  • Country

    United States

About devhooda

devhooda's Achievements



  1. Thanks a lot and very sorry for the inconvenience as I am sort of new to this. this is the echo CODE +++++++++++++++++++++++++++ echo "$SiteLabel $SiteDate $Watershed $SubBasin $Country $DigitHydrologicUnitCode_6 "; echo " $DigitHydrologicUnitCode_8 $DigitHydrologicUnitCode_11 $GAPSegmentType "; echo " $GAPSegmentLength $StreamOrder $StreamName $UTMzone $UTMeast "; echo " $TMnorth $LegalDescription $OmernikEcoregion $BaileyEcoregion $NearestTown "; echo " $RiverMile $DrivingDirections <br>"; <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< The above echo gives out the http://coers6000.sdstate.edu/~hoodad/Sitel..._updated_DB.php you can see the output at the above link
  2. Yes that is right but reduces multiple white spaces to single white spaces In my case I have a very big text in one line so it does not fit in one line and goes to second line (I want to display it if we can see the side scrolling) http://coers6000.sdstate.edu/~hoodad/Sitel..._updated_DB.php My script is on this link you can see there what is the probelm I want to keep one row of the database in one line only, where part of the fields are visible on the screen I want to use the scroll bar at the bottom to see the part of the fields hidden Thanks for your help I tried to explain but u mayhave questions about what I need.
  3. Thanks Dmon that works thanks a lot I have nother problem: when I echo " .......contents of the 21 fields in DB......" and display in the browser the rows of the tables are wrapped (means one row is bigger than the desktop screen size there for one row breaks and half part of one low is displayed in the second line), is there any way I can display it as a single line as scroling on the side bar of the browser , it looks like this : but i want all of line 1 in a single line and line no. 2 in second line : 1 0000-00-00 Missouri Bad Jackson 3.3113E+113208 4 S Fork Bad River 14 2726654866378 T1S R19E SEC 34 43F 331Fs Cottonwood96 "I-90 exit 143. S on 73 2 0000-00-00 Missouri Bad Jackson 3.3113E+113304 5 S Fork Bad River 14 2772304869889 T1S R20E SEC 19 43F 331Fs Cottonwood90 "From Cottonwood please suggest some thing thanks a lot gor great help.
  4. 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)
  5. createand insert doew not work from a php file but works when i execute the txt file on mysql prompt. create and insert works from commandline of mysql from PHP sctipt I am trying to enter values into a web form and submit the values to the table in database. after hitting submit I get this error Error! Could not insert values: Query was empty pls help me here regards Davender

  • Create New...