Sorry, I just realized that's an older copy of the code, here is the updated stuff - 
(It's just one more line, the line that's giving me greaf. :P  )

   $link_id = mysql_connect("localhost","admin","*******")
            or die("Unable to connect to SQL server");
            or die("Unable to select database");


global $PHP_SELF


  // echo $results;


<BODY BGCOLOR="white">

<a href="index1.php"> Home </a>|<a href="list_db.php"> Display All
</a>|<a href=""> Search </a>
Total Entries: 
    $query = "SELECT COUNT(*) FROM gradients"; 
    $num_count = mysql_query($query) or die("Select Failed!"); 
    $count = mysql_fetch_array($num_count); 


<?php echo $count[0]; ?>
<BR><div align="center"><img src=http://dataguy/logo_small.jpg>

<BR><b>Title for page</B><BR></div>

INSERT INTO gradients (kwo, lsd, date, well, field, uni, license, formation) VALUES 
('$kwo', '$lsd', '$date', '$well', '$field', '$uni', '$license', '$formation') 

    <div align="center">
     <FORM METHOD="post" ACTION="<?php echo $PHP_SELF ?>">
<PRE> <b>

            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>



"Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> On Saturday 02 August 2003 01:46, Jeff wrote:
> > I tried doing this through the news server, but something messed up.
> >
> > I just need to know how to make an HTML form write to a MySQL DB.
> > This is what I have so far.
> [snip]
> And does it work? If it works then congratulations. If it doesn't work, *how* 
> doesn't it work.
> If you're new to all this, you might want to start by reading some of the 
> numerous tutorials available (google for them) and follow through a few of 
> them.
> -- 
> Jason Wong -> Gremlins Associates ->
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> ------------------------------------------
> Search the list archives before you post
> ------------------------------------------
> /*
> Sometimes a man will tell his bartender things he'll never tell his doctor.
> -- Dr. Phillip Boyce, "The Menagerie" ("The Cage"),
>    stardate unknown.
> */

Reply via email to