<?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()); ?>
rajarajan2017
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 0 Junior Poster in Training
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 2 Junior Poster
Hey,
List your code : How are you displaying your $results values.
Barrett1 0 Light Poster
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> <span class="font2">'.$msg.'</span><br /><div class="feed_link">'.$date.''. (($username !== "") ? " - " : "") .'<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> <span class="font5">'.$comment.'</span><br />
<span class="font11">'.$date2.''. (($username == $user2) ? " - " : "") .'</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>
Edited by Barrett1 because: n/a
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.