Advanced Guest Book Help PLEASE............ :)

Hello...
Could you please help me with the following:

1. Is there a way to chane the colour of the text at the top that says...

Thursday, 27. May 2004 01:56 AM
Welcome to the ~Beserk Clothing~ Guestbook Beserk Home Guestbook
Total Records: 3 Records Viewed Per Page: 20

I have a black background and I can't work out how to change this text colour from black.

2. I have amended my dropdown menu as shown in another forum topic on here but i am getting the following error message:

Query Error

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

MySQL Error : Query Error
Error Number: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'http://www.beserkclothing.com/index, 20' at line 1
Date : Thu, May 27, 2004 01:10:56
IP : 203.221.67.225
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.beserkclothing.com/guestbook/
PHP Version : 4.3.4
OS : Linux
Server : Apache/1.3.29 (Unix) mod_perl/1.26 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.4 FrontPage/5.0.2.2634 mod_ssl/2.8.16 OpenSSL/0.9.7a
Server Name : www.beserkclothing.com

Does anyone know what this could be from ... any help would be greatly appreciated. I have look everywhere and don't know what i have done.

Thankyou sooo much for your help to anyone that has the time to help me!! you rule!! have a great day!
XX

Re #2

Did you get your instructions from here?

http://proxy2.de/forum/viewtopic.php?t=2867&sid=bd9b313fbd0c759f0783692f056ed870

The font colour is set in Administration | Style Settings. Since you've set it to #000000 all the fonts will default to that.

You can override that setting by opening header.php and looking for

.font2 { font-family: $VARS[font_face]; font-size: $VARS[tb_font_2]; color: $VARS[text_color] }

in the style sheet. If you want white, change it to

.font2 { font-family: $VARS[font_face]; font-size: $VARS[tb_font_2]; color: #FFFFFF }

You probably should change it in success.php too

There are other font classes in the style sheet as well e.g. .font3 You may have to so something similar with those.

In case you have to revert to the old files, be sure to save them as some other name before you change them

.font2 is also used in other parts of the guestbook - I'm not sure exactly where. If it happens to be used in a section where you have a white background, you won't see the text.

If that's so, ratehr than changing the style sheet, you may have to eliminate class="font2" from the table cell(s) that contains the black text that you currently can't see and use a font tag instead.

Yes that is where I got the info for the drop down menu change.

hmmm.. that font changing sounds confusing.. maybe I should just change my background colour unfortunately.

Thanks for your comments.

Not sure, but try moving

<script language="Javascript">

</script>

within the head tag. Right now it's above the opening <html> tag.

The other thing I'm not sure of, and this probably isn't having any effect on your current problem, is when I look at the source code I see

<select name="entry" onChange="urlJump('self',this)" class="select">
<option value="http://www.beserkclothing.com/" class="select">Beserk Home</option>
<option value="0" selected>Guestbook</option>
<option value="0" selected>Guestbook</option>
</select>
<input type="submit" value="Go" class="input">

It's showing 2 options with a value of 0. You may want to investigate that also

I read this thread, I think I've got the same problem at
http://www.yiyan.com/GuestBook/index.php.

I suspect - we have copied the code for AG 2.2 while we both have version AG 2.3. If you look at the new code, the very first line after

function generate_JumpMenu() {

is

$menu_array[] = "<select class=\"formbutton\" name=\"entry\" class=\"select\">";

vs. in the old version

$menu_array[] = "<select name=\"entry\" onChange=\"urlJump('self',this)\" class=\"select\">";

I don't know php much, I wonder if this is the problem...

Please help!

---
Yiyan