Error: Query was empty PHP form. What am I doing wrong?

C

Chris

New member
I am new to PHP and I was trying to build a simple form to submit data to my mysql database. However , every time I try to submit the data it comes back with "Error, Query was empty. What am I doing wrong?


form:
<form action="users.php" method="post">
username: <input type="text" name="name"><br>
email: <input type="text" name = "email"><br>
<input type="submit" value="Submit">
</form>




php:
<?php

define ('DB_NAME', 'mydbnamehere');
define ('DB_USER', mydbuserhere');
define ('DB_PASSWORD', 'mydbpasswordhere');
define ('DB_HOST', 'mydbhosthere');

$link = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD);

if (!$link) {
die ('Could not connect: ' . mysql_error() );
}

$db_selected = mysql_select_db (DB_NAME, $link);

if (!$db_selected) {
die ('Can\'t use ' . DB_NAME . ': ' . mysql_error () );
}

$value = $_POST['username'];
$value2 = $_POST['email'];

$sql = "INSERT INTO 'users' (username, email) VALUES ('$value', '$value2')";

if (!mysql_query($sq1)) {
die ('Error: ' .mysql_error() );
}

mysql_close ();
?>

Any help would be very much appreciated
 
Back
Top