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
Full Version: insert and create not working in PHP script but
Can you post the SQL script?
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 !!!!
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 !!!!
CODE
<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)
<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)
First, please use code tags. (or quote tags if code tags alter the code, like they did when I tried them here)
At a glance it looks like this string is wrong.
try it like
At a glance it looks like this string is wrong.
QUOTE
$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,River
Mile, 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 ) )
you are including "mysql_query" in the actual query string.DigitHydrologicUnitCode_6,DigitHydrologicUnitCode_
8,DigitHydrologicUnitCode_11,GAPSegmentType,
GAPSegmentLength,StreamOrder, StreamName, UTMzone,UTMeast,TMnorth,LegalDescription,
OmernikEcoregion,BaileyEcoregion,NearestTown,River
Mile, 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 ) )
try it like
QUOTE
$result="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,River
Mile, 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 ) )
DigitHydrologicUnitCode_6,DigitHydrologicUnitCode_
8,DigitHydrologicUnitCode_11,GAPSegmentType,
GAPSegmentLength,StreamOrder, StreamName, UTMzone,UTMeast,TMnorth,LegalDescription,
OmernikEcoregion,BaileyEcoregion,NearestTown,River
Mile, 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 ) )
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.
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.
try replacing the blank spaces in your output string with non-breaking spaces ( ) That will stop it from wrapping.
1 0000-00-00 Missouri Bad Jackson 3.3113E+.... etc.
1 0000-00-00 Missouri Bad Jackson 3.3113E+.... etc.
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.
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.
QUOTE
but reduces multiple white spaces to single white spaces
no, use one for each space you want to insert. The browser is wrapping on the blank space, if you replace them all with it won't wrap and will display horiz. scrollbar.
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
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
@devhooda:
Please click the "reply" button to post something.
The "report" button is *NOT* for posting, its for REPORTING wrong-doing by some other member, to the mods or admins.
Please click the "reply" button to post something.
The "report" button is *NOT* for posting, its for REPORTING wrong-doing by some other member, to the mods or admins.
No inconvenience, that's what MSFN is for! 
look at "source" in browser you will see you still have many blank spaces. It will wrap on the first one it Finds. try the php str_replace() function to convert all " " to
you also should pad your individual data item strings to standard length so columns line up, else put them in a table.
http://us2.php.net/manual/en/function.str-replace.php
look at "source" in browser you will see you still have many blank spaces. It will wrap on the first one it Finds. try the php str_replace() function to convert all " " to
you also should pad your individual data item strings to standard length so columns line up, else put them in a table.
http://us2.php.net/manual/en/function.str-replace.php
CODE
$htmlout = "1 0000-00-00 Missouri Bad Jackson 3.3113E+11 3208 4 S Fork Bad River ......."
$htmlout = str_replace(" ", " ", $htmlout);
echo $htmlout
$htmlout = str_replace(" ", " ", $htmlout);
echo $htmlout
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.