Blog Comments php mysql

Completed Posted Mar 5, 2012 Paid on delivery
Completed Paid on delivery

I have a blog embedded in a website ([url removed, login to view] - attached) which successfully displays posts from the table news (sql dump attached).

Under each post you'll see the word 'comments', which is linked to [url removed, login to view] (attached).

Some coding is required on [url removed, login to view] near the 'comments' hyperlink.

TASK1 -> Count the amount of comments on this post (drawn from the blog_comments table (sql attached). I assume this will involve a WHERE clause where newsid = commentid ???

If count = 1, echo "1 comment" and link to [url removed, login to view]

If count != 1, echo "[COUNT] comments" and link to [url removed, login to view]

When the user clicks on "... comments" and is taken to [url removed, login to view], task 2 begins:

TASK 2 -> Where you see CODE NEEDED HERE, insert the code to echo only the blog post selected on the [url removed, login to view] page.

Below this is a form (already finished) which allows users to input a comment and submit to blog_comments_confirm.php.

However, below this form on the [url removed, login to view] page is code which echos all comments. Currently it echoes all comments on all posts. I assume some sort of WHERE clause is needed near where I have typed in CODE NEEDED HERE to only post comments related to this blog post (where commentid = newsid???

TASK 3 -> The [url removed, login to view] page just needs to be tweaked slightly to input the id of the blog post into the newsid field in the blog_comments table, so that the comment can be linked to the relevant post.

All files and tables attached.

Cheers,

Dave

MySQL PHP

Project ID: #2718775

About the project

13 proposals Remote project Active Mar 6, 2012

Awarded to:

gabs777

See private message.

$30.6 USD in 14 days
(14 Reviews)
3.0

13 freelancers are bidding on average $71 for this job

stevebryant

See private message.

$42.5 USD in 14 days
(426 Reviews)
6.5
shihan033010

See private message.

$60 USD in 14 days
(228 Reviews)
6.3
udanaudayanga

See private message.

$51 USD in 14 days
(47 Reviews)
5.6
watsysgroupvw

See private message.

$50.15 USD in 14 days
(46 Reviews)
5.7
SonITvWorker

See private message.

$45.05 USD in 14 days
(130 Reviews)
5.6
NukedSS

See private message.

$40.8 USD in 14 days
(57 Reviews)
4.9
aishfakahmed

See private message.

$102 USD in 14 days
(48 Reviews)
4.8
worksoft

See private message.

$50.15 USD in 14 days
(4 Reviews)
2.8
abbasi99

See private message.

$50.15 USD in 14 days
(11 Reviews)
2.6
cheeseali

See private message.

$50.15 USD in 14 days
(1 Review)
1.3
webtech11

See private message.

$50.15 USD in 14 days
(0 Reviews)
0.0
phpcoderindia

See private message.

$300.05 USD in 14 days
(0 Reviews)
0.0