The following new message has been posted on Phorm Support Forum at <http://www.phorm.com/support/>. *************************************************************************** MESSAGE: (#2433) PROBLEM ON DBFETCH <http://www.phorm.com/support/?rev=2433> AUTHOR: Robyn DATE: March 26, 2003 at 4:12 a.m. EST I'm making a registration form, but i want to ask my customer to enter a valid Product ID first, if the product id is not on my database list ("valid_prod_id" table), the registration will not be process. I'm going to store all information gathered in the form into a separate table ("registered" table), if the product id is already on the table(registered), I will notify him that they must register the product only once and the product id he entered is already registered (showing details to whom registered the program). here's my config which i'm still struggling to work it out. <?php $PHORM_FROM = ph_DECLARE; $PHORM_INFONLY = true; $PHORM_RCONFIG = "Y"; $PHORM_VALDEFS = "rule1.txt"; $PHORM_PARSPHP = true; $DPass = "pw"; $DUser = "user"; $DHost = "localhost"; $DBase = "dbname"; $PHORM_MYTABLE = "product_id"; $PHORM_DBFETCH = "prod_id"; [field name of the IDs in table] $PHORM_DBWHICH = "prod_id='$PID'"; [$PID - is my form fieldname where customer will enter the valid ID] if ($db_prod_id = $PID) { $PHORM_ACK = "index21.html"; [continue the registration] } else $PHORM_ACK = "index22.html"; [notify them that there's a prob on their entries etc.] ?> I have tried searching the same situation as mine but i cant find any. Would appreciate your help and would be very much if you could provide me in details how to do it. Thanks in advance. Robyn *************************************************************************** This is an automatically-generated notice. If you'd like to be removed from the mailing list, please visit Phorm Support Forum at <http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx If you wish to respond to this message, please post your response directly to the board. Thank you! ------------------------------------------------- You are receiving this message because you are subscribed to the Phorm mailing list. To send messages to the mailing list, simply send email to phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe from the list by sending email to phorm-request@xxxxxxxxxxxxx with 'unsubscribe' in the SUBJECT field.