Linking to individual twitter posts

[Riboflavin1]

Hi all, I have used this script to pull twitter updates to my website and it works great: http://www.inkplant.com/code/pull-twitter-feed-into-your-site.php

 

I was wondering if anyone could help me modify it so that it links to the individual twitter posts such as: http://twitter.com/user/status/4528454817693440

 

 

Thanks!

[upp]

that second link you provided didnt work, what exactly are you trying to do?

[Riboflavin1]

Its just an example of a twitter post link. Each post can be viewed individually, I want to link to them individually.

[salathe]

What specific part are you having trouble with? You store all of the necessary information to reconstruct the status URL. There are two main tasks, make a URL string and output it as a HTML link.

[Riboflavin1]

Would it be something like this then?

 

<?php

//connect to database
mysql_connect("localhost", "user_twit", "password") or die(mysql_error());

//connect to specific table
mysql_select_db("user_twitter") or die(mysql_error());

$result = mysql_query("SELECT * FROM `twitter` WHERE `screen_name`='username' AND `hidden` != 'y' ORDER BY `time` DESC LIMIT 3");
while ($row = mysql_fetch_array($result)) {
    $text = stripslashes($row['text']);
    $time = $row['time'];
    $id = $row['id'];
    echo "<li><a href=\"http://twitter.com/username/status/".$id."\">".$text."</a></li>\n" ;
}

?>

 

Edit: Yup, seems to be working