mysql_data_seek

mysql_data_seek -- Move internal result pointer

Description

bool mysql_data_seek ( resource result_identifier, int row_number)

מחזיר TRUE במקרה של הצלחה או FALSE במקרה של כישלון .

הערה :

דוגמה 1 .

 
?php

 
$link

 
=

 
mysql_pconnect(

 
"localhost"

 
,

 
"mysql_user"

 
,

 
"mysql_password"

 
)

 
or

 
die("Could

 
not

 
connect")

 
;

 
mysql_select_db("samp_db"

 
)

 
or

 
exit("Could

 
not

 
select

 
database")

 
;

 
$query

 
=

 
"SELECT

 
last_name

 
,

 
first_name

 
FROM

 
friends"

 
;

 
$result

 
=

 
mysql_query($query

 
)

 
or

 
die("Query

 
failed")

 
;

 
/

 
*

 
fetch

 
rows

 
in

 
reverse

 
order

 
*

 
/

 
for

 
($i

 
=

 
mysql_num_rows($result

 
)

 
-

 
1

 
;

 
$i

 
=

 
0

 
;

 
$i-

 
-

 
)

 
{

 
if

 
(!mysql_data_seek($result

 
,

 
$i)

 
)

 
{

 
echo

 
"Cannot

 
seek

 
to

 
row

 
$i\n"

 
;

 
continue

 
;

 
        }

 
if(

 
!($row

 
=

 
mysql_fetch_object($result))

 
)

 
continue

 
;

 
echo

 
"$row

 
-

 
last_name

 
$row

 
-

 
first_name

 
br

 
/

 
\n"

 
;

 
    }

 
mysql_free_result($result)

 
;

 
?