Hi!

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.



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

 <?php

global $PHP_SELF

   ?>

 <?php
  // echo $results;
   ?>


<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: 
<?php
    $query = "SELECT COUNT(*) FROM gradients"; 
    $num_count = mysql_query($query) or die("Select Failed!"); 
    $count = mysql_fetch_array($num_count); 

?>
 
<A HREF="
<?$PHP_SELF?>

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

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

    <div align="center">
     <FORM METHOD="post" ACTION="<?php echo $PHP_SELF ?>">
  <HR><HR>
<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>
</FORM>
</div>


<BR><BR>

</head>
</HTML>

Reply via email to