• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 571
  • Last Modified:

is there a same function for mssql_fetch_field and mssql_fetch_assoc in sql 2005 (odbc)

hello:

i am using ODBC connection in sql 2005. the following code, when i used in sql 2005, it shows invalid.

could some expert tell if is there a sinmiar function for mssql_fetch_field and mssql_fetch_assoc?

code attached.

thnak you so much
while ($row = mssql_fetch_field($result)) {
		echo($row->name."\t");
	}
	echo("\n");
	
	while ($row = mssql_fetch_assoc($result)) {
		foreach($row as $key=>$val) {
			$output = ($key == 'Address') ? '"'.str_replace('|', chr(10), $val).'"'."\t" : $val."\t";
					}

Open in new window

0
lilyyan
Asked:
lilyyan
  • 2
1 Solution
 
brad2575Commented:
0
 
lilyyanAuthor Commented:
i want to get the columns' names, but the following is not working

would you please help check? thank you so much!!
$SQL="SELECT * FROM mytable";
$result = odbc_exec($dsn, $SQL);
$result =odbc_fetch_array ($result);
$countField=1;
for (int $k=0; $k<sizeof($result); $k++){
echo odbc_field_name ($result , $countField )."\t";
$countField++;
}
	echo("\n")

Open in new window

0
 
brad2575Commented:
Here you go:

http://us2.php.net/manual/en/function.odbc-columns.php


and here is a full list of all the ODBC connection functions:
http://us2.php.net/odbc
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now