Re: guestbook
| From: | Joe Stump | Date: | Mon, 04 Dec 2000 23:26:10 +0000 |
| Subject: | Re: guestbook | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28665@lists.php.net to get a copy of this message | ||
Nope...
Here is your table:
<psuedo code>
create table guestbook(
user,
title,
post
);
$r = mysql_query("SELECT * FROM guestbook");
while($row = mysql_fetch_array($r))
{
echo "Posted By: ".$row['user']."<br>";
echo "Title: ".$row['title']."<br>";
echo "Message: <br>".$row['post']."<br>";
echo "<hr>";
}
</psuedo code>
--Joe
On Mon, Dec 04, 2000 at 02:51:47PM -0800, Brandon Feldhahn wrote:
> so to echo the giuest book i put :
>
> echo (" $guestbook_db ");
>
> is that right?
> Joe Stump wrote:
>
> > No, each time through the loop $row will be one record from you SELECT query.
> >
> > --Joe
> >
> > On Mon, Dec 04, 2000 at 02:47:33PM -0800, Brandon Feldhahn wrote:
> > > but will that only show one of the entrys?
> > >
> > > Joe Stump wrote:
> > >
> > > > Well then I suppose you would show it from the DB like any other info...
> > > >
> > > > $sql = "SELECT * FROM guestbook";
> > > > $result = mysql_query($sql);
> > > >
> > > > while($row = mysql_query($result))
> > > > {
> > > > // echo guestbook
> > > > }
> > > >
> > > > --Joe
> > > >
> > > > On Sun, Dec 03, 2000 at 10:06:25PM -0800, Brandon Feldhahn wrote:
> > > > > i ahve a db
> > > > >
> > > > > Joe Stump wrote:
> > > > >
> > > > > > If you don't have a DB then I would highly suggest using XML to
> > > > > > do your guest
> > > > > > book with. If you can't do that either then I would suggest using
> > > > > > some form of
> > > > > > deliminator in a text file. It won't scale like a DB, but it
> > > > > > would work well
> > > > > > for small sites with no DB access.
> > > > > >
> > > > > > --Joe
> > > > > >
> > > > > > On Sun, Dec 03, 2000 at 09:07:55PM -0800, Brandon Feldhahn wrote:
> > > > > > > hi im making a guestbook and im dont with the database, know how
> > > > > > > do i
> > > > > > > show every one's querrys on the site?
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > PHP General Mailing List (http://www.php.net/)
> > > > > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > > > > > > For additional commands, e-mail: php-general-help@lists.php.net
> > > > > > > To contact the list administrators, e-mail:
> > > > > > > php-list-admin@lists.php.net
> > > > > >
> > > > > > -----
> > > > > > Joe Stump, PHP Hacker
> > > > > > joestump98@yahoo.com
> > > > > > http://www.miester.org/
> > > > > >
> > > > > > Need a programmer? .
> > > > > > z/ cghttp://www.google.com/search?q=%22Joe+Stump%22
> > > > > > *****************************************************************
> > > > > > * RENT THIS SPACE - SEEN BY THOUSANDS EACH DAY! *
> > > > > > * Current Sponsor:
> > > > > > http://www.smackdown.com *
> > > > > > *****************************************************************
> > > >
> > > > -----
> > > > Joe Stump, PHP Hacker
> > > > joestump98@yahoo.com
> > > > http://www.miester.org/
> > > >
> > > > Need a programmer?
> > > > http://www.google.com/search?q=%22Joe+Stump%22
> > > > *****************************************************************
> > > > * RENT THIS SPACE - SEEN BY THOUSANDS EACH DAY! *
> > > > * Current Sponsor:
> > > > http://www.smackdown.com *
> > > > *****************************************************************
> >
> > -----
> > Joe Stump, PHP Hacker
> > joestump98@yahoo.com
> > http://www.miester.org/
> >
> > Need a programmer? i Wr
tvQ
> > Phttp://www.google.com/search?q=%22Joe+Stump%22
> > *****************************************************************
> > * RENT THIS SPACE - SEEN BY THOUSANDS EACH DAY! *
> > * Current Sponsor: http://www.smackdown.com
> > *
> > *****************************************************************
-----
Joe Stump, PHP Hacker
joestump98@yahoo.com
http://www.miester.org/
Need a programmer? http://www.google.com/search?q=%22Joe+Stump%22
*****************************************************************
* RENT THIS SPACE - SEEN BY THOUSANDS EACH DAY! *
* Current Sponsor: http://www.smackdown.com
*
*****************************************************************