First of all, get rid of all those extraneous open and close (
?><?php) tags that your editor put in (or is this code cobbled from
other places?). Second, the line in question is not valid PHP code.
It's SQL. Put it in quotes, assign it to a variable, and call it
through a mysql_query() function.
--- Jeff <jroth1@telus.net> wrote:
> 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 )
>
> <?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>
>
> <?php
> 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 ?>">
> <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>
>
>
>
> "Jason Wong" <php-db@gremlins.biz> wrote in message
> 200308020214.46435.php-db@gremlins.biz">news:200308020214.46435.php-db@gremlins.biz...
> > 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 -> www.gremlins.biz
> > Open Source Software Systems Integrators
> > * Web Design & Hosting * Internet & Intranet Applications
> Development *
> > ------------------------------------------
> > Search the list archives before you post
> > http://marc.theaimsgroup.com/?l=php-db
> > ------------------------------------------
> > /*
> > Sometimes a man will tell his bartender things he'll never tell
> his doctor.
> > -- Dr. Phillip Boyce, "The Menagerie" ("The Cage"),
> > stardate unknown.
> > */
> >
=====
Mark Weinstock
mark_weinstock@yahoo.com
***************************************
You can't demand something as a "right" unless you are willing to fight to death to defend everyone else's right to the same thing.
***************************************
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
