This seems like it should be simple, but I haven’t figured out a way to do so. I’m trying to show the winning percentage of sports teams expressed to thousands (e.g. .625). The key is that I need to eliminate the leading "0" which is returned (e.g. 0.625) when I use number_format() - e.g. number_format($pct_nonconf, 3). Any solution needs to preserve the unit digit if a team is undefeated (1.000).
Any help is appreciated! (more…)
hi all -
having this: mysql_query("SELECT * FROM menu ORDER BY cat ASC"),
i’m trying to retrieve records where ‘cat’ starts with anything from A to M.
can anyone help a chap out?
Thanks much,
GN (more…)
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…)
From time to time I am getting error:
Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/hotmouse/public_html/includes/functions/database.php on line 19
Unable to connect to database server!
Which shutdown mysql until I would have manually restart it, how track which script could cause that and track it down ? (more…)
PDO_MYSQLND: The new features of PDO_MYSQL in PHP 5.3
http://blog.ulf-wendel.de/?p=193 (more…)