This is the page that finally worked - I have had to drop the 'close'
bit:
<html>
<body>
<?php
$username="root";
$password='';
$database="mydb";
$localhost="127.0.0.1";
mysql_connect($localhost,$username,$password);
mysql_select_db($database) or die('failed to select DB');
$first = $HTTP_POST_VARS["first"];
$last = $HTTP_POST_VARS["last"];
$phone = $HTTP_POST_VARS["phone"];
$mobile = $HTTP_POST_VARS["mobile"];
$fax = $HTTP_POST_VARS["fax"];
$email = $HTTP_POST_VARS["e-mail"];
$web = $HTTP_POST_VARS["web"];
$query="INSERT INTO contacts VALUES
('','$first','$last','$phone','$mobile','$fax','$email','$web')";
$sth = mysql_query($query);
if (!$sth) { die("Query failed : " . mysql_error($sth) ); }
?>
</body>
</html>
Although there were parsing errors I now find most attempts to send
the form info to the table succeeeded. I now have many rows of
gibberish.
It's the wrong list, but virtual beers - or stronger tipple - all
round.
Thank you.
Joseph
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ 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.
