Re: [PHP-DB] replace question

Chris Payne wrote: Hi there everyone, I'm pulling some sensitive data from a MySQL DB with PHP and the clients wants the first x amount of numbers displayed on the screen to be xx etc ... rather than the numbers, but wants the last 6 to be displayed, is there an easy way to do this? I

Re: [PHP-DB] Can't compile Oracle's 10g support in PHP5

The --with-oracle option is a long deprecated interface to Oracle and no-one has updated the configure script to work with Oracle 10g. Can you use the new --with-oci8 option? Otherwise you'll need to update ext/oracle/config.m4. The code in ext/oci8/config.m4 may help. With either configure

[PHP-DB] PEAR - My hosting company killed it

Hi, I know this is the probably the wrong list for this question, but I'm a bit desperate as my hosting company has disabled PEAR on the server, and I was using it extensively on more than one website... suddenly my weekend looks like a coding nightmare. The hosting service reports a security

[PHP-DB] novice on table design

Hi all, I have the following tables EmployeeCustomernon-CustomerAddress ======= pkey pkeypkey pkey number type type ...

Re: [PHP-DB] PEAR - My hosting company killed it

I know this is the probably the wrong list for this question, but I'm a bit desperate as my hosting company has disabled PEAR on the server, and I was using it extensively on more than one website... suddenly my weekend looks like a coding nightmare. The hosting service reports a security issue,

Re: [PHP-DB] PEAR - My hosting company killed it. .

Dianne Mead wrote: Hi, I know this is the probably the wrong list for this question, but I'm a bit desperate as my hosting company has disabled PEAR on the server, and I was using it extensively on more than one website... suddenly my weekend looks like a coding nightmare. The hosting service

RE: [PHP-DB] novice on table design

The schema of your table is wrong, is you do bnormalize it you will find out that you need two tables for this approach. One table for your people and another one for the n addresses of your people. If you keep your current schema, you will have as many rows for one person as many addresses for

Re: [PHP-DB] novice on table design

Hi Miguel, Thanks for the reply. the non-customer is actually a Shop, so Employee, Customer and Shop are distinct enough to have their own tables. Now they all have an Address, and the problem is how do I allow multiple addresses for each these 'people' (without using a lookup table)