Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Microsoft SQL Server Functions : mssql_result

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


Follow Navioo On Twitter
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
eXTReMe Tracker