Insert/create querry runs from mysql prompt but ot in PHP

devhooda

My PHP code is trying to create a table and insert some values in that and now
if I run the querry from sql prompt by reading form a file it is working and table is created and I can insert values in a single row by querry

but

if I us ePHPa nd HTML and try to make a FORM to enter the field values in the database and by submiting the form I tryto insert values in the database

it returns a enmpty querry error

" Error! Could not insert values: Query was empty"
can some body help me here

thanks

Davender

devinemke

devhooda wrote:
can some body help me here

not without seeing the code

cyberlew15

I think that you need to know how to send a query to mysql so please follow the following links and just read

http://uk.php.net/manual/en/ref.mysql.php
http://uk.php.net/manual/en/function.mysql-query.php
http://uk.php.net/manual/en/function.mysql-connect.php

hopefully this will help you otherwise post the code and we'll try to help you out 😉

devhooda

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 !!!!

<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 :

devhooda

Thanks Cyberlew15
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.

cyberlew15

at the moment this code does not work re-post with your code and then I will sandbox and return updated files