Dr. Robert Probst wrote:
IN MY (not MS) SQL I would try
mysql_data_seek ($result, 0);
to move the internal pointer to the first data row
I dont know at the moment if there is a similar function in the ms area.
maybe it helps
For MS-SQL, you mean mssql_data_seek($result, 0) ;)
http://es2.php.
a similar function in the ms area.
>
> maybe it helps
>
> robert
>
>
> > -UrsprÃngliche Nachricht-
> > Von: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]
> > Gesendet: Dienstag, 25. Mai 2004 20:30
> > An: [EMAIL PROTECTED]
> >
to:[EMAIL PROTECTED]
> Gesendet: Dienstag, 25. Mai 2004 20:30
> An: [EMAIL PROTECTED]
> Betreff: [PHP-WIN] MS SQL Query question
>
>
>
> When I run a query the syntax looks like this:
>
> $result = mssql_query($query);
> $numRows = mssql_num_rows($result);
>
can re-iterate through the
>$line array, again!
>************
>
>-TG
>
>
>> -Original Message-
>> From: Derrick Hermanson [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, May 25, 2004 3:05 PM
>> To: [EMAIL PROTECTED]; [EMAIL PROTECTED
call
This function resets the pointer and you can re-iterate through the
$line array, again!
-TG
> -Original Message-
> From: Derrick Hermanson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 25, 2004 3:05 PM
> To: [EMAIL PROTECTED]; [EMA
PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 1:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] MS SQL Query question
When I run a query the syntax looks like this:
$result = mssql_query($query);
$numRows = mssql_num_rows($result
When I run a query the syntax looks like this:
$result = mssql_query($query);
$numRows = mssql_num_rows($result);
for($i=0; $i<$numRows; $i++)
{
$row = mssql_fetch_array($result);
}
but if I go to try and loop through the resultset again it wont work
unless I run this line again "$result = mssq
