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: 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
