Knowledge Base Contributions

Below is a list of the knowledge base entries that Nathan Wallace has contributed to:

Page:  1 2 3 4 5 
• How can I choose an element from a list at random?
  How can I choose an element from a list at random?
  

• How can I use Python to start the default web browser on Win32?
  How can I start other Windows programs from Python?
  

• How can I use a Microsoft Access database from Python?
  

• How can I catch an error in re.compile?
  How can I test for a bad regular expression?
  

• I'm new to Python, where should I start?
  Can you give me an overview of the Python Documentation?
  Do I need books to learn Python?
  Is there Python documentation available in languages other than english?
  

• How can I determine if a string is contained in a bigger string?
  How can I find the position of a substring in a string?
  

• Are there any Python functions to help with linear algebra?
  What is numpy used for?
  

• Why can I run an executable program using "python prog.py" but not as "./prog.py"?
  

• From where do i get the libraries of Oracle 8i on linux apcahe to be used by PHP
  

• how can i compile php with mcrypt correctly? i tried, but failed.
  

• How does assignment work in Python?
  

• Does pythonwin support adsi?
  

• How can I extract information from other web sites using Python?
  Are there any tools to help me process HTML using Python?
  

• What is the difference between __repr__() and __str__()?
  What is __repr__ used for?
  What is __str__ used for?
  

• How can I write a script to count visitors to a web page?
  Are there any Python counter scripts available?
  

• How can I use the Microsoft Foundation Classes from Python?
  What is pythonwin?
  Should I use pythonwin or wxpython?
  

• How can I get the class of an object instance?
  What are some functions to help me use classes in Python?
  

• How can I rename a file using Python?
  How do I move a file from one directory to another in Python?
  

• What is the best and fastest way to scan a whole list of foldersto see if something has been added or not?
  

• Where can I get some good introductory examples of Python code?
  

• How can I read and interpret email attachments using Python?
  How can I read and interpret email attachments using Python?
  

• How can I send a binary file attachment using smtplib?
  

• How can I backup all users and passwords if I'm using vpopmail?
  

• Can I use inetd and tcpserver on the same machine?
  What is the difference between inetd and ucspi-tcp?
  

• How can I streamline the process for adding symbolic links to Maildir with new users?
  

• How can I stop a given host from sending too much mail in a set time period?
  Can I use frequency of mail from a host to help control spam?
  

• How can I send a copy of all mails to another account?
  Why is mail getting forwarded, but not appearing on the server machine?
  

• What is /var/qmail/control/badmailfrom used for?
  Is it possible to block incoming mail to all users from a certain domain?
  

• Why do I have a "DON'T DELETE THIS MESSAGE -- FOLDER INTERNAL DATA" message?
  

• How can I debug my program that tests qmail users and passwords?
  

• What's the best way to deliver mail to both a mailbox and a program?
  

• What are my options for HTML parsing?
  

• Where can I find the most complete list of freely downloadable Python Modules?
  

• Why are the database fields all written on top of one another when doing queries in my terminal?
  

• Is there a ORACLE - PHP dedicated mailing list?
  

• How can I rename a database?
  

• Does REPLACE have a multi-row form like INSERT?
  

• What causes error 24, too many open files?
  How can I increase the number of file descriptors available on linux?
  

• Can I use MySQL with my mail server to store users?
  

• Are indices used for numeric comparisons on string fields?
  

• What does the error "Found old style password for user" mean?
  How can I fix things if I didn't use the PASSWORD() function when inserting passwords?
  

• Why does tinyint show a size of 4 bytes in mysqlshow when it only needs 1 byte in the database?
  What is the difference between a signed and an unsigned tinyint?
  

• How can I insert the current time as a field in a record?
  Does MySQL insert the current timestamp automatically for a NULL argument to a timestamp field?
  

• How can I execute SQL statements in a text file inside MySQL?
  Can I use a file as input to the mysql monitor program?
  Using a Win 32-System is it necessary to set the Path-variable to mysql, if you want to use the batc
  

• What do the MySQL version levels mean?
  What's the difference between alpha, beta, gamma and stable?
  When should I upgrade to the latest alpha / beta version?
  

• Is there a CVS server for mysql where I can always getthe current version?
  

• Is it possible to recover some row after a DELETE, or is it gone and lost for ever?
  Does mysql have an undelete capability?
  

