You're missing the mysql_query($sql) or die(mysql_error()); to actually fire the data into the db. Hope this helps. > -----Original Message----- > From: John [mailto:johnx@inetgenesis.com] > Sent: Friday, December 06, 2002 3:50 PM > To: php-db@lists.php.net > Subject: Here goes! > > > Thanks all! > > Brand spanking new here to PHP so I will paste all the code > below. I am using MySQL as my DB and i can modify the > information with the same username and password that is in > this code using a proprietary GUI administrator (navicat). > Unfortunately it will not enter the info via this submission > written below: > > <html> > <head> > <title>Portfolio Entry </title> > <meta http-equiv="Content-Type" content="text/html; > charset=iso-8859-1"> > </head> > > <body bgcolor="#FFEBEB"> > <?php > if ($submit) { > > $db=mysql_connect("66.220.69.20","*****","******"); > mysql_select_db("sammies models",$db); > $sql="INSERT INTO models (first, last, age, email, > location, eye, hair, experience, aspirations, mtype) > VALUES ($first, $last, $age, $email, $location, $eye, > $hair, $experience, $aspirations, $mtype)"; > die ("Error in Query: $sql. <BR>". mysql_error()); > echo "<b><center>Thank you for registering, $first > </b></center><p>"; > ?> > <p><center></p> > <center> > <a href="http://www.sammiesmodels.com"; target="_self">Return > to Sammies Models > Home</a> > <? } > > else { > ?> > </center> > <center> > <font face="Georgia, Times New Roman, Times, > serif"><strong>Submit Your Portfolio > Here:</strong></font> > </center> > <form name="entry" method="GET" action="<?php echo $PHP_SELF?>"> > > <table width="95%" border="0" cellspacing="0" cellpadding="0"> > <tr> > <td width="14%"><strong>First Name:</strong></td> > <td width="43%"><input name="first" type="text" size="30" > maxlength="45"></td> > <td width="43%"><font size="2" face="Arial, Helvetica, > sans-serif"> </font></td> > </tr> > <tr> > <td><strong>Last Name: </strong></td> > <td><input name="last" type="text" size="30" maxlength="45"></td> > <td><font size="2" face="Arial, Helvetica, > sans-serif"><strong>*Last name shall > not be used on the website, but</strong></font></td> > </tr> > <tr> > <td><strong>Age:</strong></td> > <td><input name="age" type="text" size="30" maxlength="3"></td> > <td><font size="2" face="Arial, Helvetica, > sans-serif"><strong>for internal use > only.</strong></font></td> > </tr> > <tr> > <td><strong>Email:</strong></td> > <td><input name="email" type="text" size="30" maxlength="45"></td> > <td><font size="2" face="Arial, Helvetica, > sans-serif"> </font></td> > </tr> > <tr> > <td><strong>Location:</strong></td> > <td><input name="location" type="text" id="location" > size="30" maxlength="60"></td> > <td><font size="2" face="Arial, Helvetica, > sans-serif"><strong>*Location- please > do not be specific, but only</strong></font></td> > </tr> > <tr> > <td><strong>Eye Color</strong></td> > <td><input name="eye" type="text" id="eye" size="30" > maxlength="45"></td> > <td><font size="2" face="Arial, Helvetica, > sans-serif"><strong>state or region.</strong></font></td> > </tr> > <tr> > <td><strong>Hair Color:</strong></td> > <td><input name="hair" type="text" id="hair" size="30" > maxlength="45"></td> > <td><font size="2" face="Arial, Helvetica, > sans-serif"> </font></td> > </tr> > <tr> > <td valign="top"><strong>Experience:</strong></td> > <td><textarea name="experience" cols="60" rows="10" > id="experience"></textarea></td> > <td valign="top"><font size="2" face="Arial, Helvetica, > sans-serif"><strong>* > Any experience pertaining to your talent aspirations- school > plays, photoshoots, > etc..</strong></font></td> > </tr> > <tr> > <td valign="top"><strong>Aspirations:</strong></td> > <td><textarea name="aspirations" cols="60" rows="10" > id="aspirations"></textarea></td> > <td valign="top"><font size="2" face="Arial, Helvetica, > sans-serif"> </font></td> > </tr> > <tr> > <td valign="top"><strong>Media Type:</strong></td> > <td><textarea name="mtype" cols="60" rows="10" > id="mtype"></textarea></td> > <td valign="top"><font size="2" face="Arial, Helvetica, > sans-serif"><strong>*Media > type includes specific types of jobs/ offers you are > interested in. </strong></font></td> > </tr> > </table> > <table width="95%" border="0" cellspacing="0" cellpadding="0"> > <tr> > <td width="57%"> <div align="right"> > <p> </p> > <p> > <input name="submit" type="submit" value="Submit"> > </p> > </div></td> > <td width="43%"> </td> > </tr> > </table> > <p align="left"> </p> > </form> > <? > } > > ?> > > > </body> > </html> > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.426 / Virus Database: 239 - Release Date: 12/2/2002 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
