data model, tips for online dictionary

2001-08-23 Thread David Mintz
y SELECT translation FROM english_terms WHERE term = 'usurious' and so on. I can envision offering the user the option of searching for a term that "is", "begins with", or "contains" what they type into a textfield. But again, I wonder if anyone has any ad

Re: '/tmp/mysql.sock' (111)

2001-08-03 Thread David Mintz
its installed, > and if yes, why this error? > AFAIK it means php support for mysql is installed. > thanks, what needs to ben done? Write the code to access your database, and execute it. Check php.net/docs.php for further info HTH David Mintz Spanish Interpreter US District Court, S

Re: Writing 100+ fields with Perl DBI

2001-07-31 Thread David Mintz
is numeric rather than string. ### my @values; for (qw(name city ) ) { push @values, $dbh->quote($asmt->param($_)); } for (1..100) { push @values, $asmt->param("Q$_"); } my $values = join (",",@values); $dbh->do("insert into your

Re: Database Security

2001-07-30 Thread David Mintz
here a good way to protect the passwords ? Somebody already suggested one way. Another way is to store your passwords in an included file which lives somewhere outside your www directory, such as $HOME/inc Another way is to use php-cgiwrap and chmod your scripts to 700. HTH David Mintz Span