Hi guys. Man! Recently discovered that Nigerians are very skilled in web design. Was able to visit some web design company websites. Well done Guys.

Got a little problem. I know how you can send a post to a database say comment, using PHP and MYSQL. But I need to know how it will be displayed at each page. I mean people's comment being displayed, say about a topic or something.

I do not need a forum with registration. All I need is just for people to make comments that will be displayed on the same page,

While the good samaritans are trying to help me solve the problem I was just wondering how I can place something in my database that people can download.


Thanks.

I feel you guys, DHTML, YAWATIDE, PCGURU AND A 'web' of OTHERS

You didn't mention my Name so you didn't feel me?

me neither, and my sites from a-o are from databases, not one spot of content is static

Either there is problem with his feelings or we are "web",

Oh no, ma babe dumped me (for dream), ma pc crashed (fiction) and now this? I fall under 'web'? kai!!! Whhat a day. . .
not to mention, i had fun coding today after being stuck up for hours on one cursed bug.


k, seriously now. . .
You can just fetch content from your database and display on the desired page. Hope this helps (i doubt it does :-P)

As per the downloading from database, not a good idea to store stuff on ur database. Its wise to store stuff on ur server and store the references to them on ur database.

Yep it's easy to retreive comments from databases but here is the main catch but first let me add my disclaimer
disclaimer:i might be wrong oh so feel free to correct me Accept | Decline if u accept cool if not Hater!

okay back to the ish,
first there shud be a TOPIC TABLE and IT SHUD HAVE A TOPIC ID which will be PRIMARY key meaning no two of the same number can exist,and Auto_increment to update the table by 1 after every post
[primary keys can only be used once in a table]
We shud now have another Table Called Comments which will have ID also PRIMARY KEY, TOPIC ID [can have duplicate values], COMMENT[text where your comments will go].

here's the logic {disclaimer applies here}

Each Topic for Instance "Girls Love pc guru " will be stored in Table with id 1 since it's the first entry
id. Topic
1 "GIRLS LOVE PCGURU"

now each comments will enter the table like this
id Topic_id Comment
1 1 "topup:''am in love with pcguru he is my world"
2 1 "ebonyesyes:"No i Love pcguru"
3 1 "dhtml:"No one is more awesome than pc guru true story""
4 2 "Javascript vs Jscript"
5 2 "Jquery vs Mootools"

now we have to list topics in a page

let's say topic.php
am assuming u know how to connect to mysql but let me just add that

#connect to the db

