INSERT help

[Anon]

I'm having some problems with inserting my form data into a MySQL database. Here is my code.

<?php
//connect to db
$cid = mysql_connect("Default","root");
$db = "decoyDB";

//insert data
if ($REQUEST_METHOD=="POST") {

$SQL = "INSERT INTO inventory (maker, circa, info, history, paid, est) VALUES ('$maker', '$circa','$info','$history, '$paid', '$est')";

$result = mysql_select_db($db) & mysql_query($SQL);

// check for error 
    if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");    } 
    echo ("<P><B>Record Added.</B></P>\n"); 
} 

mysql_close($cid);
?>

Any help would be greatly appreciated.

[tomhath]

Check to make sure the connection worked (you don't need a password?)

Make sure the select_db worked before you do the INSERT.

Ampersand is a bitwise "and", it would be best to use two separate statements and check the result of each, but if you want to combine them use the word "and" not a "&".

What error are you getting?

[Anon]

It doesn't display anything on the webpage...it just loads a blank page with the huge query in the URL. It's got me baffled.