[RESOLVED] Retrieving Results From Query

[obrienkev]

Hi all,

How do I correctly return the id value below from one row of results?

$id doesn't have a value when it should.

Thanks.

	 $query = "SELECT id ".
	 		"FROM excel ".
			"WHERE name = '$fileName'";
	 $result = mssql_query($query) or die('Select File Error');
	 $num_results = mssql_num_rows($result);
	 $row = mssql_fetch_row($result);
	 $id = $row['id'];

[laserlight]

Use mssql_fetch_array() or mssql_fetch_assoc() instead of mssql_fetch_row().

[obrienkev]

Thanks.