$connect_resource=mysql_connect("localhost","username","password"or die("Mysql Connection Error";
mysql_select_db('database_name',"Link Resource used to connect which is $connect_resource" or die("Database Connection Error";

#query all topics from db

$query="select * from table_topic"; #this retrieves all topics from database topic table
$result=mysql_query($query); #store the result in result variable
$row=mysql_fetch_array($result);
#throw the result into an array(though others use mysql_fetch row with while but am a major array freak so arrar is far easier to tranverse and access them

#to vomit them in a page
while(!$row)
{
echo <a href="topic.php?id=$row['id']>"$row[''topic']</a>; #this will echo a link to topic.php with a dynamic url variable
}
so in the browser it will be like this
topic.php?id=1

#to retrieve comments
$query="select * from comment_table where id=' $id' ";
$result=mysql_query($query); #store the result in result variable
$row=mysql_fetch_array($result);

#to echo the comments
while(!$row)
{
echo $row['comments'];
}

this is just a quick stuff cuz am at work hope this helps others can add or delete where i made mistakes

Thanks Guys For Replying. Apology to a web of others. Couldnt have been mentioning names.

@dualcore. You be real core master!!! Save no downloadle shits on dbase

This is Foolish and Ideally Stupid it beats the purpose of this called a Webmaster forum if codes are to be deleted am tired of this Bot spamming program,Chinaland shud not resort to bot cuz it dosen't make sense,

//Yep it's easy to retreive comments from databases but here is the main catch but first let me add my disclaimer
disclaimer:i might be wrong oh so feel free to correct me Accept | Decline if u accept cool if not Hater!

okay back to the ish,
first there shud be a TOPIC TABLE and IT SHUD HAVE A TOPIC ID which will be PRIMARY key meaning no two of the same number can exist,and Auto_increment to update the table by 1 after every post
[primary keys can only be used once in a table]
We shud now have another Table Called Comments which will have ID also PRIMARY KEY, TOPIC ID [can have duplicate values], COMMENT[text where your comments will go].

here's the logic {disclaimer applies here}

Each Topic for Instance "Girls Love pc guru " will be stored in Table with id 1 since it's the first entry
id. Topic
1 "GIRLS LOVE PCGURU"

now each comments will enter the table like this
id Topic_id Comment
1 1 "topup:''am in love with pcguru he is my world"
2 1 "ebonyesyes:"No i Love pcguru"
3 1 "dhtml:"No one is more awesome than pc guru true story""
4 2 "Javascript vs Jscript"
5 2 "Jquery vs Mootools"

now we have to list topics in a page

let's say topic.php
am assuming u know how to connect to mysql but let me just add that

#connect to the db

$connect_resource=mysql_connect("localhost","username","password"or die("Mysql Connection Error";
mysql_select_db('database_name',"Link Resource used to connect which is $connect_resource" or die("Database Connection Error";

#query all topics from db

$query="select * from table_topic"; #this retrieves all topics from database topic table
$result=mysql_query($query); #store the result in result variable
$row=mysql_fetch_array($result);
#throw the result into an array(though others use mysql_fetch row with while but am a major array freak so arrar is far easier to tranverse and access them

#to vomit them in a page
while(!$row)
{
echo <a href="topic.php?id=$row['id']>"$row[''topic']</a>; #this will echo a link to topic.php with a dynamic url variable
}
so in the browser it will be like this
topic.php?id=1

#to retrieve comments
$query="select * from comment_table where id=' $id' ";
$result=mysql_query($query); #store the result in result variable
$row=mysql_fetch_array($result);

#to echo the comments
while(!$row)
{
echo $row['comments'];
}

this is just a quick stuff cuz am at work hope this helps others can add or delete where i made mistakes

Yep it's easy to retreive comments from databases but here is the main catch but first let me add my disclaimer
disclaimer:i might be wrong oh so feel free to correct me Accept | Decline if u accept cool if not Hater!

okay back to the ish,
first there shud be a TOPIC TABLE and IT SHUD HAVE A TOPIC ID which will be PRIMARY key meaning no two of the same number can exist,and Auto_increment to update the table by 1 after every post
[primary keys can only be used once in a table]
We shud now have another Table Called Comments which will have ID also PRIMARY  KEY,  TOPIC ID [can have duplicate values], COMMENT[text where your comments will go].

here's the logic {disclaimer applies here}

Each Topic for Instance "Girls Love pc guru " will be stored in Table with id 1 since it's the first entry
id. Topic
1   "GIRLS LOVE PCGURU"

now each comments will enter the table like this
id Topic_id Comment
1      1         "topup:''am in love with pcguru he is my world"
2      1          "ebonyesyes:"No i Love pcguru"
3      1         "dhtml:"No one is more awesome than pc guru true story""
4      2          "Javascript vs Jscript"
5      2          "Jquery vs Mootools"

now we have to list topics in a page

let's say topic.php
am assuming u know how to connect to mysql but let me just add that

#connect to the db

$connect_resource=mysql_connect("localhost","username","password"or die("Mysql Connection Error";
mysql_select_db('database_name',"Link Resource used to connect which is $connect_resource" or die("Database Connection Error";

#query all topics from db

$query="select * from table_topic"; #this retrieves all topics from database topic table
$result=mysql_query($query);   #store the result in result variable
$row=mysql_fetch_array($result);
#throw the result into an array(though others use mysql_fetch row with while but am a major array freak so arrar is far easier to tranverse and access them

#to vomit them in a page
while(!$row)
{
echo <a href="topic.php?id=$row['id']>"$row[''topic']</a>; #this will echo a link to topic.php with a dynamic url variable
}
so in the browser it will be like this
topic.php?id=1

#to retrieve comments
$query="select * from comment_table where id=' $id' ";
$result=mysql_query($query);   #store the result in result variable
$row=mysql_fetch_array($result);

#to echo the comments
while(!$row)
{
echo $row['comments'];
}

this is just a quick stuff cuz am at work hope this helps others can add or delete where i made mistakes

I can see alot of gurus already on board: donpuzo, dual core and others. Please help the guy oh.
@topic: there are many ways of achieving this with ready-made scripts. Are you using a framework
or direct coding? and what language are you using to develop your site? And possibly you can give
us an online view of what you are doing and you will get contributions.

deezoneclu:

Thanks Guys For Replying. Apology to a web of others. Couldnt have been mentioning names.

You too no dey mention names again

OK. Please any contribution can be forwarded to dotwas2000@yahoo.com

I use jvscript and PHP. I would prefer to write the code to applying some ready made stuffs.

@DHML. i no dey code for free again. And no time i have manyy offnet projects so i am too busy!!! You be guru na help the dude!!!