Page 1 of 1

displaying authors only.

Posted: Tue Nov 22, 2005 11:56 am
by edenikko
how do i show the author's posts only.


example i clicked the author "Nicholas" it goes to a page that shows all the posts made by "Nicholes"

Posted: Tue Nov 22, 2005 11:59 am
by Grim...
On this forum?
Click 'search' then fill in the 'by author' box.

Posted: Tue Nov 22, 2005 12:05 pm
by edenikko
oo..im sorry i lack of details...

im making a blog... :D how do i do it?

Posted: Tue Nov 22, 2005 12:09 pm
by Grim...
So, you want help on how to make a blog?

Try here:
http://www.asp-php.net/ressources/liens.aspx?id=1079

Posted: Tue Nov 22, 2005 12:22 pm
by edenikko
still did not help.. :(

i need to make the page show only posts made by the selected author from a page.

Posted: Tue Nov 22, 2005 7:04 pm
by Jenk
Sorry, my mind reading machine is out of action today, so you will need to post code so we can help.

Posted: Tue Nov 22, 2005 7:20 pm
by shiznatix
it will require somthing like this

Code: Select all

$sql = '
  SELECT
    *
  FROM
    table_name_goes_here
  WHERE
    author = "'.$author_that_was_selected.'"
';

$query = mysql_query($sql) or die(mysql_error());

while ($info = mysql_fetch_assoc($query))
{
//display all of their messages or do whatever you want here.
}
this is all thinking that your table layout is a certain way and whatnot. we would really need to see some code to make it really work for you.