• How can I use IP chains to limit external access to MySQL?
  How can I run MySQL behind a firewall?
  

• Where can I get old versions of the MySQL manual?
  

• What do I need to be aware of when the connection to the MySQL server is slow?
  Will updates over a slow remote connection hold locks for a long period?
  

• Where can I find information on database design?
  

• How can I store a picture in MySQL?
  Should I use a blob to store an image in the database?
  Should I store images in a database or as files?
  How can I get an image (or blob field) back out of the database and into a file?
  

• Why does mysqlshow not display the contents of a table which has an underscore in it's name?
  How do wildcard characters work in mysqlshow?
  

• Does MySQL support sequences?
  Are the values from auto_increment always unique?
  Are auto_increment values monotonic?
  

• Is there any way to get the row id of each row in a Select clause?
  

• How can I rename a column in a table?
  How can I change a field name?
  

• How do I open a directory located on a remote machine (WinNT), with proper permissions?
  

• How can I fetch remote POP messages and inject them in the local server?
  What is fetchmail used for?
  

• It looks like the timestamp from qmail is wrong, what's happening?
  What timezone does qmail use for timestamping messages?
  

• Is there an equivalent of the unix "mail" program to read Maildir boxes?
  

• What are some big or famous sites using qmail?
  

• What files do I need to delete to remove a message from the queue?
  

• If I have to, what is the best way to kill qmail-send?
  

• How can I delete a lot of spam mail from the qmail queue?
  

• How can I setup a spammers file to delete matching spam mail automatically?
  setting a spammers file to delete matching spam mail automatically for all users on the system?
  

• How can I virus scan all incoming mails before delivery?
  

• How can I capture key presses?
  

• What are prototypes?
  What is prototype inheritance?
  

• Is it possible to create a method within a session object?
  

• How can I show an IFRAME in IE and an ILAYER in NN?
  Do IFRAMEs or ILAYERs allow scrolling?
  

• How can I pass arguments to a function through to a second function?
  

• How can I automatically close all open layers?
  

• JavaScript: How can client-side JavaScript retrieve the HTML of the file that it's in?
  

• How can I set the title of a HTML page?
  

• How can I add OPTIONs to a SELECT list?
  How can I delete OPTIONs from a SELECT list?
  I did not understand How to delete item from select online
  

• How can I draw colored rectangles using DHTML?
  Can I draw barcodes using Javascript and DHTML?
  

• How can I change the URL of a frame?
  How can I make a frame display a different URL?
  

• How do I get the height /width of the client area of the browser window?
  How do I find the outer width/height of a window?
  

• How can I grey out a text field?
  

• How can I change the display element of an attribute?
  

• How can I redirect people based on the page they came from?
  Can I create a page that only accepts links from one other page?
  

• Do PHP3 or PHP4 support Windows Component Object Model framework?
  

• test again for plus signs
  

• test for plus signs
  

• How do I set up a cron job on Linux?
  

• Is there a BOOLEAN type in MySQL?
  How can I create a column with a boolean type?
  

• How can I add new items to an ENUM field?
  

• How can I ensure the referential integrity of MySQL tables?
  

• What's a quick and easy way to check if MyODBC is correctly installed?
  

• How can I stop the DELETE command from working on a table?
  Can I stop users from deleting rows from a table?
  

• How can I serialize resource intensive queries?
  

• Why does EXPLAIN say "Impossible WHERE noticed after reading const tables"?
  Does EXPLAIN work on a table with no rows?
  

• How can I use reserved words as table or column names?
  

• How can I fix a 'Too many connections' error?
  

• What's the best way to automatically check and repair MySQL tables?
  

• Why can't I change varchar columns in a table to be type char?
  How can I make my table use char columns instead of varchar?
  

• How can I setup a monitoring service to check that MySQL is always running?
  

• How do I run MySQL under windows?
  This entry is related only to NT or can be applied to Windows 98 too ?
  

• How can I compile and run MySQL under Tru64 4.0D?
  

• Is "FOREIGN KEY REFERENCES" implemented in the new versions of MySQL?
  

• Why does my REPLACE statement say that two rows were affected?
  How can I check if REPLACE actually replaced, or in fact inserted a new row?
  

• Can I access old row values in a REPLACE statement?
  

• Why do I get lots of backslashes when I use "SELECT ... INTO OUTFILE"?
  Why does "INTO OUTFILE" escape backslashes?
  

