updateing a mysql table

[Smifffy]

this doesn't seem to work can any one help?

<?
// database configuration
$host = "localhost";
$user = "root";
$pass = "";
$db = "test";

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// generate and execute query
$query = "INSERT into login values ('0', '$addusername', '$addpassword', '$addemail', '$addlevel')";

echo "$addusername', '$addpassword', '$addemail', '$addlevel'";


?>

the table does exist andall the veribles do work

thanks

[jc94062]

Use mysql_query.

[rharter]

try doing an

echo mysql_error();

to see what the db is complaining about

[jc94062]

Your not going to get an error, there is no query performed on that code at the moment.

[Smifffy]

how do i do the mysql_query thingie

[nilskilander]

$result = db_query($query);