mssql_result

Get result data (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
string mssql_result ( resource result, int row, mixed field )

Examples ( Source code ) » mssql_result


<?php

// Send a select query to MSSQL

$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');


// Check if there were any records

if(!mssql_num_rows($query))

{

    echo 'No records found';

}

else

{

    for($i = 0; $i < mssql_num_rows($query); ++$i)

    {

        echo mssql_result($query, $i, 'username'), PHP_EOL;

    }

}


// Free the query result

mssql_free_result($query);

?>



The above example will output something similar to:


Tom

Alex

Mike

Ross



Faster alternative to above example

<?php

// Send a select query to MSSQL

$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');


// Check if there were any records

if(!mssql_num_rows($query))

{

    echo 'No records found';

}

else

{

    while($row = mssql_fetch_array($query))

    {

        echo $row['username'], PHP_EOL;

    }

}


// Free the query result

mssql_free_result($query);

?>

Code Examples / Notes » mssql_result

goodrichnospam

The "i" parameter appears to be the row number. This was implied by checking mysql_result, which documents what the middle paramter specifies.

Change Language

mssql_bind
mssql_close
mssql_connect
mssql_data_seek
mssql_execute
mssql_fetch_array
mssql_fetch_assoc
mssql_fetch_batch
mssql_fetch_field
mssql_fetch_object
mssql_fetch_row
mssql_field_length
mssql_field_name
mssql_field_seek
mssql_field_type
mssql_free_result
mssql_free_statement
mssql_get_last_message
mssql_guid_string
mssql_init
mssql_min_error_severity
mssql_min_message_severity
mssql_next_result
mssql_num_fields
mssql_num_rows
mssql_pconnect
mssql_query
mssql_result
mssql_rows_affected
mssql_select_db

mssql_result

Get result data (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4) string mssql_result ( resource result, int row, mixed field )

Code Examples / Notes » mssql_result

Change Language

Get result data (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
string mssql_result ( resource result, int row, mixed field )