• Is there a performance hit for doing the duplication check on UNIQUE keys when doing inserts?
  

• What database wrappers are available?
  

• Is include() a cheap operation?
  

• Is it bad PHP style to set an object variable directly?
  Should I write get and set methods for my objects?
  

• What does include() do?
  Does the include() function return a value?
  Is there a function which allows me to include another file statically
  

• What causes the ODBC error 'Data source name not found and no default driver specified'?
  

• How can I stop PHP from parsing the rest of a script?
  How can I safely display code entered by a user?
  

• How can I make a drop down select list of URL's that jumps automatically?
  How can I make a select list that automatically redirects to a different page?
  

• How do I install PHP on windows 2000?
  

• Why does 0 == 'hello' in PHP?
  Does PHP use types when doing comparisons?
  

• What does the error 'Column count doesn't match value count' mean?
  

• How can I work out the difference (in number of days) between two dates in yyyy-mm-dd format?
  

• Can I install both PHP3 and PHP4?
  Why would I install multiple versions of PHP simultaneously?
  Can I install multiple cgi versions of PHP?
  

• Does PHP run faster on NT than unix or is the speed comparable?
  

• Can one do function overloading in PHP as in Java?
  

• Can I install mod_php and mod_ssl together?
  

• How can I handle unselected checkboxes in PHP scripts?
  How can I give unselected checkboxes a value?
  

• Can I make PHP force me to declare variables before using them?
  Does PHP have an equivalent to Visual Basic's 'option explicit' command?
  

• Can I create an alias to PHP files not in the web folder when using Win 98 and PWS?
  

• How can I get the time and date in a different time zone?
  

• How do I build dynamic websites with PHP and templates?
  

• Do functions have to be defined before they are used?
  

• What's the easiest way to pass variables between PHP and Javascript?
  

• How can I show rows from a database in a table with alternating colors?
  How can I use the Modulus Operator in PHP?
  In a search result, how do you change the table (with the results) row color every result?
  

• How do I setup PHP for XML support under Windows?
  How can I use the XML functions on Windows?
  

• How do I use the xml_parse_into_struct() function?
  How can I get XML data into an array?
  

• How can I determine if an array contains a value?
  What is the in_array() function for?
  

• How can I keep session variables?
  Can I see a quick example of sessions in PHP4?
  

• Why do I get a parse error after the last line of PHP or HTML?
  

• How can I do Kerberos authentication from PHP?
  

• How do conditionals work?
  How can I include an if statement inside a command?
  

• How can I standardise an address from PHP?
  

• What's the best way to design a single PHP page for a form and it's submission?
  How can I check if a form was submitted to trigger a page?
  

• How can I get the row with the highest value of a field?
  

• How does the HTTP/1.1 protocol reuse connections?
  

• Why does Apache work with 127.0.0.1 but not localhost under windows?
  Where is the hosts file on Windows?
  

• How do I setup to use the XML functions on Windows?
  

• How can I generate bar codes from PHP?
  

• How can I detect if the database is down?
  

• Will using DSO's for mod_perl decrease memory usage significantly?
  What uses most of the memory when running mod_perl?
  

• Where can I find a list of mod_perl web hosting companies?
  

• How do I access MySQL from Visual Basic?
  Where can I get an ODBC driver to access MySQL from Visual Basic?
  

• How do I handle the error 'Got error 27 from table handler'?
  

• Is there a MySQL for IBM OS/390 UNIX?
  

• Is it possible to use LIMIT and count(*) for the total number of rows?
  What number of rows is returned when the LIMIT clause is used?
  

• Is there a limit on the size of MySQL tables?
  Can I create a table greater than 4GB in size?
  

• Where can I get an example C program using MySQL?
  

• How can I access MySQL from Java?
  

• Do I need to create the table before using mysqlimport?
  Does mysqlimport create tables?
  

• Can I include the MySQL logo in my client distributions?
  

• Is RAND() recalculated for every row in a query?
  

• What is the difference between standard function arguments and passing by reference?
  When should I pass function arguments by reference?
  

• Why does PHP_SELF contain php.exe?
  Why do my URL's contain php.exe?
  

• How can I get the name of the user logged in using HTTP authentication?
  What is the REMOTE_USER apache variable for?
  

• How do I change the IP address of a Linux box when it moves from host A to host B?
  

