line

Add to any feed reader

Can´t connect to MySQL thru PHP on WinXP

I feel like I’ve tried everything. I’ve got copies of libmysql.dll all over the place, same with php_mysqli.dll and php_mysql.dll. The php.ini is in my C:\Windows directory, with the following extensions enabled thusly:

extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll

MySQL seems to be working fine. I use Navicat and I can see my data dandy. PHP seems to be working fine too. A call to phpinfo shows lotsa stuff, though no mention of mysql. A snippet(I’m no php expert) like

if (mysql_connect(’localhost’,'root’,'mypassword’)) {
if (mysql_select_db(’mysql’)) (more…)

Re: Month to Year convert

129 months is FLOOR(129/12) years and (129 MOD 12) months. Is that what you are looking for? (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…)

Yahoo`s Wild Future

For the first time in a long time there are more stories in the media about Yahoo than Google. With Terry Semel stepping down from the CEO position everyone is wondering where the venerable search engine is headed. In this article we ll take a look at some possible scenarios….

Search Engine Strategies Summer - Register Today San Jose, CA - August 20-23 - Learn and network with the Internet Search Experts - our 9th Year (more…)

The Importance of Building Links

Links make the World Wide Web go round. Links are how we get from place to place on the web and they re the vehicle that allows us access to an infinite amount of information. Links also give us more traffic to our sites. This article will explain why you should increase the number of links to your site and how to do it….

Travel & Hospitality Industry Web Marketing Event Space is Limited - Register Today for SES Travel - Seattle July 26 & 27 - click for more info (more…)

Next Page »