Guest User

Untitled

a guest
Oct 23rd, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1.  
  2. <?php
  3. global $_CB_framework;
  4. $id = $_CB_framework->displayedUser();
  5.  
  6. mysql_select_db("zi5p_FCTR6_Live", $con);
  7. // CHANGED ENTIRE QUERY FOR PROFILE LINKING FROM HERE ->
  8. $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";
  9. // <- TO HERE
  10.  
  11. $result2 = mysql_query($query2) or die(mysql_error());
  12. // Print out the contents of each row into a table
  13. while($row = mysql_fetch_array($result2)){
  14. if($row['cb_twitterurl']=="") {
  15.  
  16. echo "None";
  17. }
  18. else
  19. {
  20. $twlink = $row['cb_twitterurl'];
  21. $twlink = str_replace("twitter.com/", "", $twlink);
  22. echo $twlink;
  23.  
  24. }
  25. };
  26.  
  27.  
  28.  
  29. ?>
Add Comment
Please, Sign In to add comment