Code: Select all
$result = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE user = '$loggedin'")) or die(mysql_error());
print "<form action="admin.php?action=edit" method="post">
<br>E-Mail: <input type="text" name="email" size="40" value="$result[email]">
<br>First Name: <input type="text" name="first" size="40" value="$result[first]">
<br>Last Name: <input type="text" name="last" size="40" value="$result[last]">
<br>Bio: <input type="text" name="bio" size="40" value="$result[bio]">
<input type="submit" value="Submit">
</form>";
$sql = "INSERT INTO users WHERE user= '$loggedin' (first, last, email, bio) VALUES ('','$first','$last','$email','$bio')";
$query = mysql_query($sql) or die ("ERROR :: " . mysql_error());
}Code: Select all
$sql = "INSERT INTO users WHERE user= '$loggedin' (first, last, email, bio) VALUES ('','$first','$last','$email','$bio')";thanks
edit i get this error also before i edit anything: ERROR :: You have an error in your SQL syntax near 'WHERE user= 'mroach' (first, last, email, bio) VALUES ('','','','','')' at line 1