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:

<title>Portfolio Entry </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<body bgcolor="#FFEBEB">
if ($submit) {
  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>";
<a href=""; target="_self">Return to Sammies Models 
<? }

else {
<font face="Georgia, Times New Roman, Times, serif"><strong>Submit Your Portfolio 
<form name="entry" method="GET" action="<?php echo $PHP_SELF?>">
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<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>
<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>
<td><input name="age" type="text" size="30" maxlength="3"></td>
<td><font size="2" face="Arial, Helvetica, sans-serif"><strong>for internal use 
<td><input name="email" type="text"  size="30" maxlength="45"></td>
<td><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></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>
<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 
<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>
<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, 
<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>
<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. 
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<td width="57%"> <div align="right">
<input name="submit" type="submit" value="Submit">
<td width="43%">&nbsp;</td>
<p align="left">&nbsp; </p>



Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.426 / Virus Database: 239 - Release Date: 12/2/2002

Reply via email to