Why Wont this Work!

[skooter]

i do not understant why this will not work, it will go thru all the echo "passed" marks, but will not write to the mysql database, please someone help.

+-----------------------------------+
trim($username);
trim($pass);

if (!$username)
{
echo "enter Username";
exit;
}
if (!$pass)
{
echo "Enter Pass";
exit;
}

echo "Passed1";

$dbuser = 'design';

$dbhost = 'localhost';

$dbpass = 'xxxxxx';

$dbname = 'designman';

$dbtble = 'auth';

$mysql_link = mysql_connect($dbhost,$dbuser,$dbpass);

echo "Passed2";

if (!$mysql_link)
{
echo "Could Not Connect";
}

echo "Passed3";

mysql_select_db($dbname);
$query = "insert into auth values
('".$username."', '".$pass."')";
$result = mysql_query($query);
if ($result)
echo mysql_affected_rows()." inserted into database.";
+-----------------------------------+

[TheDude]

$query = "insert into auth values
('".$username."', '".$pass."')";
__________


try:

$query = "INSERT INTO auth(username, pass) VALUES('$username','$pass')";

it's a good habit to capitalize sql statements. your table will grow, you'll have more variables, field names, etc.
it's not necessary, but easier to read.

put vars in single quotes. even if you have only two columns (username and pass), it's a good habit to declare which is which.

if you have also an auto-increment-id field, it's safer anyway. don't let mysql guess where it has to insert what.

[skooter]

thank you it worked :-)