Blocking HTML code in inserts?

Hey all, What is the most effective way to block HTML code in insert statements? I have a client with a comments form that is being bombarded with people inserting references to their own sites, etc, and I need an effective way to filter basically any HTML tags at all. Thanks, Skip

Re: MySQL won't start with external bind-adress in my.cnf

he server binding to 192.168.1.250 3) 192.168.1.250 port forwarding to public addres 4) External OpenOffice.org successfully connecting to the database. Thanks! You guys got me pointing the right direction and all is good now. Chaim Rieger wrote: Skip Evans wrote: Chaim Rieger wrote: Skip Ev

Re: MySQL won't start with external bind-adress in my.cnf

Chaim Rieger wrote: can you post the output of ifconfig please I should have noted that 192.168.1.250 on bge1 is configured for port forwarding to the public IP address of the server. -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http

Re: MySQL won't start with external bind-adress in my.cnf

Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 ether 00:30:48

Re: MySQL won't start with external bind-adress in my.cnf

Gerald L. Clark wrote: Does that IP address resolve to your hostname? Yes, it does. -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http://bigskypenguin.com =-=-=-=-=-=-=-=-=-= Check out PHPenguin, a lightweight and versatile PHP/MySQL, AJAX & D

Re: MySQL won't start with external bind-adress in my.cnf

Hey Chaim, I'm sorry, I don't know what you mean by "default route". I am only familiar with the current contents of my.cnf, and mods were made according to instructions I found via Google. I don't see this noted in MySQL anywhere. Is this a network-wide configurat

MySQL won't start with external bind-adress in my.cnf

/tmp/mysql.sock port = 3306 basedir = /usr datadir = /usr/local/mysql tmpdir = /tmp language = /usr/local/share/mysql/english/ bind-address = 192.168.xxx.xxx log = /var/log/mysql.log # skip-networking My server has two nics, one for internal access at the 192.168.xxx.xxx address, and another for ext

Re: Need help counting player with lowest score for each week.

ER BY DATE, place ASC ) as A GROUP BY A.date) AS B GROUP BY B.playerid ORDER BY Bubbles DESC; Thomas 'Skip' Hollowell wrote: How do I simply find out who the bubble is now in my db now that we track more than 1 $0 person. I need just the person with $0 in the amount column with the l

Need help counting player with lowest score for each week.

a.playerid = players.playerid GROUP BY A.playerid ORDER BY Bubbles DESC; Anyone? Skip. -- -- Table structure for table `results` -- CREATE TABLE results ( ID int(11) NOT NULL auto_increment, playerId int(11) default '0', date datetime default NULL, locationId int(11) default NULL, pl

ODBC Problems

database will no longer function. I am using Mdac2.5 skip

general purpose database cleanup tools (design patterns or Python)?

cause none of the three functions are separate. Before I launch into a complete redesign, I thought I'd see what already exists. This can't be a problem unique to our environment. Thx, -- Skip Montanaro ([EMAIL PROTECTED]) Support Mojam & Musi-Cal: http://www.musi-cal.com/spo

Re: date_format

It's (sort of) obvious what Cindy is looking for... In slightly clearer terms, is it possible to format a selected date using a format string similar to that available in C's strftime() function - where %M might stand for month name, %d might stand for day number, etc. regards, P On Wed, 17 J

Re: ISAM to MYISAM

I've just done this myself, and had no problems whatsoever. I upgraded from 3.22 to 3.23... 1. Compile mysql 3.23 2. Shutdown mysql 3.22 server 3. (Carefully) do a make install of 3.23, ensuring your data files in ~mysql/var are not over-written 4. Restart mysql server (3.23) 5. Go through each t

Re: Your favorite Windows MySQL GUI client?

While I'm much more a Perl devotee than PHP, I've been using phpMyAdmin and am fairly happy with it. If you happen to have PHP available, I'd give it a try. On Mon, 15 Jan 2001, Philip Mak wrote: > Hello, > > What is your favorite Windows MySQL GUI client? I'm developing a database > driven web

Re: Windows to Unix

Keep in mind as well that datafiles for anything earlier than 3.23 are rarely compatible between different architectures...you'll need to do a mysqldump unless you're myisam tables in 3.23.x regards, P On Mon, 15 Jan 2001, Scott Baker wrote: > You can use MySQL dump. However, copying the file