Multiple rows from database only showing 1 result

[Barrett1]

<?PHP $results = mysql_query("SELECT * FROM messages, comments WHERE messages.user_on='$user2' AND comments.msg_id_fk = messages.msg_id ORDER BY messages.msg_id, comments.com_id DESC") or die(mysql_error()); ?>

Execute the query in your phpadmin seperately and identify the error first. If samething happen there, then correct it by checking your records properly

[silviuks]

Do you get any kind of error? Maybe the condition comments.msg_id_fk = messages.msg_id actually returns one row ... check your data.

another possible problem: are you looping through the records?

[Manuz]

Hey,
List your code : How are you displaying your $results values.

[Barrett1]

I don't get any errors and yes I'm loop though my records

<?PHP 
include_once "scripts/connect_to_mysql.php";
include("db.php");//Connect to Database
include("tolink.php");


$results = mysql_query("SELECT * FROM messages, comments WHERE messages.user_on='$user2' AND comments.msg_id_fk = messages.msg_id ORDER BY messages.msg_id, comments.com_id DESC") or die(mysql_error());
$messagedump='';
while ($row = mysql_fetch_assoc($results)) {
 
 
$idt=$row['msg_id'];//Message id
$msg=$row['message'];//The Message
$useron=$row['username'];//This is the user where the message is posted on
$date=$row['date'];//Message date
//$msg=toLink($msg);
$id=$row['com_id'];//Comment id
$comment=$row['comment'];//The Comment
$comment=wordwrap($comment, 38, "<br />", true);//Line break every 38 characters long
$date2=$row['_date'];//Comment date
$usernameqw=$row['_username'];//User who posted the comment
 
 
  //Get the picture for the user where the message was posted
	$check_pic = "members/$useron/image01.png";
	$default_pic = "members/0/image01.jpg";
	if (file_exists($check_pic)) {
    $user_picpost = "<img src=\"$check_pic\" width=\"50px\"  alt=\"$useron\" title=\"$useron\"  />"; 
	} else {
	$user_picpost = "<img src=\"$default_pic\" width=\"50px\" alt=\"$useron\" title=\"$useron\"  />"; 
	}
	//Get the session users picture
	$check_pic = "members/$username/image01.png";
	$default_pic = "members/0/image01.jpg";
	if (file_exists($check_pic)) {
    $user_pic2post = "<img src=\"$check_pic\" width=\"32px\"  alt=\"$username\" title=\"$username\" />"; 
	} else {
	$user_pic2post = "<img src=\"$default_pic\" width=\"32px\" alt=\"$username\" title=\"$username\" />"; 
	}
	//Get the user who posted the comments image 
	$check_pic = "members/$usernameqw/image01.png";
	$default_pic = "members/0/image01.jpg";
	if (file_exists($check_pic)) {
    $user_pic2post3 = "<img src=\"$check_pic\" width=\"32px\"  alt=\"$usernameqw\" title=\"$usernameqw\" />"; 
	} else {
	$user_pic2post3 = "<img src=\"$default_pic\" width=\"32px\" alt=\"$usernameqw\" title=\"$usernameqw\" />"; 
	}

 
if ($messagedump!=$msg) {
	$messagedump=$msg;
 
 
 
$message_post .='
<li class="bar'.$idt.'"  onMouseover=\'document.getElementById("del'.$idt.'").style.display="";\' onMouseout=\'document.getElementById("del'.$idt.'").style.display="none";\'>
<div align="left" class="post_box"> 
<div class="left_post">'.$user_picpost.'</div>
<div class="right_postd"><span class="font3">'.$useron.'</span>&nbsp;<span class="font2">'.$msg.'</span><br /><div class="feed_link">'.$date.''. (($username !== "") ? "&nbsp;-&nbsp;" : "") .'<a href="javascript: void(0)" class="comment" id="'.$id.'">'. (($username !== "") ? "Comment" : "") .'</a></div></div>
<div class="right_post"><span class="delete_button" id="del'.$idt.'" style="display:none;"><a href="javascript: void(0)" id="'.$id.'" class="delete_update">'. (($useron == $username || $user2 == $username) ? "<div class=\"hover_delete\"></div>" : "") .'</a></span></div>
<div class="clearer"></div>
</div>


<div id="expand_box" >
<div id="expand_url"></div>
</div>

<div class="lft">
<div id="fullbox" class="fullbox'.$id.'">
<div id="commentload'.$id.'">
</div>
<div class="comment_box" id="c'.$id.'">
<div class="left_com">'.$user_pic2post.'</div>
<div class="right_com">
<form method="post" action="" name="'.$id.'">
<textarea class="text_area" name="comment_value" id="textarea'.$id.'" onKeyDown="limitText(this,100);" 
onKeyUp="limitText(this,100);">
Write a comment...</textarea><br />
<input type="submit" value="Comment" class="comment_submit" id="'.$id.'"/>
</form>
</div>
<div class="cl"></div>
</div>
</div>
</div>
';	
}

$message_post .='
<div class="lft">
<div class="comment_load_box">
<div class="left_post">'.$user_pic2post3.'</div>
<div class="right_post"><span class="font4">'.$usernameqw.'</span>&nbsp;<span class="font5">'.$comment.'</span><br />
<span class="font11">'.$date2.''. (($username == $user2) ? "&nbsp;-&nbsp;" : "") .'</span><a href="javascript: void(0)" id="'.$id2.'" class="cdelete_update">'. (($username == $user2) ? "<span class=\"font111\">Delete</span>" : "") .'</a></div>
<div class="cl"></div>
</div>
</div>
</li>
';
}




?>
<ol class="timeline2">
<? echo"$message_post";//Display the message with all the comments for it?>
</ol>