Aşağıda yapısı ile "giriş" adında bir MySQL tablo kullanıyorum. Tablo yapısı altında kod veri tablosu çekti kullanır "login".

For certain loginids that were created about two months ago, the code echoes out the variable "website" fine, no problem. For loginids that I have created recently, the code does not echo out the variable "website." I have even tried giving a newer and olders loginid the exact same value for "website," and the problems persists. Any idea why is happening?

Teşekkür peşin,

John

`login` (
  `loginid` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(30) NOT NULL,
  `password` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `actcode` varchar(45) NOT NULL,
  `disabled` tinyint(1) NOT NULL default '0',
  `activated` tinyint(1) NOT NULL default '0',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `points` bigint(9) NOT NULL,
  `website` varchar(1000) NOT NULL,
  `location` varchar(1000) NOT NULL,
  `age` int(11) NOT NULL,
  `gender` varchar(1000) NOT NULL,
  PRIMARY KEY  (`loginid`)
)

Düzenleme: İşte tam sorgu:

  $sqlStrw = "SELECT l.username, l.loginid, l.website, c.loginid, c.commentid, c.submissionid, c.comment, c.datecommented, l.created, count(c.commentid) countComments
               FROM comment AS c
         INNER JOIN login AS l
                 ON c.loginid = l.loginid
              WHERE l.username = '$profile'";


  $resultw = mysql_query($sqlStrw);

$arrw = array(); 
echo "<table class=\"samplesrecw\">";
while ($roww = mysql_fetch_array($resultw)) { 
    echo '<tr>';
    echo '<td class="sitename5">Website: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://www.'.$roww["website"].'" TARGET="_blank">'.$roww["website"].'</a></td>';
    echo '</tr>';
    }
echo "</table>";