?php
$link
=
mysql_pconnect
(
"kron"
,
"jutta"
,
"geheim"
)
{
or
die
("Could
not
connect")
;
}
mysql_select_db
("samp_db"
)
{
or
die
("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)
)
{
printf
("Cannot
seek
to
row
%d\n"
,
$i)
;
continue
;
}
if(
!($row
=
mysql_fetch_object
($result))
)
continue
;
printf
("%s
%s
BR
\n"
,
$row
-
last_name
,
$row
-
first_name)
;
}
mysql_free_result
($result)
;
?
|