// Error checking needed here: parse out invalid char's from incoming variables(like the apostrophe) . $DB = "dbproj1"; $HOST = "localhost"; $USRNAME = "dbs"; $PSSWD = "********"; if( !@mysql_connect($HOST, $USRNAME, $PSSWD) ) { print "Error connecting to $DB"; exit(0); } else { $sqlstr = "INSERT INTO vendor (name, phone, street, city, state, zip) VALUES ('$name', '$phone', '$street', '$city', '$state', '$zip');" ; $result = mysql_db_query($DB, $sqlstr) or die("There has been an error in the insert statement"); //************************************************************ // mysql_insert_id() // // This function returns the ID generated for an AUTO_INCREMENT column // by the previous INSERT query. // $last_inserted_id = mysql_insert_id(); ?>