Welcome, Guest
  • Author Topic: GUESTBOOK V2 ISSUES - HELP PLEASE  (Read 4947 times)

    Ronald Wernecke

    • Global Moderator
    • Systems Administrator
    • *****
    • Posts: 6203
      • View Profile
      • Professional Support
      • Email
    Re: GUESTBOOK V2 ISSUES - HELP PLEASE
    « Reply #15 on: 10/05/09, 12:21 »
    if you want to get deeper into the materia, do the laoding and saving tutorials, which are listed right above this board
    happy flashing
    8)
    Ronald

    A small robot

    • Server what's that
    • *
    • Posts: 4
      • View Profile
      • United Robots
    Re: GUESTBOOK V2 ISSUES - HELP PLEASE
    « Reply #16 on: 11/23/09, 06:15 »
    Hi !

    I've the same problem and I've been to visit your site, very nice the guest book and it work....

    so... did I have to change that to : 

    // Fetch all comments from database table
           $sql = 'SELECT * FROM `' . $table . '`';
           $allComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
           $numallComments = mysql_num_rows($allComments);

    by// Fetch all comments from database table
           $sql = 'guestbook`' . $table . '`';
           $allComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
           $numallComments = mysql_num_rows($allComments);

    ??  :o

    Ronald Wernecke

    • Global Moderator
    • Systems Administrator
    • *****
    • Posts: 6203
      • View Profile
      • Professional Support
      • Email
    Re: GUESTBOOK V2 ISSUES - HELP PLEASE
    « Reply #17 on: 11/23/09, 08:23 »
    the second statement does not make any sense.

    If you want to retreive something from the database, the statement has to start with select.

    All you have to do, is change the value of the $table variable, if you changed it when you crerated the databse table - and sure, you have to adapt database, user and password to the existing situation.
    happy flashing
    8)
    Ronald

    A small robot

    • Server what's that
    • *
    • Posts: 4
      • View Profile
      • United Robots
    Re: GUESTBOOK V2 ISSUES - HELP PLEASE
    « Reply #18 on: 11/23/09, 10:26 »
    hello ron  :)

    I've change it as you say but what do you mean by $table ? do you mean I've to change that by $mytablename ?

    like that ?        $sql = 'SELECT * FROM`' . $guestbook . '`'; ???

    the sql access is provided by my internet connection, you also mean I have to type my password on this part :

        $DBhost = "localhost";   // Database Server
       $DBuser = "root";            // Database User
       $DBpass = "my password";            // Database Pass or did I leave it empty ? nobody can read that ???
       $DBName = "nameofmydatabase";            // Database Name
       $table = "guestbook";             // Database Table
       $numComments = 10;       // Number of Comments per page

    did I have to put a file.txt for writing somewhere or does it gonna write in the phpadmin table ? Did I have to export something... ??  ???

    ok that's to much, sorry... good day

    Ronald Wernecke

    • Global Moderator
    • Systems Administrator
    • *****
    • Posts: 6203
      • View Profile
      • Professional Support
      • Email
    Re: GUESTBOOK V2 ISSUES - HELP PLEASE
    « Reply #19 on: 11/23/09, 12:48 »
    I know these questions - they are exactly what I answered Mark Tara right before.
    Just read there (her in this thread)

    I hope, you did read the instructions on the tutorial carfully and did all the steps described there.
    Further you should have a version of phpMyAdmin running.
    happy flashing
    8)
    Ronald

    Alien1

    • Server what's that
    • *
    • Posts: 2
      • View Profile
      • Email
    Re: GUESTBOOK V2 ISSUES - HELP PLEASE
    « Reply #20 on: 04/24/10, 16:43 »
    I dont know if any one has had this problem. But I have gotten the Guestbook V2 to work great but some reason it will not email me to let me know that someone has posted on my Guestbook. Any help would be great.

    Ronald Wernecke

    • Global Moderator
    • Systems Administrator
    • *****
    • Posts: 6203
      • View Profile
      • Professional Support
      • Email
    Re: GUESTBOOK V2 ISSUES - HELP PLEASE
    « Reply #21 on: 04/24/10, 23:23 »
    this functionality completely relies on the server and the php script.
    do you receive any error message, when you call your php script in the browser?
    happy flashing
    8)
    Ronald