Hi guys,
I need help on something I'm working on and its really eating me up so I'll
appreciate any help I can get on it.
I'm writing code for a site that posts a topic for discussion and accepts
comments (Just like a parliament).
There are different discussions for every day and the comments should be
displayed along with the corresponding topics per day.
Now I wrote the code below but dont know if I'm right. (I created two tables in
my database and to create a relationship between the tables, I put the id field
for the topics into the comments table):
<?php
function getpost_comments()
{
global $conn; //This gets the database started (already defined)
$result= mysql_query("SELECT * FROM Pcomments, Parliaments WHERE
Pcomments.pcomment_id=Parliaments.parliament_id");
if (!$result) print mysql_error();
else {
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
print "$row[name] - $row[comment]<br/>\n";
}
}
}
?>
I know some of you will probably think its a stupid question but I'm going with
the school of thought that says the only stupid question is the one that's not
asked.
Thanks in anticipation of your positive responses.
Alugo Abdulazeez
www.frangeovic.com.
_________________________________________________________________
Show them the way! Add maps and directions to your party invites.
http://www.microsoft.com/windows/windowslive/products/events.aspx
