Untitled

 

<?php

global $_CB_framework;

$id = $_CB_framework->displayedUser();

 

        mysql_select_db("zi5p_FCTR6_Live", $con);

    // CHANGED ENTIRE QUERY FOR PROFILE LINKING FROM HERE ->

    $query = "SELECT jos_comprofiler.id, jos_comprofiler.user_id,  jos_comprofiler.cb_twitterurl FROM jos_comprofiler where jos_member_deals.userid= $id ORDER BY id DESC limit 1";

    // <- TO HERE

 

    $result = mysql_query($query) or die(mysql_error());

    // Print out the contents of each row into a table

    while($row = mysql_fetch_array($result)){

       

                        $twlink = $row['cb_twitterurl'];

                        $twlink =  str_replace("http://", "", $twlink);

                        echo $twlink;

            echo '<a target="_blank"  href=http://' . $twlink . '>';

 

 

    ?>