I cant add data to my DB but get no errors

[ptbsG_Man]

Hello, I am having some problems with my SQL today(last 4 days actuly) when i try to add data to my MS Access DB i dont get any errors but I also dont get any data in the DB, here is the code i am using

$rs = $db_connection->execute("INSERT INTO Users (Username, [Password], Access, First_Name, Last_Name, Phone)
VALUES '$username','$password', '$Access',  '$First_Name', '$Last_Name', '$Phone');

and this is what it makes if i echo the code

INSERT INTO Users (Username, [Password], Access, First_Name, Last_Name, Phone)
VALUES ('testest','098f6bcd4621d373cade4e832627b4f6','','test','test','')

any help would be great, Thanks.
Don

[maniac1aw]

First I would make sure the file permissions are ok for php to write for it. If this doesn't work i would use PHP's ability to use COM objects and change your syntax to ADO (like coding in ASP)

I had a lot of problems on a windows machine using ODBC with sql server and they all went away when I used ADO syntax. Feel free to use this class.

<?
//database abstraction layer 1.0//
//Nicholas LaDieu
//October 31, 2001
//MICROSOFT ADO IMPLEMENTATION//
//JUNE 12 2003//



//session_start();
$DESTROY_AR=array();
/////////////////

function destroy_all()
{
	global $DESTROY_AR;
	for ($i=0;$i<count($DESTROY_AR);$i++)
	{
		if (is_object($DESTROY_AR[$i]))
		{
			$temp=$DESTROY_AR[$i];
			$temp->destroy();
		}

}
}


class db
{
	var $db;

function db($dbname,$host,$user,$pass)
{
	global $DESTROY_AR;
	$db = new COM("ADODB.Connection");
	$db -> Open("DSN=$dbname;UID=$user;PWD=$pass");
	$this->db=$db;
	$DESTROY_AR[]=$this;
}
function return_db()
{
	return $this->db;
}

function destroy()
{
	$db=$this->db;
	$db -> Close();
	$db -> Release();
	$db=null;
	$this->db=$db;
}
}

class query
{
	var $connection;
	var $rs;
	var $i;
	var $total;
	var $sql;

function query($conn,$sql)
{
	global $DESTROY_AR;
	$this->sql=$sql;
	$rs = new COM("ADODB.RecordSet");
	$database=$conn->return_db();
	$this->connection=$conn;
	if (strtoupper(substr($sql,0,3))=="SEL")
	{
		$rs->Open($sql,$database, 3, 1);// or die("<HR>$sql<hr>");
		$fields=$rs->fields or die("<HR>$sql<hr>");
		$count=$fields->count();
		$this->total=$count;
		$this->rs=$rs;
	}
	else
	{

		$RecordSet = $database->Execute($sql);
	}
	$DESTROY_AR[]=$this;
}



function get($field_name)
{
	$rs=$this->rs;
	$temp=$rs->Fields($field_name);
	return $temp->value;
}
function get_num($field_name,$pos)
{
	$rs = new COM("ADODB.RecordSet");
	$conn=$this->connection;
	$database=$conn->return_db();
	$rs->Open($this->sql,$database, 3, 1);
	$fields=$rs->fields;
	$count=$fields->count();
	for ($i=0;$i<$pos;$i++)
	{
		$rs->MoveNext();
	}
	$temp=$rs->Fields($field_name);

	$rs -> Release();
	$rs = null;
	return $temp->value;	
}
function movenext()
{
	$rs=$this->rs;
	$rs->movenext();
	$this->rs=$rs;
}
function moveprevious()
{
	$rs=$this->rs;
	$rs->moveprevious();
	$this->rs=$rs;
}
function total()
{
	return $this->total;
}
function eof()
{
	$rs=$this->rs;
	if (!$rs -> EOF)
		return false;
	else
		return true;
}
function result_all()
{
	return "Error: Not Supported";
	//	odbc_result_all($this->rs);
}

//////////NEW June 12, 2003
function destroy()
{
	$rs=$this->rs;
	if (is_object($rs))
	{
		$rs -> Release();
		$rs = null;
	}
	$this->rs=$rs;
}

}
/*

$db=new db("uswa2","","sa","");
$rs=new Query($db,"select * from cms_pages;");
//echo $rs->get("name");

//echo $rs->get_num("name",4);

while (!($rs->eof()))
{
	echo $rs->get("name");
	$rs->movenext();
}



destroy_all();*/
?>