line

Add to any feed reader

PHP 5.2.4 Released

The PHP development team would like to announce the immediate availability of PHP 5.2.4. This release focuses on improving the stability of the PHP 5.2.X branch with over 120 various bug fixes in addition to resolving several low priority security bugs. All users of PHP are encouraged to upgrade to this release. Further details about the PHP 5.2.4 release can be found in the release announcement for 5.2.4, the full list of changes is available in the ChangeLog for PHP 5. Security Enhancements and Fixes in PHP 5.2.4:Fixed a floating point exception inside wordwrap() (Reported by Mattias Bengtss (more…)

Re: Absolute PHP/MySQL rookie, need help step 1

In MySQL Administrator I granted all global privileges to the username I’m using. Still getting the same access denied. Boy this is frustrating. (more…)

Re: searching my entire database

UNIONS are woefully inefficient?

I’ve done something similar to what you are talking about. I grabbed uids from multiple tables using unioned multiple fulltext queries as a sub query and then I performed join on the sub query. It seemed to be relatively speedy.

Is there a better way to do fulltext queries across multiple tables? (more…)

End Query with \G instead of ;

You can use \G instead of ; for tables with lots of fields.

mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)

Add-Remove Options (DOM)

Add or remove objects in a select list, using the DOM. This script was written to work with DOM Level 1 and DOM Level 2 capable browsers, with try/catch logic included for IE use. (more…)

Next Page »