หนูติดปัญหาการใช้ ADODB น่ะค่ะ จาก Code ในส่วนของ mysql_fetch_assoc ถ้าจะเอามาใช้ด้วย AdoDb จะต้องเขียนอย่างไรคะ

$SQL = $db->Execute("select * from products");
foreach ($record as $row) {
   echo $row.'<br />';
}

$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
$strConn->Open("PROVIDER=".$myDriver.";SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB2); 

$strSQL="";
$strSQL="select * from tb_user";

		//$strConn->SetFetchMode(ADODB_FETCH_ASSOC);
		//$objRec = new COM("ADODB.Recordset");
		//$objRec = $strConn->Execute($strSQL);

$objRec=$strConn->Execute($strSQL);

foreach($objRec as $objRec){ echo $objRec."<br>";}

$objRec = $DB->Execute("select * from tb_user");

foreach($objRec as $objRec)
  { 
    echo $objRec."<br>";
  }

$db = new COM("ADODB.Connection");
$dsn = "DRIVER={SQL Server}; SERVER={localhost};UID={sa};PWD={}; DATABASE={speApp1}";
$db->Open($dsn);


$objRec = $db->Execute("select * from tb_user");


    			while (!$objRec->EOF)
		{
			echo $objRec->Fields["name"]->Value."<br>";
			$objRec->MoveNext();
		}

$db = new COM("ADODB.Connection");
$dsn = "DRIVER={SQL Server}; SERVER={localhost};UID={sa};PWD={}; DATABASE={speApp1}";
$db->Open($dsn);

$objRec = $db->Execute("select * from tb_user");

foreach($objRec as $objRec)
  { 
    echo $objRec."<br>";
  }
  

<?php
// Set delay 1 second. 
sleep(1);

// Create connection connect to mysql database
$dbCon = mysql_connect('localhost', 'root', '1234') or die (mysql_error());

// Select database.
mysql_select_db('thailand', $dbCon) or die (mysql_error());

// Set encoding.
mysql_query('SET NAMES UTF8');

// Next dropdown list.
$nextList = isset($_GET['nextList']) ? $_GET['nextList'] : '';

switch($nextList) {
	case 'amphur':
		$provinceID = isset($_GET['provinceID']) ? $_GET['provinceID'] : '';
		$result = mysql_query("
			SELECT
				AMPHUR_ID,
				AMPHUR_NAME
			FROM
				amphur
			WHERE PROVINCE_ID = '{$provinceID}'
			ORDER BY CONVERT(AMPHUR_NAME USING TIS620) ASC;
		");
		break;
	case 'tumbon':
		$amphurID = isset($_GET['amphurID']) ? $_GET['amphurID'] : '';
		$result = mysql_query("
			SELECT
				DISTRICT_ID,
				DISTRICT_NAME
			FROM
				district
			WHERE AMPHUR_ID = '{$amphurID}'
			ORDER BY CONVERT(DISTRICT_NAME USING TIS620) ASC;
		");
		break;
}

$data = array();
while($row = mysql_fetch_assoc($result)) {
	$data[] = $row;
}

// Print the JSON representation of a value
echo json_encode($data);
?>