Re: MySQL

Yes I'm new at this - sorry for sounding like an idiot. I'm a network guy, not a coder by any means - just learning. (Company "project") > First of all, get rid of all those extraneous open and close ( > ?><?php) tags that your editor put in - Done - it isn't the editor, I put them there - a lot of diffrent testing, and havn't had a changce to clean it up yet. >(or is this code cobbled from >other places?). No, that's plagerisum. :P Doing this all form a book I purchased which dosn't cover MySQL as much as I had hoped. Thats what I get for buying it online. :P >Second, the line in question is not valid PHP code. I figured as much, and did as you said, but it's still returning an error. >It's SQL. Put it in quotes, assign it to a variable, and call it >through a mysql_query() function. Error: Parse error: parse error, unexpected T_STRING in C:\FoxServ\www\encana_db.php on line 36 My new code: <?php $PHP_SELF = mysql_query(INSERT INTO gradients (kwo, lsd, date, well, field, uni, license, formation) VALUES ('$kwo', '$lsd', '$date', '$well', '$field', '$uni', '$license', '$formation') ) ?> > --- 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 > > 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