PHP: mssql_field_seek - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

mssql_field_type mssql_field_name

Last updated: Fri, 26 Jan 2007

view this page in

# mssql_field_seek

(PHP 3, PHP 4, PHP 5)

mssql_field_seek -- Seeks to the specified field offset

## Description

bool mssql_field_seek ( resource result, int field_offset )

Seeks to the specified field offset. If the next call to mssql_fetch_field() won't include a field offset, this field would be returned.

Возвращает `TRUE` в случае успешного завершения или `FALSE` в случае возникновения ошибки.

See also mssql_fetch_field().

add a note User Contributed Notes
mssql_field_seek
kevin_tom at hotmail dot com
15-May-2004 02:47
`Don't know this would help.
If you are using mssql to loop through a web page. Here is how to do it:
Suppose you want to select a few fields from t1 joining to t2
$numPerPage=10;
if(empty($offset))
$offset=0;
if($next_x){
$offset+=$numPerPage;
}
if($previous_x){
$offset-=$numPerPage;
}
$qry_string = "SELECT DISTINCT TOP $numPerPage t1.field1, t1.field2 from t1 LEFT
JOIN t2 ON t2.field1=t1.field1
WHERE t2.another_field='specific_val'
AND t1.fields
NOT IN
(SELECT DISTINCT TOP $offset tmpT1.field1
FROM t1 AS tmpT1 LEFT
JOIN t2 ON t2.field1=tmpT1.field1
WHERE t2.another_field='specific_val'
)";
// then run the above $qry_string using the while loop`
add a note
mssql_field_type mssql_field_name

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST