<HTML
><HEAD
><TITLE
>mssql_next_result</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="Manual de PHP"
HREF="index.html"><LINK
REL="UP"
TITLE="Funciones de Microsoft SQL Server"
HREF="ref.mssql.html"><LINK
REL="PREVIOUS"
TITLE="mssql_min_message_severity"
HREF="function.mssql-min-message-severity.html"><LINK
REL="NEXT"
TITLE="mssql_num_fields"
HREF="function.mssql-num-fields.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-1"></HEAD
><BODY
CLASS="refentry"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Manual de PHP</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.mssql-min-message-severity.html"
ACCESSKEY="P"
>Anterior</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.mssql-num-fields.html"
ACCESSKEY="N"
>Siguiente</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.mssql-next-result"
></A
>mssql_next_result</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN41835"
></A
><P
> (PHP 4 >= 4.0.5)</P
>mssql_next_result -- Move the internal result pointer to the next result</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN41838"
></A
><H2
>Description</H2
>bool <B
CLASS="methodname"
>mssql_next_result</B
> ( int result_id)<BR
></BR
><P
> When sending more than one SQL statement to the server or
executing a stored procedure with multiple results, it will cause
the server to return multiple result sets. This function will
test for additional results available form the server. If an
additional result set exists it will free the existing result set
and prepare to fetch the rows from the new result set. The
function will return <TT
CLASS="constant"
><B
>TRUE</B
></TT
> if an additional result set was
available or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> otherwise.
</P
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN41849"
></A
><P
><B
>Ejemplo 1. <B
CLASS="function"
>mssql_next_result()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="php"
><?php
$link = mssql_connect ("localhost", "userid", "secret");
mssql_select_db("MyDB", $link);
$SQL = "Select * from table1 select * from table2";
$rs = mssql_query($SQL, $link);
do {
while ($row = mssql_fetch_row($rs)) {
}
} while (mssql_next_result($rs));
mssql_free_result($rs);
mssql_close ($link);
?></PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="function.mssql-min-message-severity.html"
ACCESSKEY="P"
>Anterior</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Inicio</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.mssql-num-fields.html"
ACCESSKEY="N"
>Siguiente</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>mssql_min_message_severity</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.mssql.html"
ACCESSKEY="U"
>Subir</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>mssql_num_fields</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
