[paulyii]

I tried to install a php guest book for my HomePage..
well ..
i got a "PHP Error" message ..
it said :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a9301734/public_html/phpGuestBook/guestbook.php on line 450

where did went wrong ??
my "guestbook.php" ??

if it is the guestbook.php that went wrong..
then..
i will post the guestbook.php up here..

i really need someone to help me fix the error part ..

Thanks..
Regards.

[paulyii]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a9301734/public_html/phpGuestBook/guestbook.php on line 450

did it means this line ??

mysql_connect($server, $db_user, $db_pass);
$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=\"guestbook.php?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";

someone please help me fix the error ..
Thanks.

[s.j.hebert]

The problem is actually probably before that. $result will be undefined (and not a valid resource) if you are not connected to the database correctly.
Have you defined your $server, $db_user & $db_pass variables correctly somewhere? These should be the values listed in the cPanel phpMyAdmin area. Also does the table 'badwords' exist in that database?


Actually, after a second look..... what's $db and where is it defined?

[paulyii]

o-ps.. forgot to create the tables..
but .. when i paste the sql file at "SQL Query"..
this message came out ..

MySQL said: Documentation
#1067 - Invalid default value for 'id'

what went wrong in this sql file ??
please helps ! thanks

[paulyii]

by the way : here is the sql file

# -----------------------
#
# Table structure for table 'badwords'
#

CREATE TABLE badwords (
badword varchar(25) NOT NULL
);


#
# Dumping data for table 'badwords'
#

INSERT INTO badwords VALUES ( 'fuck');
INSERT INTO badwords VALUES ( 'schweinehund');
INSERT INTO badwords VALUES ( 'fucking');
INSERT INTO badwords VALUES ( 'shit');
INSERT INTO badwords VALUES ( 'piss');
INSERT INTO badwords VALUES ( 'cock');


# --------------------------------------------------------
#
# Table structure for table 'banned_ips'
#

CREATE TABLE banned_ips (
banned_ip varchar(15) NOT NULL,
PRIMARY KEY (banned_ip)
);


#
# Dumping data for table 'banned_ips'
#

INSERT INTO banned_ips VALUES ( '0.0.0.0');


# --------------------------------------------------------
#
# Table structure for table 'guestbook'
#

CREATE TABLE guestbook (
id int(5) DEFAULT '0' NOT NULL auto_increment,
name varchar(25) NOT NULL,
email varchar(35) NOT NULL,
icq int(11) DEFAULT '0' NOT NULL,
oicq int(11) DEFAULT '0' NOT NULL,
http varchar(50) NOT NULL,
message mediumtext NOT NULL,
timestamp int(11) DEFAULT '0' NOT NULL,
ip varchar(15) NOT NULL,
location varchar(35) NOT NULL,
browser varchar(150) NOT NULL,
comment mediumtext,
PRIMARY KEY (id)
);


#
# Dumping data for table 'guestbook'
#

INSERT INTO guestbook VALUES ( '1', 'Webmaster', 'webmaster@netone.at', '0', 'www.netone.at', 'Hi dear User <img src=images/smilies/smile.gif>
<BR>
<BR>The phpBook is great <img src=images/smilies/bounce.gif> leave us a Message in our Guestbook
<BR>
<BR>by(t)e Webmaster', '981136586', '0.0.0.0', 'A - Wien', 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)','');


# --------------------------------------------------------
#
# Table structure for table 'smilies'
#

CREATE TABLE smilies (
code char(3) NOT NULL,
file varchar(15) NOT NULL,
name varchar(25) NOT NULL
);


#
# 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');

[MilitaryGeneral]

Look at $database. Do you have the right database selected?

[paulyii]

Thanks for the respond..

i gave up ..
i install a GuestBook without the MySql
here it is .. a simple one, but easy to install !
http://www.tanxinyuan.co.cc/home/gue...guestbook.html

[John1]

Originally Posted by paulyii

did it means this line ??



someone please help me fix the error ..
Thanks.

i think you have server problem