$serverName="serverNamesqlexpress";$connectionInfo= array("Database"=>"dbName","UID"=>"username","PWD"=>"password");$conn=sqlsrv_connect($serverName,$connectionInfo);
if($conn===false) {
die(print_r(sqlsrv_errors(),true));
}$sql="SELECT Name, Comment
FROM Table_1
WHERE ReviewID=1";$stmt=sqlsrv_query($conn,$sql);
if($stmt===false) {
die(print_r(sqlsrv_errors(),true));
}// Make the first (and in this case, only) row of the result set available for reading.if(sqlsrv_fetch($stmt) ===false) {
die(print_r(sqlsrv_errors(),true));
}// Get the row fields. Field indices start at 0 and must be retrieved in order.
// Retrieving row fields by name is not supported by sqlsrv_get_field.$name=sqlsrv_get_field($stmt,0);
echo"$name: ";$comment=sqlsrv_get_field($stmt,1);
echo$comment;?>