Mystisk problemmed query
Hej alle,jeg har en meget underligt problem. Jeg har følgende query:
<?php
$i = 1;
$get = mysql_query("SELECT * FROM tMails WHERE to_user = '$_COOKIE[userId]' ORDER BY `read` ASC");
while($data = mysql_fetch_array($get)){
$year = substr($data["sent"], 0, 4);
$month = substr($data["sent"], 5, 2);
$day = substr($data["sent"], 8, 2);
$time = substr($data["sent"], 11, 2);
$minute = substr($data["sent"], 14, 2);
if(($i % 2) == 0)
$class = "forumFieldset1";
else
$class = "forumFieldset2";
echo "<tr>";
echo "<td class=\"" . $class . "\" align=\"center\">";
echo $data[read];
echo "</td>";
echo "<td class=\"" . $class . "\">";
echo "<a href=\"?module=5009&mailId=" . $data[id] . "\" class=\"mainLink\">" . formatText($data[header]) . "</a>";
echo "</td>";
echo "<td class=\"" . $class . "\">";
$get = mysql_query("SELECT * FROM tUsers WHERE id = '$data[from_user]'");
$user = mysql_fetch_array($get);
echo "<a href=\"?module=5006&profileId=" . $data[from_user] . "\" class=\"mainLink\">" . $user[navn] . "</a>";
echo "</td>";
echo "<td class=\"" . $class . "\">";
echo $day . "/" . $month . " - " . $year . " " . $time . ":" . $minute;
echo "</td>";
echo "<td class=\"" . $class . "\" align=\"center\">";
echo "<a href=\"?module=5008&replyTo=" . $data[id] . "\" class=\"mainLink\">svar</a> | slet";
echo "</td>";
echo "</tr>";
$i++;
}
?>
Jeg har prøvet at lave en mysql_num_rows(), hvor den siger, at der er 2 resultater, men den skriver kun 1 ud.
Er der en, der kan se, hvor fejlen ligger?
