First, let me apologize if I'm reiterating something already said, but I'm new to the newsgroup.
What does mysql say the problem was? That is, if you put
echo mysql_error();
immediately after the query, what does it say?
Is it possible you have one of the fields set to be unique in your db and are trying to insert duplicate data?
Bill Anderson
Jeff wrote:
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
