[PHP-DB] mysql connect error

2003-08-12 Thread John Byrne
Hi, I've just started playing with Linux/MySQL/PHP - I come from a Windows/ASP/PowerBuilder background. I have created a database in MySQL and now are trying to connect to it via PHP. I keep getting the same error, no matter what I specify in DSN. I always get: DB Error: no such database The

[PHP-DB] Pivot tables

2003-08-12 Thread Dillon, John
Here is the worth-reading mysql answer to my question below. Pity it's implemented on perl not PHP though...anyone know a PHP implementation? I will need to generate a pivot table similar to that in Excel, in this version I want to list a unique list of fields across

Re: [PHP-DB] % operator

2003-08-12 Thread Doug Thompson
One day I'll learn to wait until two cups of coffee before attempting to post replies. On top of which, I have no idea where 0.8 came from. 8-/ Sorry for the confusion factor. Doug On Tue, 12 Aug 2003 10:47:21 +0100, Phil Driscoll wrote: On Tuesday 12 August 2003 10:39 am, Phil Driscoll

Re: [PHP-DB] Maximum execution time of 30 seconds exceeded

2003-08-12 Thread CPT John W. Holmes
I'd agree with what someone else said about keeping a separate table full of possible pin numbers. Fill it with all of the pin numbers to begin with, add in a building or department row so you know what sequences go with what building, etc. Then, to get a pin number for someone, you can just: