Solved

Database Query Error

Posted on 2004-10-07
8
1,219 Views
Last Modified: 2009-07-29
Hi:

I installed a php guestbook, when I tried to add any entry as a guest, it shows the following error :

Database Query Error

Here is the database table structure :

------------------------------------------------
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Oct 07, 2004 at 01:29 PM
# Server version: 4.0.20
# PHP Version: 4.2.3
#
# Database : `webtech_gb`
#

# --------------------------------------------------------

#
# Table structure for table `badwords`
#

CREATE TABLE `badwords` (
  `badword` varchar(25) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `badwords`
#

INSERT INTO `badwords` VALUES ('****');
INSERT INTO `badwords` VALUES ('schweinehund');
INSERT INTO `badwords` VALUES ('****ing');
INSERT INTO `badwords` VALUES ('****');
INSERT INTO `badwords` VALUES ('piss');
INSERT INTO `badwords` VALUES ('kutta');

# --------------------------------------------------------

#
# Table structure for table `banned_ips`
#

CREATE TABLE `banned_ips` (
  `banned_ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`banned_ip`)
) TYPE=MyISAM;

#
# Dumping data for table `banned_ips`
#


# --------------------------------------------------------

#
# Table structure for table `guestbook`
#

CREATE TABLE `guestbook` (
  `id` int(5) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `email` varchar(35) NOT NULL default '',
  `icq` int(11) NOT NULL default '0',
  `http` varchar(50) NOT NULL default '',
  `message` mediumtext NOT NULL,
  `timestamp` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `location` varchar(35) NOT NULL default '',
  `browser` varchar(50) NOT NULL default '',
  `comment` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `guestbook`
#


# --------------------------------------------------------

#
# Table structure for table `smilies`
#

CREATE TABLE `smilies` (
  `code` char(3) NOT NULL default '',
  `file` varchar(15) NOT NULL default '',
  `name` varchar(25) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `smilies`
#

INSERT INTO `smilies` VALUES (':)', 'smile.gif', 'Smile');
INSERT INTO `smilies` VALUES (':-)', 'smile.gif', 'Smile');
INSERT INTO `smilies` VALUES (':))', 'lol.gif', 'LOL');
INSERT INTO `smilies` VALUES (';)', 'wink.gif', 'Winkywinky');
INSERT INTO `smilies` VALUES (';-)', 'wink.gif', 'Winkywinky');
INSERT INTO `smilies` VALUES (':(', 'frown.gif', 'Frown');
INSERT INTO `smilies` VALUES (':-(', 'frown.gif', 'Frown');
INSERT INTO `smilies` VALUES (':[', 'mad.gif', 'Mad');
INSERT INTO `smilies` VALUES (':z)', 'grazy.gif', 'Grazy');
INSERT INTO `smilies` VALUES (':y)', 'crying.gif', 'Crying');
INSERT INTO `smilies` VALUES (':o)', 'sleepy.gif', 'Sleepy');
INSERT INTO `smilies` VALUES (':a)', 'alien.gif', 'Alien');
INSERT INTO `smilies` VALUES (':s)', 'smokie.gif', 'Smokie');
INSERT INTO `smilies` VALUES (':l)', 'love.gif', 'Loooove');
INSERT INTO `smilies` VALUES (':L)', 'love2.gif', 'Loooooooooove');
INSERT INTO `smilies` VALUES (':]', 'biggrin.gif', 'Big Smile');
INSERT INTO `smilies` VALUES (':-/', 'bounce.gif', 'Bounce');
INSERT INTO `smilies` VALUES (':b)', 'burnout.gif', 'Burnout');
INSERT INTO `smilies` VALUES (':&)', 'clown.gif', 'Clown');
INSERT INTO `smilies` VALUES (':?)', 'confused.gif', 'Confused');
INSERT INTO `smilies` VALUES (':c)', 'cool.gif', 'Cooooooool');
INSERT INTO `smilies` VALUES (':e)', 'eek.gif', 'Eeeeeeek');
INSERT INTO `smilies` VALUES (':f)', 'flash.gif', 'Flash');
INSERT INTO `smilies` VALUES (':g)', 'girl.gif', 'Girl');
INSERT INTO `smilies` VALUES (':i)', 'idee.gif', 'Idea');
INSERT INTO `smilies` VALUES (':r)', 'redface.gif', 'Redface');
INSERT INTO `smilies` VALUES (':8)', 'rolleyes.gif', 'RollEyes');
INSERT INTO `smilies` VALUES (':}', 'tongue.gif', 'Tongue');
INSERT INTO `smilies` VALUES (':t)', 'tasty.gif', 'Tasty');
INSERT INTO `smilies` VALUES (':1)', 'alien2.gif', 'invader');
INSERT INTO `smilies` VALUES (':2)', 'kitty.gif', 'Bastard Kitty');
INSERT INTO `smilies` VALUES (':3)', 'heart.gif', 'Heart1');
INSERT INTO `smilies` VALUES (':4)', 'rainbow.gif', 'tie died');
INSERT INTO `smilies` VALUES (':5)', 'el.gif', 'Embarrassed');
INSERT INTO `smilies` VALUES (':6)', 'pumpkin2.gif', 'Helloween');
INSERT INTO `smilies` VALUES (':7)', 'private.gif', 'Secret');
INSERT INTO `smilies` VALUES (':x)', 'xmas.gif', 'Christmas');
INSERT INTO `smilies` VALUES (':9)', 'kiss.gif', 'Kiss, Kiss');
INSERT INTO `smilies` VALUES (':1]', 'karate.gif', 'Karate');
INSERT INTO `smilies` VALUES (':2]', 'cold.gif', 'Cold');
INSERT INTO `smilies` VALUES (':3]', 'devil.gif', 'Devil');
INSERT INTO `smilies` VALUES (':4]', 'tongue2.gif', 'So Nyah!');
INSERT INTO `smilies` VALUES (':5]', 'redhot.gif', 'Red Hot');
INSERT INTO `smilies` VALUES (':6]', 'smash.gif', 'Smash!');
INSERT INTO `smilies` VALUES (':7]', 'frosty.gif', 'Frosty');
INSERT INTO `smilies` VALUES (':8]', 'confused2.gif', 'Confused again');
INSERT INTO `smilies` VALUES (':9]', 'kaioken.gif', 'KAI');
INSERT INTO `smilies` VALUES (':1}', 'vampire.gif', 'Vampire');
INSERT INTO `smilies` VALUES (':2}', 'splat.gif', 'Splat');
INSERT INTO `smilies` VALUES (':3}', 'rwb.gif', 'Flag Smiley');
INSERT INTO `smilies` VALUES (':4}', 'FRlol.gif', 'LOL2');
INSERT INTO `smilies` VALUES (':5}', 'goodbad.gif', 'Good / Bad');
INSERT INTO `smilies` VALUES (':6}', 'eek2.gif', 'EEEEK');
INSERT INTO `smilies` VALUES (':7}', 'dodgy.gif', 'Dodgy');
INSERT INTO `smilies` VALUES (':8}', 'bawling.gif', 'Bawling');
INSERT INTO `smilies` VALUES (':9}', 'party.gif', 'Party on, Garth!');
INSERT INTO `smilies` VALUES (':ni', 'nighty.gif', 'Nightey, Night!');
INSERT INTO `smilies` VALUES (':wa', 'wavey.gif', 'Wave!');
INSERT INTO `smilies` VALUES (':pa', 'patty.gif', 'Patty');
INSERT INTO `smilies` VALUES (':al', 'alarm.gif', 'Alarm');
INSERT INTO `smilies` VALUES (':ba', 'barf.gif', 'Barf!');
INSERT INTO `smilies` VALUES (':bd', 'birthday.gif', 'Birthday');
INSERT INTO `smilies` VALUES (':bu', 'bubble.gif', 'bubble');
INSERT INTO `smilies` VALUES (':ca', 'cat.gif', 'Kitty');
INSERT INTO `smilies` VALUES (':ce', 'censored.gif', 'Censor');
INSERT INTO `smilies` VALUES (':ch', 'cheers.gif', 'Cheers');
INSERT INTO `smilies` VALUES (':co', 'cowboy.gif', 'Cowboy');
INSERT INTO `smilies` VALUES (':da', 'dance.gif', 'Dancing');
INSERT INTO `smilies` VALUES (':gr', 'dance1.gif', 'Dancing Stick');
INSERT INTO `smilies` VALUES (':du', 'dunce.gif', 'Dunce');
INSERT INTO `smilies` VALUES (':fi', 'finger.gif', 'Bird');
INSERT INTO `smilies` VALUES (':fe', 'flame.gif', 'Flame');
INSERT INTO `smilies` VALUES (':fg', 'flaming.gif', 'Flaming');
INSERT INTO `smilies` VALUES (':fl', 'flower2.gif', 'Flower2');
INSERT INTO `smilies` VALUES (':hi', 'hippie.gif', 'Hippie');
INSERT INTO `smilies` VALUES (':jo', 'joker.gif', 'Jester');
INSERT INTO `smilies` VALUES (':kn', 'knight.gif', 'Knight');
INSERT INTO `smilies` VALUES (':ko', 'koolaid.gif', 'KoolAid');
INSERT INTO `smilies` VALUES (':lo', 'looney.gif', 'Looney');
INSERT INTO `smilies` VALUES (':pi', 'pimp.gif', 'Pimp');
INSERT INTO `smilies` VALUES (':fy', 'mfinger.gif', 'Monkey Bird');
INSERT INTO `smilies` VALUES (':pu', 'pukeface.gif', 'Puke');
INSERT INTO `smilies` VALUES (':no', 'no.gif', 'NO!');
INSERT INTO `smilies` VALUES (':ro', 'rosie.gif', 'Rosy Cheeks');
INSERT INTO `smilies` VALUES (':sh', 'shudder.gif', 'Shudder');
INSERT INTO `smilies` VALUES (':si', 'sick.gif', 'Sick');
INSERT INTO `smilies` VALUES (':sm', 'smoker.gif', 'Smokin');
INSERT INTO `smilies` VALUES (':se', 'sperm.gif', 'Sperm');
INSERT INTO `smilies` VALUES (':to', 'tomato.gif', 'tomato');
INSERT INTO `smilies` VALUES (':tu', 'tut.gif', 'King Tut');
INSERT INTO `smilies` VALUES (':ty', 'type.gif', 'Typing');
INSERT INTO `smilies` VALUES (':wh', 'whip.gif', 'Whip It!');
INSERT INTO `smilies` VALUES (':ja', 'whoa.gif', 'Jaw Dropping');

-------------------------------------

Any suggestion ?

rsdn
0
Comment
Question by:Sohel Rana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 13

Expert Comment

by:cLFlaVA
ID: 12251534
Do you know what line your error is occurring on?

0
 
LVL 16

Author Comment

by:Sohel Rana
ID: 12251583
Hi:

I don't know which line is causing this error.

rsdn
0
 
LVL 13

Expert Comment

by:cLFlaVA
ID: 12251589
Also, what is the SQL statement you're using when you try to add an entry?
0
Webinar: Choosing a MySQL HA Solution

Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).

 
LVL 13

Expert Comment

by:cLFlaVA
ID: 12251597
You say you're getting an error trying to add an entry, yet nowhere in the above do you show us how you're trying to add the entry.
0
 
LVL 16

Author Comment

by:Sohel Rana
ID: 12251709
>> Also, what is the SQL statement you're using when you try to add an entry?

Add an entry I mean when I try to submit a guest comment from guest submit form.
I am not sure about what SQL statement is using but here is the submit php script :

-----------------------------------------------
<?
#################################################################################################
#
#  project                 : phpBook
#  filename                : guestbook.php
#  last modified by        : Erich Fuchs
#  e-mail                  : office@smartisoft.com
#  purpose                 : Guestbook
#
#################################################################################################

$proctime_start=microtime();

#  Include Configs & Variables
#################################################################################################

require ("config.php");

if (strstr (getenv('HTTP_USER_AGENT'), 'MSIE')) { // Browser Detection
    $in_field_size="50";
    $text_field_size="31";
} else {
    $in_field_size="30";
    $text_field_size="24";
}


#  Connect DB
#################################################################################################
mysql_connect($server, $db_user, $db_pass) or died("Database Connect Error");


#  Process
#################################################################################################

if ($action=="submit") {                              // Add an action


  if (!$in && !$delid && !$delcommentid && !$commentid) {
    header("Location: $PHP_SELF");
    exit;
  } elseif ($delid && $admin==$adminpass) {
    mysql_db_query($database, "DELETE FROM guestbook WHERE id='$delid'") or died("Database Query Error");
    header("Location: $PHP_SELF?offset=$offset&poffset=$poffset&admin=$admin");
    exit;
  } elseif ($delcommentid && $admin==$adminpass) {
    mysql_db_query($database, "UPDATE guestbook SET comment='' where id='$delcommentid'") or died("Database Query Error");
    header("Location: $PHP_SELF?offset=$offset&poffset=$poffset&admin=$admin");
    exit;
  } elseif ($commentid && $admin==$adminpass) {
    if(isset($comment)){
      $action=changed;
      mysql_db_query($database, "UPDATE guestbook SET comment='".encode_msg($comment)."' where id='$commentid'") or died("Database Query Error");
        } else {
      $action="";
    }
    header("Location: $PHP_SELF?commentid=$commentid&action=$action&offset=$offset&poffset=$poffset&admin=$admin");
    exit;
  } else {
    if (isbanned()) {
      header("Location: $PHP_SELF");
        exit;
    }
    $add_date=time();
    $result=mysql_db_query($database, "SELECT * FROM guestbook WHERE ip='$REMOTE_ADDR' AND timestamp>($add_date-(60*$timelimit))") or died("Database Query Error");
    $query=mysql_fetch_array($result);
    if ($query) {
      header("Location: $PHP_SELF");
        exit;
    }
    $in = strip_array($in);
    $in['message'] = encode_msg($in['message']);    // Add SQL compatibilty & Smilie Convert
    $in['http']    = str_replace("http://", "", $in['http']);   // Remove http:// from URLs
    if ($in['name'] == "") { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$name_empty</center></body></html>"); }
    if ($in['icq'] != "" && ($in['icq'] < 1000 || $in['icq'] > 999999999)) { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$icq_wrong</center></body></html>"); }
    if (!eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$",$in['email']) && $in['email'] != "") { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$non_valid_email</center></body></html>"); }
    if (strlen($in['message']) < $limit["0"] || strlen($in['message']) > $limit["1"]) { died("<html><head><title>$guestbook_head</title>$languagemetatag</head><body><center>$message_incorrect $limit[0] $and $limit[1] $characters.</center></body></html>"); }
    if ($in['email'] == "") { $in['email'] = "none"; }
    if ($in['icq'] == "") { $in['icq'] = 0; }
    if ($in['http'] == "") { $in['http'] = "none"; }
    if ($in['location'] == "0") { $in['location'] = "none"; }
    $in['browser'] = $HTTP_USER_AGENT;
    mysql_db_query($database, "INSERT INTO guestbook (name, email, http, icq, message, timestamp, ip, location, browser)
    VALUES('$in[name]', '$in[email]','$in[http]','$in[icq]','$in[message]','$add_date', '$REMOTE_ADDR','$in[location]','$in[browser]')")
    or died("Database Query Error");
    if ($gb_notify) {
        @mail("$gb_notify","$gb_notifysubj","$notify_text $in[name]\n\n".censor_msg($in[message]),"From: $gb_notify");
    }
    if ($timelimit) {
        setcookie("phpbookcookie","$guestbook_head", time()+(60*$timelimit),"/");
    }
    if ($admin) {$adminlink="?admin=$admin";}
    header("Location: $PHP_SELF$adminlink");
    exit;
  }

} else {                                       // Show the entries #####################

  #  Header
  #################################################################################################

  echo "<html>\n";
  echo " <head>\n";
  echo "  <title>$guestbook_head</title>\n";
  echo "  <link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\">\n";
  echo "  $languagemetatag\n";
  echo "  <meta name=\"robots\" content=\"index, nofollow\">\n";
  echo "  <meta name=\"revisit-after\" content=\"20 days\">\n";
  echo "    <script language=\"Javascript\">\n";
  echo "       function floodprotect() {\n";
  echo "         alert(\"$banned\");\n";
  echo "       }\n";
  echo "    </script>\n";
  echo " </head>\n";
  echo "<body>\n";

  #  The Main-Section
  #################################################################################################

  echo" <table align=\"$table_align\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" margin=1 width=\"$table_width\" height=\"$table_height\">\n";
  echo"   <tr>\n";
  echo"    <td class=\"class1\">\n";
  echo"      <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" width=\"100%\" height=\"$table_height\">\n";
  echo"       <tr>\n";
  echo"        <td class=\"class2\">\n";
  if ($action=="add") {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">$gb_link1head</div></div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "      <div class=\"maintext\">\n";
    echo "       <br>\n";
    echo "       <table align=\"center\">\n";
    echo "       <Form action=\"$PHP_SELF?action=submit\" method=\"post\">\n";
    echo "           <tr>\n";
    echo "      <td><div class=\"maininputleft\">$gbadd_name</div></td>\n";
    echo "      <td><input type=\"text\" name=\"in[name]\" size=\"$in_field_size\" maxlength=\"35\"></td>\n";
    echo "           </tr>\n";
    echo "           <tr>\n";
    echo "      <td><div class=\"maininputleft\">$gbadd_location</div></td>\n";
    if ($location_text) {
      echo "  <td><input type=\"text\" name=\"in[location]\" size=\"$in_field_size\" maxlength=\"35\"></td>\n";
    } else {
      echo "      <td class=\"class_add2\"><select name=\"in[location]\">\n";
      echo "      <option value=\"0\" SELECTED>$location_sel</option>\n";
      include ("$loc_dir/$locations");
      echo "      </select></td>\n";
    }
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td><div class=\"maininputleft\">$gbadd_email</div></td>\n";
    echo "             <td><input type=\"text\" name=\"in[email]\" size=\"$in_field_size\" maxlength=\"35\"></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td><div class=\"maininputleft\">$gbadd_icq</div></td>\n";
    echo "             <td><input type=\"text\" name=\"in[icq]\" size=\"$in_field_size\" value=\"\" maxlength=\"12\"></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td><div class=\"maininputleft\">$gbadd_url</div></td>\n";
    echo "             <td><input type=\"text\" name=\"in[http]\" size=\"$in_field_size\" maxlength=\"60\" value=\"http://\"></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td valign=\"top\"><div class=\"maininputleft\">$gbadd_msg<br><br>\n";
    echo "            <div class=\"xsmallleft\"><a href=\"smiliehelp.php\"
                      onClick='enterWindow=window.open(\"smiliehelp.php\",\"Smilie\",
                      \"width=300,height=450,top=100,left=100,scrollbars=yes\"); return false'
                      onmouseover=\"window.status='$smiliehelp'; return true;\"
                      onmouseout=\"window.status=''; return true;\">$smiley_help</a></div>\n";
    echo "            <div class=\"xsmallleft\"><a href=\"urlcodehelp.php\"
                      onClick='enterWindow=window.open(\"urlcodehelp.php\",\"URLCode\",
                      \"width=550,height=450,top=100,left=100,scrollbars=yes\"); return false'
                      onmouseover=\"window.status='$urlcodehelp'; return true;\"
                      onmouseout=\"window.status=''; return true;\">$url_code_help</a></div>\n";
    echo "            </div></td>\n";
    echo "             <td><textarea rows=\"8\" name=\"in[message]\" cols=\"$text_field_size\"></textarea></td>\n";
    echo "     </tr>\n";
    echo "     <tr>\n";
    echo "             <td></td>\n";
    echo "             <td><br><input type=\"hidden\" name=\"admin\" value=\"$admin\"><input type=\"submit\" Value=\"$submit\"></td>\n";
    echo "     </tr>\n";
    echo " </table>\n";
    echo " </form>\n";
    echo "           </div>\n";
  } elseif ($action=="admin" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            $gb_link2head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "      <div class=\"maintext\">\n";
    echo "       <br>\n";
    echo "       <a href=\"$PHP_SELF?action=badwords&admin=$admin\" onmouseover=\"window.status='$gb_link3desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link3</a><br>\n";
    echo "       <a href=\"$PHP_SELF?action=banned_ips&admin=$admin\" onmouseover=\"window.status='$gb_link4desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link4</a>\n";
    echo "      </div>\n";
  } elseif ($action == "badwords" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link3head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    $count=0;
    $result = mysql_db_query($database, "select * from badwords") or die("Database Query Error");
    echo " <br><table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
    echo "   <tr>\n";
    echo "    <td class=\"class2\">\n";
    echo "      ";
    echo "    </td>\n";
    echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
    echo "      <div class=\"smallleft\"><a href=\"$PHP_SELF?action=new_badword&admin=$admin\">New</a></div>\n";
    echo "    </td>\n";
    echo "  </tr>\n";
    echo "</table>\n";

    while ($db = mysql_fetch_array($result)) {
        echo " <table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
      echo "   <tr>\n";
        echo "    <td class=\"class1\">\n";
      echo "     <div class=\"smallleft\">$db[badword]</div>";
        echo "    </td>\n";
        echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
      echo "         <div class=\"smallleft\"><a href=\"$PHP_SELF?action=edit_badword&admin=$admin&value=$db[badword]\">Edit</a> || \n";
      echo "         $menusep<a href=\"$PHP_SELF?action=delete_badword&admin=$admin&value=$db[badword]\">Delete</a></div>\n";
        echo "    </td>\n";
      echo "  </tr>\n";
        echo "</table>\n";
      $count++;
    }
    echo "<div class=\"smallleft\"><br>$count $gb_link3stat<br><br></div>\n";

  } elseif ($action == "edit_badword" || $action == "new_badword" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link3head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "<form action=\"$PHP_SELF\" method=\"GET\">\n";
    echo "<table align=\"center\" width=\"100%\">\n";
    if ($action == "edit_badword") {
      echo "<input type=\"hidden\" name=\"action\" value=\"save_edit_badword\">\n";
    } else {
        echo "<input type=\"hidden\" name=\"action\" value=\"save_new_badword\">\n";
    }
    echo "<input type=\"hidden\" name=\"value\" value=\"$value\">\n";
    echo "<input type=\"hidden\" name=\"admin\" value=\"$admin\">\n";
    echo "<tr>\n";
    echo "<td class=\"classadd1\"><div class=\"maininputleft\">$gb_link3text</div></td>\n";
    echo "<td class=\"classadd2\">\n";
    echo "<input type=text name=\"newvalue\" size=\"25\" maxlength=\"50\" value=\"$value\"></td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td class=\"classadd2\"></td>\n";
    echo "<td class=\"classadd2\"><br><input type=submit value=Submit></td>\n";
    echo "</tr>\n";
    echo "</table>\n";
    echo "</form>\n";

  } elseif ($action == "save_edit_badword" && $admin==$adminpass) {

    $result = mysql_db_query($database, "UPDATE badwords SET badword='$newvalue' WHERE badword='$value'") or die("Database Query Error");
    echo "<script language=javascript>location.replace('$PHP_SELF?action=badwords&admin=$admin');</script>\n";

  } elseif ($action == "save_new_badword" && $admin==$adminpass) {
    $result = mysql_db_query($database, "INSERT INTO badwords (badword) VALUES('$newvalue')") or die("Database Query Error");
    echo "<script language=javascript>location.replace('$PHP_SELF?action=badwords&admin=$admin');</script>\n";

  } elseif ($action == "delete_badword" && $admin==$adminpass) {
    $result = mysql_db_query($database, "DELETE FROM badwords WHERE badword='$value'") or die("Database Query Error");
    echo "<script language=javascript>location.replace('$PHP_SELF?action=badwords&admin=$admin');</script>\n";

  } elseif ($action == "banned_ips" && $admin==$adminpass) {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link4head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    $count=0;
    $result = mysql_db_query($database, "select * from banned_ips") or die("Database Query Error");
    echo " <br><table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
    echo "   <tr>\n";
    echo "    <td class=\"class2\">\n";
    echo "      ";
    echo "    </td>\n";
    echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
    echo "      <div class=\"smallleft\"><a href=\"$PHP_SELF?action=new_banned_ip&admin=$admin\">New</a></div>\n";
    echo "    </td>\n";
    echo "  </tr>\n";
    echo "</table>\n";

    while ($db = mysql_fetch_array($result)) {
        echo " <table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" width=\"100%\">\n";
      echo "   <tr>\n";
        echo "    <td class=\"class1\">\n";
      echo "     <div class=\"smallleft\">$db[0]</div>";
        echo "    </td>\n";
        echo "    <td class=\"class1\" align=\"right\" width=\"90\">\n";
      echo "         <div class=\"smallleft\"><a href=\"$PHP_SELF?action=edit_banned_ip&admin=$admin&value=$db[banned_ip]\">Edit</a> || \n";
      echo "         <a href=\"$PHP_SELF?action=delete_banned_ip&admin=$admin&value=$db[banned_ip]\">Delete</a></div>\n";
        echo "    </td>\n";
      echo "  </tr>\n";
        echo "</table>\n";
      $count++;
    }
    echo "<div class=\"smallleft\"><br>$count $gb_link4stat<br><br></div>\n";

  } elseif ($action == "edit_banned_ip" || $action == "new_banned_ip") {
    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">";
    echo "            <a href=\"$PHP_SELF?admin=$admin\" onmouseover=\"window.status='$gb_link5desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link5</a> || ";
    echo "            <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || ";
    echo "            $gb_link4head</div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "<form action=\"$PHP_SELF\" method=\"GET\">\n";
    echo "<table align=\"center\" width=\"100%\">\n";
    if ($action == "edit_banned_ip") {
      echo "<input type=\"hidden\" name=\"action\" value=\"save_edit_banned_ip\">\n";
    } else {
        echo "<input type=\"hidden\" name=\"action\" value=\"save_new_banned_ip\">\n";
    }
    echo "<input type=\"hidden\" name=\"value\" value=\"$value\">\n";
    echo "<input type=\"hidden\" name=\"admin\" value=\"$admin\">\n";
    echo "<tr>\n";
    echo "<td class=\"classadd1\"><div class=\"maininputleft\">$gb_link4text</div></td>\n";
    echo "<td class=\"classadd2\">\n";
    echo "<input type=text name=\"newvalue\" size=\"25\" maxlength=\"50\" value=\"$value\"></td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td class=\"classadd2\"></td>\n";
    echo "<td class=\"classadd2\"><br><input type=submit value=Submit></td>\n";
    echo "</tr>\n";
    echo "</table>\n";
    echo "</form>\n";

  } elseif ($action == "save_edit_banned_ip" && $admin==$adminpass) {
    $result = mysql_db_query($database, "UPDATE banned_ips SET banned_ip='$newvalue' WHERE banned_ip='$value'") or die("Database Query Error");
    echo "<script language=javascript>location.replace('$PHP_SELF?action=banned_ips&admin=$admin');</script>\n";

  } elseif ($action == "save_new_banned_ip" && $admin==$adminpass) {
    $result = mysql_db_query($database, "INSERT INTO banned_ips (banned_ip) VALUES('$newvalue')") or die("Database Query Error");
    echo "<script language=javascript>location.replace('$PHP_SELF?action=banned_ips&admin=$admin');</script>\n";

  } elseif ($action == "delete_banned_ip" && $admin==$adminpass) {
    $result = mysql_db_query($database, "DELETE FROM banned_ips WHERE banned_ip='$value'") or die("Database Query Error");
    echo "<script language=javascript>location.replace('$PHP_SELF?action=banned_ips&admin=$admin');</script>\n";

  } else {

    if ($admin) {$adminlink="&admin=$admin";}

    echo "          <table>\n";
    echo "            <tr>\n";
    echo "             <td width=\"1%\">\n";
    echo "              <div class=\"mainheader\">$guestbook_head</div>\n";
    echo "             </td>\n";
    echo "             <td>\n";
    echo "              <div class=\"mainmenu\">\n";
    if ($admin==$adminpass) {
       echo "                 <a href=\"$PHP_SELF?action=admin&admin=$admin\" onmouseover=\"window.status='$gb_link2desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link2</a> || \n";
    }
    if ($phpbookcookie==$guestbook_head && $admin!=$adminpass) {
       echo "                 <a href=\"$PHP_SELF\" onclick=javascript:floodprotect() onmouseover=\"window.status='$gb_link1desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link1</a>\n";
    } else {
       echo "                 <a href=\"$PHP_SELF?action=add$adminlink\" onmouseover=\"window.status='$gb_link1desc'; return true;\" onmouseout=\"window.status=''; return true;\">$gb_link1</a>\n";
    }
    echo "              </div>\n";
    echo "             </td>\n";
    echo "            </tr>\n";
    echo "           </table>\n";
    echo "           <div class=\"maintext\">\n";

    #  Start with Output
    #################################################################################################

    echo "<table align=\"center\"  cellspacing=\"0\" cellpadding=\"3\" width=\"100%\" border=\"0\">\n";
    echo "<tr><td><div class=\"maincatnav\">\n";
    echo "$gb_desc<br>\n";
    echo "</div></td>\n";

    #  Calculate Page-Numbers
    #################################################################################################

    if (empty($perpage)) $perpage = 1;
    if (empty($pperpage)) $pperpage = 9;      //!!! ONLY 5,7,9,11,13 !!!!
    if (empty($sort)) $sort = "desc";
    if (empty($offset)) $offset = 0;
    if (empty($poffset)) $poffset = 0;
    $amount = mysql_db_query($database, "SELECT count(*) FROM guestbook");
    $amount_array = mysql_fetch_array($amount);
    $pages = ceil($amount_array["0"] / $perpage);
    $actpage = ($offset+$perpage)/$perpage;
    $maxoffset = ($pages-1)*$perpage;
    $maxpoffset = $pages-$pperpage;
    $middlepage=($pperpage-1)/2;
    if ($maxpoffset<0) {$maxpoffset=0;}
    echo "<td><div class=\"mainpages\">\n";
    if ($pages) {                                       // print only when pages > 0
        echo "$ad_pages\n";
      if ($offset) {
              $noffset=$offset-$perpage;
            $npoffset = $noffset/$perpage-$middlepage;
          if ($npoffset<0) {$npoffset=0;}
            if ($npoffset>$maxpoffset) {$npoffset = $maxpoffset;}
          echo "[<a href=\"$PHP_SELF?offset=0&poffset=0$adminlink\"><<</a>] ";
          echo "[<a href=\"$PHP_SELF?offset=$noffset&poffset=$npoffset$adminlink\"><</a>] ";
          }
        for($i = $poffset; $i< $poffset+$pperpage && $i < $pages; $i++) {
          $noffset = $i * $perpage;
              $npoffset = $noffset/$perpage-$middlepage;
              if ($npoffset<0) {$npoffset = 0;}
              if ($npoffset>$maxpoffset) {$npoffset = $maxpoffset;}
          $actual = $i + 1;
              if ($actual==$actpage) {
             echo "(<b>$actual</b>) ";
            } else {
             echo "[<a href=\"$PHP_SELF?offset=$noffset&poffset=$npoffset$adminlink\">$actual</a>] ";
          }
      }
      if ($offset+$perpage<$amount_array["0"]) {
              $noffset=$offset+$perpage;
              $npoffset = $noffset/$perpage-$middlepage;
              if ($npoffset<0) {$npoffset=0;}
              if ($npoffset>$maxpoffset) {$npoffset = $maxpoffset;}
          echo "[<a href=\"$PHP_SELF?offset=$noffset&poffset=$npoffset$adminlink\">></a>] ";
          echo "[<a href=\"$PHP_SELF?offset=$maxoffset&poffset=$maxpoffset$adminlink\">>></a>] ";
        }
    }
    echo "</div></td></tr>\n";
    echo "</table>\n";

    #  Start the Page
    #################################################################################################

    echo "<table align=\"center\"  cellspacing=\"1\" cellpadding=\"3\" width=\"100%\" border=\"0\">\n";
    echo "   <tr>\n";
    echo "     <td class=\"gbheader\">$gb_name</td>\n";
    echo "     <td class=\"gbheader\">$gb_comments</td>\n";
    echo "   </tr>\n";

    #  Get actions for current page
    #################################################################################################

    $result = mysql_db_query($database, "SELECT * FROM guestbook ORDER by id $sort LIMIT $offset, $perpage");
    while ($db = mysql_fetch_array($result)) {

    if ($dateformat=="eu")
 {                              // European Date & Timeformat
        $when = strftime("%d.%m.%Y %H:%M", $db["timestamp"]);
    } else {                                          // US  Date & Timeformat
      $when = strftime("%m/%d/%Y %I:%M %p", $db["timestamp"]);
    }

    if ($db[email]   != "none") {
      $email = "<a href=\"mailto:".$db[email]."\"><img src=\"$image_dir/icons/email.gif\" alt=\"$send_email\" border=\"0\" align=\"right\"></a>";
      } else {
      $email = "";
      }
    if ($db[icq]     != 0)      {
      $icq = "<a href=\"http://wwp.icq.com/scripts/contact.dll?msgto=$db[icq]\"><img src=\"http://wwp.icq.com/scripts/online.dll?icq=" . $db[icq] . "&img=5\" alt=\"$icq_message\" border=\"0\" align=\"right\" height=\"17\"></a>";
      } else {
      $icq = "";
      }
    if ($db[http]    != "none") {
      $http = "<a href=\"http://$db[http]\" target=\"_blank\"><img src=\"$image_dir/icons/home.gif\" alt=\"$view_homepage\" border=\"0\" align=\"right\"></a>";
      } else {
      $http = "";
      }
    if ($db[ip]      != "none") {
       if ($admin==$adminpass) {
        $ip = "<img src=\"$image_dir/icons/ip.gif\" alt=\"".$db[ip]."\" align=\"left\">";
       } else {
        $ip = "<img src=\"$image_dir/icons/ip.gif\" alt=\"$ip_logged\" align=\"left\">";
       }
    } else {
      $ip = "";
    }
    if ($db[location]!= "none") {
      $location = "$gb_location<br>$db[location]<br>";
      } else {
      $location = "<br><br>";
      }
    if ($db[browser]      != "") {
      $browser = "<img src=\"$image_dir/icons/browser.gif\" alt=\"$db[browser]\" align=\"left\">";
      } else {
      $browser = "";
      }
    echo "  <tr>\n";
    echo "     <td class=\"gbtable1\">\n";
    echo "        <div class=\"mainname\">$db[name]</div><br>\n";
    echo "        <div class=\"smallleft\">$location<br></div>\n";
    echo "        <br>$icq $http $email $ip $browser\n";
    echo "     </td>\n";
    echo "        <td class=\"gbtable2\"><div class=\"smallleft\">\n";
    if ($admin==$adminpass) {
        echo "<a href=\"$PHP_SELF?action=submit&delid=$db[id]&offset=$offset&poffset=$poffset$adminlink\"><img src=\"$image_dir/icons/trash.gif\" alt=\"$moderator_del_action\" border=\"0\" align=\"right\"></a>";
        echo "<a href=\"$PHP_SELF?action=submit&delcommentid=$db[id]&offset=$offset&poffset=$poffset$adminlink\"><img src=\"$image_dir/icons/trashcomment.gif\" alt=\"$moderator_del_comment\" border=\"0\" align=\"right\"></a>";
        echo "<a href=\"$PHP_SELF?action=submit&commentid=$db[id]&offset=$offset&poffset=$poffset$adminlink\"><img src=\"$image_dir/icons/comment.gif\" alt=\"$moderator_edit_comment\" border=\"0\" align=\"right\"></a>";
                    echo "<div class=\"spaceleft\">&nbsp;</div>\n";
    }
    echo "        $gb_posted $when</div><hr><div class=\"mainleft\">".censor_msg($db[message],($admin==$adminpass))."</div>\n";
    if($commentid == $db[id] && $action!="changed" && $admin==$adminpass) {
      echo "  &nbsp;&nbsp\n";
      echo "  <form action=\"$PHP_SELF?action=submit\" method=\"post\">\n";
      echo "     <input type=\"hidden\" name=\"admin\" value=\"$admin\"><input type=\"hidden\" name=\"commentid\" value=\"$commentid\">\n";
      echo "     <input type=\"hidden\" name=\"offset\" value=\"$offset\"><input type=\"hidden\" name=\"poffset\" value=\"$poffset\">\n";
      echo "     <div class=\"comment\"><textarea name=\"comment\" cols=\"".($text_field_size-5)."\" rows=\"5\">".decode_msg($db[comment])."</textarea>\n<BR>";
      echo "     <input type=\"submit\">&nbsp;&nbsp;<a href=\"smiliehelp.php\"
                            onClick='enterWindow=window.open(\"smiliehelp.php\",\"Smilie\",
                            \"width=250,height=450,top=100,left=100,scrollbars=yes\"); return false'
                            onmouseover=\"window.status='$smiliehelp'; return true;\"
                            onmouseout=\"window.status=''; return true;\">$smiley_help</a></div>\n";
      echo "  </form>\n";
    } elseif(!empty($db[comment])) {
      echo "  &nbsp;&nbsp<div class=\"comment\">".$gb_modcomment.$db[comment]."</div>\n";
    }
    echo "      </td>\n  </tr>\n";
    }

    # End of Page reached
    #################################################################################################

    echo"</table>\n";
    echo"</div>\n";
  }
  echo"        </td>\n";
  echo"       </tr>\n";
  echo"      </table>\n";
  echo"    </td>\n";
  echo"   </tr>\n";
  echo"   <tr>\n";
  echo"    <td>\n";
  echo"<br>\n";

  if ($show_sysinfo) {
    list($usec, $sec) = explode(" ",$proctime_start);
    $proctime_start = $usec+$sec;

    list($usec, $sec) = explode(" ",microtime());
    $proctime_end = $usec+$sec;
    $proctime = $proctime_end-$proctime_start;

    $query = mysql_db_query($database, "SELECT id FROM guestbook");
    $countall=mysql_num_rows($query);


    echo"<div class=\"footer\">Processingtime: ".substr($proctime,0,7)." sec., Entries: $countall, PHP Ver. ".phpversion()."</div>\n";
  }

  #  PLEASE DO NOT REMOVE OR EDIT THIS COPYRIGHT-NOTICE !!! THANKS !!! ################################################

  echo"<div class=\"footer\">phpBook Ver. $book_version &copy; 2001-".date("Y")." by <a href=\"http://www.smartisoft.com\" target=\"_blank\">SmartISoft</a></div>\n";
  #####################################################################################################################

  echo"    </td>\n";
  echo"   </tr>\n";
  echo" </table>\n";
  echo"</body>\n";
  echo"</html>\n";


}

#  Disconnect DB
#################################################################################################
mysql_close();

if ($support==$supportpwd && $supportpwd) {echo "<br><br>"; phpinfo();}

?>

--------------
rsdn




0
 
LVL 13

Assisted Solution

by:cLFlaVA
cLFlaVA earned 150 total points
ID: 12251763
This is a HUGE script.  There are about 10 separate instances of "Database Query Error."  What I suggest you do is search for "Database Query Error" in your script, and in each instance of the string, add a number.  For example, the first would be Database Query Error1, the second would be Database Query Error2 and so on.  This way, you'll be able to tell which query is being called that returns an error.

Which line do you get the error on after this?
0
 
LVL 26

Accepted Solution

by:
Umesh earned 200 total points
ID: 12257112
Hi rsdn,

Add below line after the mysql_db_query() /mysql_query()
print mysql_error();  

This would show you the exact cause..

0
 
LVL 16

Author Comment

by:Sohel Rana
ID: 12257327
Hi cLFlaVA and ushastry:

Thanks for your help. I installed a different script and it's working perfect. I think the problem is with the previous guestbook script. I award points because I learn something from both of your about mql. :)

Thanks again.

rsdn
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question