Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- global $_CB_framework;
- $id = $_CB_framework->displayedUser();
- mysql_select_db("zi5p_FCTR6_Live", $con);
- // CHANGED ENTIRE QUERY FOR PROFILE LINKING FROM HERE ->
- $query2 = "SELECT jos_comprofiler.id, jos_comprofiler.user_id, jos_comprofiler.cb_twitterurl FROM jos_comprofiler where jos_comprofiler.user_id= $id ORDER BY id DESC limit 1";
- // <- TO HERE
- $result2 = mysql_query($query2) or die(mysql_error());
- // Print out the contents of each row into a table
- while($row = mysql_fetch_array($result2)){
- if($row['cb_twitterurl']=="") {
- echo "None";
- }
- else
- {
- $twlink = $row['cb_twitterurl'];
- $twlink = str_replace("twitter.com/", "", $twlink);
- echo $twlink;
- }
- };
- ?>
Add Comment
Please, Sign In to add comment