Re: guestbook
| From: | Joe Stump | Date: | Mon, 04 Dec 2000 23:34:37 +0000 |
| Subject: | Re: guestbook | ||
| References: | 1 2 3 4 5 6 7 8 9 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28667@lists.php.net to get a copy of this message | ||
Should be - do a "desc table" at your mysql> prompt to show what the headers
of the rows will be ie if 'title' is in your table then $row['title'] will be
the title for that row.
--Joe
On Mon, Dec 04, 2000 at 03:01:15PM -0800, Brandon Feldhahn wrote:
> i already have the table and stuff so i connect to the database and type
> $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>";
> }
>
> is that right, do i have to put the _db? becaseue i uyse mysql
>
> Joe Stump wrote:
>
> > 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?
> > > > > > > > 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?
> > > > > > 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?
> > > > 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?
> > 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? http://www.google.com/search?q=%22Joe+Stump%22
*****************************************************************
* RENT THIS SPACE - SEEN BY THOUSANDS EACH DAY! *
* Current Sponsor: http://www.smackdown.com
*
*****************************************************************