From: "Matt Warden" <[EMAIL PROTECTED]>
>
>
> Joseph,
>
> Joseph Harris wrote:
> > <?php
> > //connect to server and select database - organise include
> > $conn = mysql_connect("localhost", "root", "") or die(mysql_error());
> > mysql_select_db("loop",$conn) or die(mysql_error());
> > ?>
> >
> > And this works - in small test files both as a cut and paste and as an
> > include(). I am just foxed by what is making it fail in the script as
a
> > whole.
>
> Could you include the code from where you include() the above to where
> you are calling the INSERT that is generating your referenced error?
>
>
> - --
> Matt Warden
> Miami University
> Oxford, OH, USA
> http://mattwarden.com
>
Here it is Matt:
<?php
include $_SERVER['DOCUMENT_ROOT'].
'/www.looperman-is-ready.com/layout.php';
//set some variables
$_SERVER['DOCUMENT_ROOT'].
'/www.looperman-is-ready.com/includes/db_connect_loop.php';
$email_error = false;
$req = (!isset($_REQUEST['req'])) ? 'default' : $_REQUEST['req'];
switch($req){
case "process" : // code to process signup input and place in database
// myheader("Happy Birthday");
$errors = "<h4>Form Input Errors:".
"</h4>\n\n";
//Validate all required fields were posted
if(!$_POST['first_name'] ||
!$_POST['last_name'] ||
!$_POST['email_address'] ||
!$_POST['country'] ||
!$_POST['birthdate']){
$error = true;
if (!$_POST['first_name']) {
$errors .= "Missing first Name\n";
}
if (!$_POST['last_name']) {
$errors .= "Missing Last Name\n";
}
if (!$_POST['email_address']) {
$errors .= "Missing Email Address\n";
$email_error = true;
}
if (!$_POST['country']) {
$errors .="Missing Country\n";
}
if (!$_POST['birthdaye']) {
$errors .= "Missing Birthdate\n";
}
}
footer();
exit;
//All checks have passed; insert user in database
$sql = @mysql_query("INSERT INTO loop_allname (first_n, last_n,
email_address, birth, countryID, is_current, start)
VALUES('$_POST[first_name]',
'$_POST[last_name]',
'$_POST[email_address]',
'$_POST[birthdate]',
'$_POST[country]',
1,
now(),
)");
if (!$sql) {
echo 'error inserting your information into MySQL; '
.mysql_error();
footer();
exit();
}
---and I've had the quotes both on and off the figure 1 in the values.
Thanks for taking a look.
Joseph
____ The WDVL Discussion List from WDVL.COM ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
