[SOLVED] Data not being added to database

[AKalair]

Hi guys,

I'm not developing a simple register page but despite saying the data's been added when I check it hasnt?

 

<?php

connect data




$query = "INSERT INTO users(username) VALUES({$_POST['username']}, 1)";



$result = mysql_query($query);

 

Any ideas Thanks.

 

 

echo "The data has been added to the database.";

 

 

 

?>

 

[ratcateme]

change

$result = mysql_query($query);

to

$result = mysql_query($query) or die(mysql_error());

also you have said one field but given 2 values

 

Scott.

[Garethp]

$Username = $_POST['username'];

$query = "INSERT INTO users(username) VALUES('$Username')";