Hi,

I have the following peice of code which pulls data from a database:

$rsfeed = mysql_query("select Title from Abstracts where (ID = '12'));
$thearray = mysql_fetch_row($rsfeed);

I can print the title using: print $thearray[0]; but theactual resultset is more then 1 row, and what i need to do is print the first row ($thearray[0]) and the last row, how do i modify the above code to achieve that?

thanks

Recommended Answers

Hi,

I have the following peice of code which pulls data from a database:

$rsfeed = mysql_query("select Title from Abstracts where (ID = '12'));
$thearray = mysql_fetch_row($rsfeed);

I can print the title using:
print $thearray[0];

but theactual resultset is more then 1 row, and what …

Jump to Post
print $thearray[0]; //first
print $thearray[count($thearray)-1]; //last
// because the index starts with zero

In php the easier way to get the last element is to use end($arr)

Jump to Post

All 6 Replies

Hi,

I have the following peice of code which pulls data from a database:

$rsfeed = mysql_query("select Title from Abstracts where (ID = '12'));
$thearray = mysql_fetch_row($rsfeed);

I can print the title using:
print $thearray[0];

but theactual resultset is more then 1 row, and what i need to do is print the first row ($thearray[0]) and the last row, how do i modify the above code to achieve that?

thanks

First off:
$rsfeed = mysql_query("select Title from Abstracts where (ID = '12'));
you dont need a parantesise (ID = '12')

just use:
$rsfeed = mysql_query("select Title from Abstracts where ID = '12');

Second, if the ID is unique in your table Abstract, then you will only get 1 row anyway.

If ID is not unique, then your will get many rows that have the same ID = 12
in which case you would reference the first row as $rsfeed[0]
and the last row as end($rsfeed);

print $thearray[0]; //first
print $thearray[count($thearray)-1]; //last
// because the index starts with zero
print $thearray[0]; //first
print $thearray[count($thearray)-1]; //last
// because the index starts with zero

In php the easier way to get the last element is to use end($arr)

commented: Class +3
commented: Thanks, much simpler +1

In php the easier way to get the last element is to use end($arr)

Thank you, going to edit some scripts

Member Avatar

In php the easier way to get the last element is to use end($arr)

Nice one uncle, didn't know about that one. That's REALLY useful.

Why not just use sql to do it for you? Say you want the last (highest id) of a set ordered by id:
SELECT * FROM `table` ORDER BY id DESC LIMIT 1
That way you only get the one row where the ID is highest.
Et voila

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.