Hi... again. :P
Been working on this code all weekend, and I did take everyone's advice, but
I'm still getting the same error. "Error retrieving records. From line
"$result = mysql_query($query, $link_id) OR DIE("Error retrieving
records."); " of my code. When I first put the insert query in, it allowed
me to add one record, then started returning the error, and hasn't let me
enter another record since.
Here is the entire code.
<?PHP
$link_id = mysql_pconnect("localhost","admin","f1r3w0rks")
or die("Unable to connect to SQL server");
mysql_select_db("kodiak_db",$link_id)
or die("Unable to select database");
$PHP_SELF=$_SERVER['PHP_SELF'];
foreach ($_POST as $var=>$value) ${$var}=$value;
?>
<HTML>
<HEAD>
<TITLE>DB</TITLE>
</HEAD>
<BODY BGCOLOR="white">
<a href="index1.php"> Home </a>|<a href="list_db.php"> Display All </a>|<a
href=""> Search </a>
<BR>
Total Entries:
<BR><div align="center"><img src=http://dataguy/logo_small.jpg>
<BR><b>Encana Gradient Data Base</B><BR></div>
<div align="center">
<FORM METHOD="post" ACTION="<?php echo $PHP_SELF; ?>">
<HR><HR>
<PRE> <b>
<?php
$query = "INSERT INTO gradients (kwo, lsd, date, well, field, uni,
license, formation) values ('$kwo', '$lsd', '$date', '$well', '$field',
'$uni', '$license', '$formation')";
$result = mysql_query($query, $link_id) OR DIE("Error retrieving
records.");
?>
KWL WO#: <INPUT TYPE="text" NAME="kwo" VALUE="">
LSD: <INPUT TYPE="text" NAME="lsd" VALUE="">
Date Completed: <input type="text" name="date" value=""> Well
Name: <INPUT TYPE="text" NAME="well" VALUE="">
Fieled/Pool: <INPUT TYPE="text" NAME="field" VALUE="">
Unique: <INPUT TYPE="text" NAME="uni" VALUE="">
License #: <input type="text" name="license" value="">
Formation: <input type="text" name="formation" value="">
Perfs: <input type="text" name="perfs" value=""> Event
No.: <input type="text" name="event" value="">
Well Fluid Status: <input type="text" name="fluid" value=""> Well Status
Mode: <input type="text" name="mode" value="">
Well Status Type: <input type="text" name="type" value=""> Type
V/D/H: <input type="text" name="vdh" value="">
File Name: <input type="text" name="file" value="">
KB: <input type="text" name="kb" value="">
GRD: <input type="text" name="grd" value=""> Open
Hole: <input type="text" name="open" value="">
Sour: <input type="text" name="sour" value=""> Tubing
Size: <input type="text" name="tube" value="">
Landed @: <input type="text" name="landed" value=""> Casing
Size: <input type="text" name="casing" value="">
Landed @: <input type="text" name="landed2" value=""> Shut
In Date: <input type="text" name="shut_date" value="">
Shut In Time: <input type="text" name="shut_time" value=""> Pres
TUB/CAS KPAg: <input type="text" name="pres" value="">
Tag PBTD: <input type="text" name="tag" value="">
<br> <HR><HR>
<INPUT TYPE="submit" VALUE="Submit">
</PRE> </b>
</FORM>
</div>
<BR><BR>
</head>
</HTML>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
