[PHP-DB] Re: File Uploading to database

2002-02-04 Thread Ric Manalac
hi, straying from technical solutions, have you checked for any spelling error? looking at what you pasted in the mailing list, you have: $query = "INSERT INTO Canidate" shouldn't Canidate be Candidate instead? then... VALUES ('$FirstName', '$LastName', '$Industry' '$Address1', 'Address2', '$C

[PHP-DB] postgres optimization

2001-11-25 Thread Ric Manalac
hi, for php-db list users, i'm not sure if this is off-topic. please inform me if it is. i'd like to ask anyone who have worked with PostgreSQL for any advise on how to optimize its performance. i have a database that has a few tables. one of which may contain more than 50,000 records in the fut

Re: [PHP-DB] background process

2001-10-29 Thread Ric Manalac
hi, thanks for the reply. i will look up docs that discuss cron. i'm sorry but i didn't get what you mean by "m/c". please explain. thanks! regards, ric DL Neil wrote: > > has anyone here created an application using > > background processes? what i have in mind > > is to be able to run the b

[PHP-DB] background process

2001-10-29 Thread Ric Manalac
hi everyone, has anyone here created an application using background processes? what i have in mind is to be able to run the background process once a day to check for files that are more than 5 days old and delete them. thanks in advance. regards, ric -- =

[PHP-DB] executing system commands

2001-10-25 Thread Ric Manalac
hi, i'm a newbiew php developer. i'm trying to execute a system command in one of my php scripts. what i would like to do is to create a directory. my code goes like this: // chunk of code starts here $directory = generate_sessionid(); $command = "mkdir /home/httpd/html/miroku/downloads/$directo

[PHP-DB] NEXTVAL(serial)

2001-09-26 Thread Ric Manalac
hello. i've seen DEFAULT NEXTVAL(serial) being used in some examples but i have not seen an explanation of what it exactly does. can anyone please explain what it is and how it can be used? i have some idea but i want to make sure by asking other people. thanks! ric -- =