RE: [PHP-DB] Here goes!

First off, Have you tried echoing the values upon submission to ensure they are being set in the form? Secondly, I would place all "data" code in another file for script processing - processRegistration.php would work well. If all values are being set... maybe look at: $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)"; Try: "INSERT INTO models (first, last, age, email, location, eye, hair, experience, aspirations, mtype) VALUES ('$first','$last','$age','$email', '$location','$eye','$hair','$experience','$aspirations','$mtype')"; Just a few thoughts here. Aaron -----Original Message----- From: John [mailto:johnx@inetgenesis.com] Sent: December 6, 2002 3:50 PM To: php-db@lists.php.net Subject: [PHP-DB] 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,&nbsp; $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?>"> &nbsp; <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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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>&nbsp;</p> <p> <input name="submit" type="submit" value="Submit"> </p> </div></td> <td width="43%">&nbsp;</td> </tr> </table> <p align="left">&nbsp; </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