OK. Thanks for the suggestions. By hardcoding the db connection, I got rid of the errors. There may be something up with my php.ini file, pointing to a different include dir. Not sure. Don't care.
Now I simply need help with my form submittal - I'm not seeing any rows get added by my db with the following code:
<?php
$hostname="mysql213.secureserver.net";
$username="username";
$password="password";
$dbname="dbname";
$usertable="mailinglist";
mysql_connect($hostname,$username,$password);
mysql_select_db($dbname);
$FirstName = $_GET[‘FirstName’];
$LastName = $_GET[‘LastName’];
$EmailAddress = $_GET[‘EmailAddress’];
?>
<form action="<?php echo($_SERVER['PHP_SELF']); ?>" method=GET />
<p>First Name: <input type="text" name="FirstName" size="27" value="<?php echo $FirstName; ?>"><br>
Last Name: <input type="text" name="LastName" size="27" value="<?php echo $LastName; ?>"><br>
Email: <input type="text" name="EmailAddress" size="49" value="<?php echo $EmailAddress; ?>"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
<?php
mysql_query("INSERT INTO 'mailinglist' (FirstName,LastName,EmailAddress) VALUES ($FirstName,$LastName,$EmailAddress)");
?>
Any thoughts on why my data is not showing up? Have I screwed something up?
Thank you all so much for the help here...
dBforums
>
Trying to connect to MySQL using PHP
12-03-06, 00:40
Linear Mode
