get one element out of databse instand of all

[clankill3r]

I get different persons in the tabel.

 

How can i get the last tweet from a person?

(can by by last date or highest tweet_id).

 

I have this now which gets them all i think:

 

function getLastTweet($twitter_id) {

$query = "SELECT * FROM tweets WHERE twitter_id='$twitter_id'";

$data = execQuery($query);

return $data;

 

}

[Maq]

What's your table structure?  You would do something similar to:

"SELECT * FROM tweets WHERE twitter_id='$twitter_id' ORDER BY date DESC LIMIT 1";