Blog (Including Commenting)

[tiaz1988]

What's wrong with this
I'll create a blog on my father's company site
When I go to the link for bloglist.php
So I get this error message:
Warning: mysql_fetch_assoc () expects parameter 1 to be resource, boolean given in /home/slahsyir/public_html/rege/func/productblog/core/inc/posts.inc.php on line 49
But there is nothing wrong in the code as they say on the hosting, because I have tried to upload page on my linux server and then I can see the test post. But not when I upload it to the web hosting. I have tried everything. Have even tried to change php version, but it does not work. What should I do to make it work on his site?

I have used this script many times and it has worked, but not now.

Please help me.

[syntax=php]//Fetches a summary of all the posts.
function get_posts()
{
$sql = "SELECT
`posts`.`post_id` AS `id`,
`posts`.`post_title` AS `title`,
LEFT(`posts`.`post_body`, 512) AS `preview`,
`posts`.`post_user` AS `user`,
DATE_FORMAT(`posts`.`post_date`, '%d/%m/%Y %H:%i:%s') AS `date`,
`comments`.`total_comments`,
DATE_FORMAT(`comments`.`last_comment`, '%d/%m/%Y %H:%i:%s') AS `last_comment`
FROM `posts`
LEFT JOIN (
SELECT
`post_id`,
COUNT(`comment_id`) AS `total_comments`,
MAX(`comment_date`) AS `last_comment`
FROM `comments`
GROUP BY `post_id`
) AS `comments`
ON `posts`.`post_id` = `comments`.`post_id`
ORDER BY `posts`.`post_date` DESC";

$posts = mysql_query($sql);

$rows = array();

while(($row = mysql_fetch_assoc($posts)) !== false)
{
$rows[] = array(

'id' => $row['id'],
'title' => $row['title'],
'preview' => $row['preview'],
'user' => $row['user'],
'date' => $row['date'],
'total_comments' => ($row['total_comments'] === null) ? 0 : $row['total_comments'],
'last_comment' => ($row['last_comment'] === null) ? 'never' : $row['last_comment']
);
}

return $rows;
}[/syntax]

[Temor]

What host are you using and what does their MySQL arrangement look like?`

Have you tried it on another web host?

[tiaz1988]

What host are you using and what does their MySQL arrangement look like?`

Have you tried it on another web host?

Misshosting.se

I don't know what their mysql arguments look like.
Where can I find that documentation?
But I've check the query with sql syntex and it's work fine even in their database.

You can check the error on this link:

rege.se/rege/func/productblog/bloglist.php

Take care!

[Temor]

Have you tried running an error check? [syntax=php]echo mysql_error(); [/syntax]

Something seems to break the query, but as far as I can tell it's not a typo.
It might be that the host deems the old Mysql-functions too unsecure and will instead force you to use MySqli or PDO.

[tiaz1988]

Have you tried running an error check? [syntax=php]echo mysql_error(); [/syntax]

Something seems to break the query, but as far as I can tell it's not a typo.
It might be that the host deems the old Mysql-functions too unsecure and will instead force you to use MySqli or PDO.

I just want to say that I have got it working now.
Thanks for your help anyway. : D

Take care!