Name: Anonymous 2010-12-16 11:25
I can't figure out what's fucked up with my insert SQL query in PHP:
HTML Form:
PHP page:
HTML Form:
<form method="POST" action="hw8b.php">
Name:<br />
<input type="text" name="name" /><br /><br />
City:<br />
<input type="text" name="city" /><br /><br />
Email:<br />
<input type="text" name="email" /><br /><br />
<input type="submit" value="Insert">
</form>PHP page:
<?php
$DBConnect = mysql_connect("localhost", "mylastname", "");
if (! $DBConnect)
{
echo "<P>Database not available";
}
$password = "myusername";
$userID = "mypassword";
$name = $_POST["name"];
$city = $_POST["city"];
$email = $_POST["email"];
mysql_select_db("myDBName");
$SQLstring = "INSERT INTO FANS VALUES(" . $name . ",'" . $city . "','" . $email . "');";
$QueryResult = mysql_query($SQLstring);