If so, go to this area and add thisSELECT count(postID) AS rowcount FROM comments WHERE postID=
Code: Select all
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
//putaCode: Select all
print_r($row);Moderator: General Moderators
If so, go to this area and add thisSELECT count(postID) AS rowcount FROM comments WHERE postID=
Code: Select all
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
//putaCode: Select all
print_r($row);Array ( [0] => March 2nd, 2005 - 10:41 PM [1] => 14the report [2] => 16 [3] => pleigh ) pleigh
14the report
1
March 2nd, 2005 - 10:41 PM
Array ( [0] => March 2nd, 2005 - 5:53 PM [1] => new topic [2] => 17 [3] => jeff ) jeff
new topic
2
March 2nd, 2005 - 5:53 PM
Array ( [0] => March 2nd, 2005 - 3:21 PM [1] => 13th report [2] => 15 [3] => pleigh ) pleigh
13th report
0
March 2nd, 2005 - 3:21 PM
Array ( [0] => March 2nd, 2005 - 3:18 PM [1] => 12th report [2] => 14 [3] => pleigh ) pleigh
12th report
0
March 2nd, 2005 - 3:18 PM
Array ( [0] => March 2nd, 2005 - 3:17 PM [1] => 11th report [2] => 13 [3] => pleigh ) pleigh
11th report
0
March 2nd, 2005 - 3:17 PM
Array ( [0] => March 1st, 2005 - 9:08 PM [1] => 10th report [2] => 12 [3] => pleigh ) pleigh
10th report
3
March 1st, 2005 - 9:08 PM
Array ( [0] => March 1st, 2005 - 8:12 PM [1] => 9th report [2] => 11 [3] => pleigh ) pleigh
9th report
0
March 1st, 2005 - 8:12 PM
Array ( [0] => March 1st, 2005 - 8:11 PM [1] => 8th report [2] => 10 [3] => pleigh ) pleigh
8th report
0
March 1st, 2005 - 8:11 PM
Array ( [0] => March 1st, 2005 - 8:09 PM [1] => 7th report [2] => 9 [3] => pleigh ) pleigh
7th report
0
March 1st, 2005 - 8:09 PM
Array ( [0] => March 1st, 2005 - 8:08 PM [1] => 6th report [2] => 8 [3] => pleigh )
if i am not mistaken, it is in the query that causes the problem.....or the arguement...really don't know....Warning: Missing argument 1 for replies() in c:\inetpub\wwwroot\mysample\functions\library.php on line 321
Error with SELECT count(postID) AS rowcount FROM comments WHERE postID=
Code: Select all
<td width=10% class=tableborder><table><tr><td>".replies($rowї2])."</td></tr></table></td>Code: Select all
<td width=10% class=tableborder><table><tr><td>".replies(floor($rowї2]))."</td></tr></table></td>Code: Select all
<td width=10% class=tableborder align=center><table><tr><td>".replies($rowї2])."</td></tr></table></td>Code: Select all
<td width=10% class=tableborder align=center><table><tr><td>".replies(floor($rowї2]))."</td></tr></table></td>Warning: Missing argument 1 for replies() in c:\inetpub\wwwroot\mysample\functions\library.php on line 321
Error with SELECT count(postID) AS rowcount FROM comments WHERE postID=
Code: Select all
function replies($postID)Code: Select all
function replies($postID)
{
if(empty($postID))
{
echo '<pre>';
var_dump(debug_backtrace());
echo '</pre>';
}
//other codes goes here
}Code: Select all
SELECT
m.message_id AS message_id,
m.datetime AS datetime,
IF(ISNULL(comment_id), 0, COUNT(*)) AS count
FROM
message AS m
LEFT JOIN comment AS c USING (message_id)
GROUP BY
m.message_id