Thanks to every one that gave their inputs in order to solve my problem. It
was solved with a simple SQL statement using a sub-query like:
insert into products (id, code, desc, everused) select distinct '',
code,desc, everused from catalog
Now my products table has only 8500 records!!
I know this may be a bit off-topic, but I would like to use the PEAR library
to implement some of my database functions. Unfortunately, the PEAR
documentation is woefully incomplete and as a result i've been unable to
install it properly. Here's the procedure i went through:
PHP Version: 5.1.2
I remember the quick install/test I did using PEAR and I kind of had a similar
experience, but I figured out what the issue was for me.
PEAR installed perfectly but doing the pear install thing where it pulls the
package down and puts it where it needs to put it, I was doing what you were
Hi All
I have two tables with columns of times that it took to perform tasks eg:
8:40
6:50
8:30
10:55
-
34:55 total time taken to complete the tasks in hours and minutes
I am able to add the times with sql however I need to add the totals to cone
up with a grand total and because
Hi All
I have two tables with columns of times that it took to perform tasks eg:
8:40
6:50
8:30
10:55
-
34:55 total time taken to complete the tasks in hours and minutes
I am able to add the times with sql however I need to add the totals to cone
up with a grand total and because