line

Add to any feed reader

Delete leadaing zero in number less than one (no replies)

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…)

where statement, field starts with A thru M (no replies)

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…)

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…)

Dell Studio Hybrid PC - Slot Load DVD - HDMI - Optional Blu-Ray

A “sexy” little number from Dell for those wanting a low-priced desktop PC. (more…)

Microsoft .NET Micro Framework 3.0 Beta Started

The Microsoft .NET Micro Framework 3.0 Beta has started. (more…)

« Previous PageNext Page »