• How do I setup PHP on Solaris 7?
  

• How can I get the class name of an object?
  

• Why do I get this error '403.1 Forbidden: Execute Access Forbidden' with PWS?
  

• Can I change NT registry settings from PHP / Apache?
  

• Can I create symbolic links using PHP?
  

• When uploading binary files, some bytes are become corrupted, but file size isnt changing, why?
  

• Do I have to close database connections at the end of my scripts?
  

• How can I get a listing of all the MySQL reserved words?
  

• How can I copy a table from one database to another?
  

• Can I limit the number of simultaneous connections on a per-user basis?
  How can I stop some users from hogging all connections?
  

• Does auto_increment fill in blank spaces?
  

• Why do I get 'Unspecified Error' when I select a varchar column with all blanks using MyODBC and ASP?
  

• Can I run multiple MySQL daemons on the same database files?
  

• How can I remove profanity from a string?
  How can I censor selected words from a string?
  

• How do I setup so mail() will work under windows?
  I changed my php.ini file as SMTP= smtp.mail.yahoo.com,but it gives a server problem,why?
  

• Where can I find documentation on adding internal functions to PHP?
  

• Are PHP variable names case sensitive?
  

• How can I select rows from a database with a field between two dates?
  

• Are the results of readdir() sorted?
  

• Does return in an include file stop the entire script?
  

• What pages need to be secure when accepting credit cards?
  What sequence of pages should I use for credit card transactions?
  

• Can I connect to a NNTP server from PHP?
  

• How can I get the size of an IMAP message?
  

• How can I force users to choose at least one checkbox from a group?
  

• Is there a way to pretokenise PHP scripts?
  

• Why does my browser try to save rather than open my PHP scripts?
  

• How do you restore from a mysqldump in MySQL?
  

• What permissions should I set for database files?
  What user and group should own the database files and directories?
  

• How can I setup PHP with XML support?
  Where do I use the configure command --with-xml?
  

• When installing from RPMs, how can I change the directory where the database files reside?
  

• How can I check and repair database tables?
  

• How can I see the field types for all columns in a table?
  What does DESCRIBE table_name do?
  

• How can I select only positive numbers from a varchar field?
  How can I select only numbers from a varchar field?
  

• How can I let users upload files and store them in a database?
  How do I insert a client-side file into a BLOB in an Oracle or mySQL database?
  

• How can I get PHP to create javascript that updates field 2 based on field 1 in a select box?
  

• How can I echo all the keys and values of an array?
  

• What's the best place to get IMAP documentation?
  What should I read before using the IMAP functions?
  

• How can I remove all instances of a character from a string?
  

• How can I put the contents of received emails into the database automatically?
  

• How do global variables and functions work?
  Do I declare global variables at the top level or inside functions?
  

• How can I make a page to show system statistics?
  

• Why does echo("help\n") not create a newline?
  

• How can I strip / remove all HTML and PHP tags from a string?
  

• Why are my uploaded files always zero (0) bytes?
  

• How can I add a column to a table?
  

• Why does my PHP CGI installation always get the error 'No input files specified'?
  What httpd.conf changes do I need to make for a PHP CGI installation?
  

• Can I disable an internal PHP function?
  

• How can I move a database from Access 2000 to MySQL?
  How to solve "division by zero" error while importing data from a text file using LOAD DATA INFILE?
  

• How can I limit the size of MySQL databases?
  

• How can I convert a MySQL database to Oracle?
  What problems might I face converting between Oracle and MySQL?
  

• How can I reverse the sort order when using ORDER BY?
  What are the ASC and DESC keywords for?
  

• How can I copy a table or table structure?
  Can I use mysqldump to print out table definitions?
  

• How can I update many columns of a row with a single query?
  

• Using Perl/DBI how can I check if SELECT returns no rows?
  

• How can I do simple text indexing on a blob column?
  How can I search for words in a blob field?
  How can I simulate a search engine and look for words in blob fields?
  

• How should I do equality testing on floats?
  Why won't WHERE a = 3.12 find the matching rows?
  

• Is there a quick way to check that all form fields were entered?
  

• How can I backup a MySQL database through PHP only?
  Can I backup my database using PHPMyAdmin?
  Is it possible to create a PHP script to backup a mySQL database?
  Is it possible to create a PHP script to backup a mySQL database?
  

