[PHP-DB] - Delete records in an Access DB

Hi all, I have this problem: I want to delete records in an Access DB. I use this code: $query="DELETE FROM Test_Table WHERE name='franco';"; // the connection parameters $path="d:/inetpub/webs/my_site/mdb-database/" ; $db_name="test.mdb" ; $dsource=$path.$db_name ; $cn_string="Provider=Mi

[PHP-DB] lamer noob with repeat question

Hello everyone, I've been working on (read:tearing my hair out over) my mom's website for some time now. Specifically, I'm trying to get her work order database up and running. The basic idea is this: you start out adding a new record by going to add.php. It sees that you've not done anything y

RE: [PHP-DB] - Delete records in an Access DB

Match Case ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, May 02, 2004 09:19 To: [EMAIL PROTECTED] Subject: [PHP-DB] - Delete records in an Access DB Hi all, I have this problem: I want to delete records in an Access DB. I use this code: $query=

[PHP-DB] (Fwd) Procedure for submitting an order via email

Actualy I've the problem that the content of the basket will not be added to the variable for the mailbody. Only the receiver-adress and the formfields will be added to the email. The code is attached. How can I add a second variable for the mailbody that will be printed out correctly to monitor

[PHP-DB] ODD results - help please

select a.name, b.category_id cat, b.name category, e.category_id jcncat, b.typecattype from tblCompany a, tblCategory b,jcnCategoryCompany e where ((e.company_id = a.company_id and b.category_id = e.category_id and b.type <> 'NONE')         or b.type = 'NONE') and a.company_id <> 1 group

[PHP-DB] Email Archiver???????

Does anyone know of a good email archiver written in PHP?? ~WILL~ __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- PHP Database Mailing List (http://www.php.net/

[PHP-DB] The usual problem

Whats worng with this? $sql = "INSERT INTO underskrifter (id, type, navn, epost, tid, ip, domain, sted) " . " VALUES ( '', '$_POST[type]', '$_POST[navn]', '$_POST[epost]', '$tid', '$ip', '$host', '$_POST[sted]' );" . " "; mysql_query($sql); ??? First I tryed the usual INSERT s

RE: [PHP-DB] The usual problem

Looks OK to me What error do you get ? try $sql = " INSERT INTO underskrifter ( id , type , navn , epost , tid , ip , domain , sted ) VALUES ( '' , '$_POST[type]' , '$_POST[navn]' , '$_POST[epost]' , '$tid' , '$ip' , '$host' , '$_POST[sted]' ); "; mysql_query($sql) or die (mysql_error());

[PHP-DB] RE: [tcphp] Hella fun project I'm about to throw at some tech col lege students

Hi List. A quick question. I have some categories that are really long and I would like to re-word or re-format them when I am bring data in from a DB. Now which would be better: Do it with PHP or Do it with MySQL Any suggestions as to how to? Example: A column name: Customer --> VARCHAR Val

RE: [PHP-DB] RE: [tcphp] Hella fun project I'm about to throw at some tech college students

Hi If the reformating is complex - ABVDFR Co is in the middle of the field - then php $bits = explode (" ", $FieldValue ) ; then each element of $bits is a word, making reworking it easier Just my 2p worth :) Peter > -Original Message- > From: Rafi Sheikh [mailto:[EMAIL PROTECTED]