• Is there a limit on the size of GET and POST requests?
  What are the differences between GET and POST?
  

• How can I do permanent sessions or authorization with PHPLIB?
  

• How do I delete a cookie?
  

• Can a column name contain spaces?
  How do I use a column name containing spaces in a query?
  

• How do I do a JOIN statement?
  How do I handle join statements where the same column name is in multiple tables?
  

• Does MySQL automatically create an index for primary key columns?
  

• How can I work out the type of error from an error number?
  What does perror do?
  

• What does the error 'Host XXX is not allowed to connect to this MySQL server' mean?
  

• How can I use an apostrophe (') in a query string?
  How do I escape single quotes in MySQL queries?
  

• Is there a version of the MySQL server for OpenVMS?
  Can I run the MySQL client on VMS?
  

• Which is faster, a massive OR statement or using IN?
  

• Why does Access seem to crash with larger OLE objects?
  

• Why do I keep getting errors when using MyODBC with Access 2000?
  

• I have access to the user table, how can I reset a forgotten root password?
  How can I reset MySQL permissions?
  

• Why does rand() keep returning the same numbers?
  How do I create a seed value for the rand() function?
  

• Can I write to the start of a file without overwriting it?
  

• How can I check if a browser is accepting cookies?
  

• How can I use PHP to return an image?
  What HTTP headers do I need to set to return an image from PHP?
  How can I store images in a Postgres database?
  in Non_Server Client Site to get a variable from Server Client Site e.g. HTML get a result from PHP
  

• Why can I run a script on the command line but not from PHP?
  Why can I use C to system call PHP and httpd fork PHP, but can't use httpd fork C to call PHP ?
  

• How can I access data of form elements with php without having to submit the form to another script?
  

• When I try to copy files from remote servers, some servers return quickly, but others force me to wait a long time or return nothing. Why?
  

• Does PHP work on Novell?
  

• Where can I get help installing and configuring the PHP CGI v3.0.14?
  

• Why does require($file_name) in a loop just include the first file repeatedly?
  

• Do any search engines index .php files?
  

• Why does php3.exe crash when calling odbc_do with no errors logged or explanation when I try to query a SQL Server 7.0 database?
  How can i search for a pattern , the data stored in a image datatype, i used to store long text data
  

• How can I call an ancestor's constructor method?
  

• Is there a manual for SQL available?
  

• How can I install the free Sybase Client Library?
  

• How to do a select multiple?
  

• Can I reuse IDīs that were created by a MySQL auto_increment field and later deleted?
  

• How can I create variables that are available in all scripts?
  How can I create an array to access from various scripts without passing it using GET or POST?
  

• How do I setup PHP to use the MCAL functions?
  How do I use the MCAL functions?
  

• I have php-postgresql installed, how do I configure for mysql in redhat 6.1?
  How can I setup PHP to use both MySQL and Postgres?
  

• Can I hide my PHP code?
  

• What do I need to install to connect to a remote Oracle server from PHP?
  How do I setup and use PHP to connect to a remote Oracle server?
  

• Can I use the header() function to pass a HTTP authentication user name and password?
  Can I pass HTTP header parameters from the client browser to the server?
  

• Is there a port of PHP for the Macintosh?
  

• After connecting to MySQL using PHP, only MYSQL_QUERY() works. If I try to use MySQL_num_rows, I get a parse error. What am I doing wrong?
  

• How can I stop Frontpage wrecking the php code in a html page?
  

• How can I securely send credit card numbers from the server to the store owner?
  How do I use email to send credit card numbers safely?
  

• Why does my browser freeze when uploading files to the server?
  Can I give show progress to users when uploading files?
  Why do large textarea posts hang?
  Why do large textarea posts hang?
  

• What does the error 'Warning: 1 is not a valid MySQL-Link resource' mean?
  

• How can I redirect the user to a relevant page after executing PHP code?
  

• How do I implement a variable variable?
  

• Are there any tools to help convert from Cold Fusion/Access to PHP3/MySQL?
  

• How can I define the character set for a page?
  

• How do I check the PHP current date against a differently formatted date, such as DD/MM/YYYY?
  

• How can I read all unix processes from PHP?
  Can I kill unix processes from PHP?
  How can I insert a sudo command in a php script? I inserted it as $fun="sudo less ~home/guest/aa.txt
  
  
  Page:  1 2 3 4 5